1.插入查询结果
INSERT INTO table_name(field11,field12,...field1n)
SELECT (field21,field22,...field2n)
FROM table name2
WHERE....
举例 INSERT INTO t_dept(dname,loc)
SELECT dname,loc
FROM t_loader;
2.更新数据记录
(1)更新特定数据记录
UPDATE table_name
SET field1=value1,
field2=value2,
field3=value3,
WHERE CONDITION
举例 UPDATE t_dept
SET loc='shangxi2'
WHERE dname='cjgongdept1';
(2) 更新所有数据记录
UPDATE table_name
SET loc='shangxi8'
WHERE deptno<6;