查询并批量插入数据的Sql命令

INTO student(id,xuesheng,yuwen,shuxue,yingyu) SELECT id,xuesheng,yuwen,shuxue,yingyu FROM stu;

实践：

insert into store_advertisings(id,title,PicListJson,edittime)
 (select s.Id,s.`Name` as name , ‘[]‘,NOW() from stores s left join store_advertisings d on s.Id= d.Id where d.Id is null)

 

查询并批量插入数据的Sql命令

标签：批量插入   tis   code   tle   null   insert   l命令   select   list