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

delete from cms_article_cat;

insert into cms_article_cat (article_id, cat_id) (SELECT a.article_id, '11' FROM  cms_article a);

SELECT * from cms_article_cat

SELECT * from cms_article
 

 

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)

insert deyouyun_notices_local.deyouyun_sms_statistics(id, IdentificationCode, StoreId,RemainSmsCount, SendSuccessCount, UpdateTime, CreateTime,SendChargeSuccessCount) (select uuid(), s.IdentificationCode, s.Id, 200, 0, NOW(), NOW(), 0 from deyouyun_store_dev_local.deyouyun_stores s left JOIN deyouyun_notices_local.deyouyun_sms_statistics st
on s.Id = st.StoreId where st.StoreId is null)

 

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