mysql批量插入规律数据_MySQL

bitsCN.com
mysql批量插入规律数据 Sql代码      insert into CPPRADAR( SITEID, RADARNAME, RADARDESC, PARENTID,      RADARTYPE, RADARQUERY, RADARCONFIG, CRUSER, CRTIME, OPERUSER, OPERTIME, LEAF)  select 001, replace(a.RADARNAME,'互动','博客') radarname, '博客',  a.RADARID  ,3, substr(b.RADARQUERY,6,6) , '条件', 'admin', CURDATE(), 'admin', CURDATE(), 1  from   (select * from CPPRADAR where RADARDESC='互动' ) a inner join   (select * from CPPRADAR where RADARDESC= '新闻' and status=0) b   on a.parentid = b.parentid   bitsCN.com