插入单行数据 insert into "表格名" ("栏位1","栏位2",...) values("值1","值2",...) 插入多行数据 insert into "表格名" ("栏位1","栏位2",...) values("值1","值2",...),("值1","值2",...),("值1","值2",...); 从其他表copy数据 insert into "表格名1" ("栏位1","栏位2",...) select "栏位3","栏位4",... from"表格2";