Commands
CRAETE TABLE tablename (column1 definition1, column2 definition2, ...)
CREATE TABLE invoices (inv_no INTEGER NOT NULL, inv_date DATE, inv_custno INTEGER NOT NULL, inv_address TINYTEXT)
INSERT INTO tablename (column1, column2 ...) VALUES(value1, value2 ...)
INSERT INTO invoices (inv_no, inv_date, inv_custno, inv_address) VLAUES('1', '20060912' '134 Some Street')
CRAETE TABLE tablename (column1 definition1, column2 definition2, ...)
CREATE TABLE invoices (inv_no INTEGER NOT NULL, inv_date DATE, inv_custno INTEGER NOT NULL, inv_address TINYTEXT)
CRAETE TABLE tablename (column1 definition1, column2 definition2, ...)
CREATE TABLE invoices (inv_no INTEGER NOT NULL, inv_date DATE, inv_custno INTEGER NOT NULL, inv_address TINYTEXT)
Next article: HTML forms