Basic SQL Statements

basic.sql

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
);

SELECT column_name(s)
FROM table_name
WHERE some_column=some_value
ORDER BY column_name(s) ASC|DESC;

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

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value;

DELETE FROM table_name
WHERE some_column = some_value;