怎么在insert into语句中使用select答:Insert into Table1 values('赵','asds','90')Insert into Table1 values('钱','asds','100')Insert into Table1 values('孙','asds','80')Insert into Table1 values('李','asds',null)GO select * from Table2 --3.INSERT INTO SELECT语句复制表数据 Insert into Table2(a, c, d...
mysql insert中使用select答:INSERT INTO aa (a, b, c, d, e, f, g, h)SELECT id as a, title, c, d,e, f, g, h FROM b WHERE id = 1 这样子可以运行 就是 批量插入的意思 将B表符合条件的记录 插入到aa表中