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