插入记录 INSERT INTO table_name (column1,column2,...) values ( value1,value2, ...); 示例 insert into emp (empno,ename) values(9500,'AA'); 把 一个表中的数据插入另一个表中 INSERT INTO <table_name> <SELECT 语句> 示例 create table a as select * from emp where 1=2; insert into a select * from emp where sal>2000;