SQL SELECT語法整理

假設有以下資料表 class, classmain, teacher, student, dept, tea, stud ~ (1) SELECT * FROM CLASS; (2) SELECT sid, cid FROM CLASS; (3) SELECT sid AS s, cid AS c FROM CLASS; (4) 模擬SELECT INTO語法 (MYSQL不支援SELECT INTO) INSERT INTO myclass (class_no,class_name) SELECT cid, classname FROM classmain; (5) SELECT * FROM classmain WHERE cid>'C004'; (6) SELECT * FROM class WHERE score>60 AND cid='C005'; (7) SELECT * FROM class WHERE cid='C005' AND NOT score>60; (8) SELECT * FROM class WHERE score IS NULL ; (9) SELECT * FROM class WHERE score IS NOT NULL; (10) SELECT * FROM classmain WHERE classname LIKE 'data%'; (11) SELECT * FROM classmain WHERE classname LIKE 'data%' OR classname LIKE '%mgm'; (12) SELECT * FROM classmain WHERE cid IN ('C001','C003','C005'); (13) SELECT * FROM classmain WHERE cid NOT IN ('C001','C003','C005'); (14) SELECT * FROM