DDL (CREATE, DELETE)
CREATE TABLE IF NOT EXITS t_student (name text, age integer);
CREATE TABLE IF NOT EXITS t_teacher (name, age);
DROP TABLE IF EXITS t_student;
DML
INSERT INTO t_student (name, age) VALUES ('jinming', 24);
UPDATE t_student SET name = 'jindong', age = 23 WHERE price < 1000;
DELETE FROM t_student ;
DQL
SELECT * FROM t_student ORDER by name DESC, age ASC;
外鍵: 一張表的某個字段引用著另外一張表的主鍵 (一對多, 外鍵加在奪得那端)
