Shulou(Shulou.com)05/31 Report--

How to insert regular data in bulk in mysql? for this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Sql code

Insert into CPPRADAR (SITEID, RADARNAME, RADARDESC, PARENTID

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

Select 001, replace (a.RADARNAME 'interaction', 'blog') radarname, 'blog', a.RADARID, 3, substr (b.RADARQUERY.6), 'condition', 'admin', CURDATE (),' admin', CURDATE (), 1 from

(select * from CPPRADAR where RADARDESC=' interaction') an inner join

(select * from CPPRADAR where RADARDESC= 'News' and status=0) b

On a.parentid = b.parentid

This is the answer to the question about how to insert regular data in bulk in mysql. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.