# 四大操作語句 ## 1.刪 DELETE ~~~ DELETE FROM 表 WHERE 條件 ~~~ ## 2.增 INSERT ~~~ INSERT INTO 表(字段列表) VALUES(值列表) ~~~ ## 3.改 UPDATE ~~~ UPDATE 表 SET 字段=值,字段=值... WHERE 條件 ~~~ ## 4.查 SELECT ~~~ SELECT * FROM 表 WHERE 條件 ~~~ ## 子句 WHERE 條件 ~~~ WHERE id=1 WHERE age>18 WHERE age<=18 WHERE age>=18 AND score<60 WHERE age>18 OR score<60 ~~~