4.2.3 数据操纵(Manipulation)
4.2.3.1 INSERT
-
隐式全列插入:
INSERT INFO table_name
VALUES (value1, value2, ...) -
显式列名插入:
INSERT INFO table_name (column1, column2, ...)
VALUES (value1, value2, ...)
4.2.3.2 DELETE
DELETE FROM table_name
[WHERE condition]
一定不要忘记写条件语句,否则会删除所有 行!!!
4.2.3.2 UPDATE
UPDATE table_name
SET column1 = value1,
column2 = value2,
...
[WHERE condition]
一定不要忘记写条件语句,否则会更新所有行!!!