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,'互動','博客') 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