数据操作语言(DML)包括INSERT、UPDATE、DELETE等增删改命令
数据插入
INSERT INTO student_0 (id,sname) VALUES (1,'青衫码客');
结果集插入
INSERT INTO student_2(id,sname) SELECT id,sname FROM student_0;
更新数据
UPDATE student_0 SET id=2,sname='青衫码君' WHERE id=1;
MERGE INTO student_3
USING student_0
ON (student_3.id=student_0.id)
WHEN MATCH THEN UPDATE SET student_3.sname=student_0.sname
WHEN NOT MATCH THEN INSTER (student_3.id,student_3.sname)VALUES(student_0.id,student_0.sname);
删除数据
DELETE FROM student_3 WHERE id=2;