mysql批量插入规律数据

mysql批量插入规律数据

 

Sql代码    www.2cto.com  

insert into CPPRADAR( SITEID, RADARNAME, RADARDESC, PARENTID,     

 RADARTYPE, RADARQUERY, RADARCONFIG, CRUSER, CRTIME, OPERUSER, OPERTIME, LEAF) 

 

select 001, replace(a.RADARNAME,&＃39;互动&＃39;,&＃39;博客&＃39;) radarname, &＃39;博客&＃39;,  a.RADARID  ,3, substr(b.RADARQUERY,6,6) , &＃39;条件&＃39;, &＃39;admin&＃39;, CURDATE(), &＃39;admin&＃39;, CURDATE(), 1  from  

 

(select * from CPPRADAR where RADARDESC=&＃39;互动&＃39; ) a inner join   

(select * from CPPRADAR where RADARDESC= &＃39;新闻&＃39; and status=0) b  

 

on a.parentid = b.parentid