Data Manipulation Language数据操纵语言
添加记录
INSERT INTO table_name ( field1, field2,...fieldN )
VALUES
( value1, value2,...valueN );
-- 用查询结果插入
INSERT INTO TABLE_NAME(F1,F2,F3) SELECT (E1,E2,E3) FROM TABLE WHERE.....
修改记录
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]
删除记录
DELETE FROM table_name [WHERE Clause]