SQL Syntax

SQL Syntax is a unique set of rules and guidelines. This lesson describes all the basic SQL Syntax.

SQL Syntax Rules

• SQL statements always start with the keywords.
• SQL statement ends with a semicolon.
• SQL is not case sensitive, means the update is the same as UPDATE

SELECT Statement

SELECT column_name(s) FROM table_name

SELECT Statement with WHERE Clause

SELECT [*] FROM [TableName] WHERE [condition1]

SELECT Statement with WHERE AND/OR Clause

SELECT [*] FROM [TableName] WHERE [condition1] [AND [OR]] [condition2]...

SELECT Statement with ORDER BY

SELECT column_name()
FROM table_name
ORDER BY column_name() ASC or DESC

INSERT INTO Statement

INSERT INTO table_name (column, column1, column2, column3, ...)
VALUES (value, value1, value2, value3 ...)

UPDATE Statement

UPDATE table_name
SET column=value, column1=value1,...
WHERE someColumn=someValue

DELETE Statement

DELETE FROM tableName
WHERE someColumn = someValue