怎么写mysql insert into select循环语句

Answer 1

This can only be done using a cursor, or a loop like PHP

Answer 2

If you use python, you can use executemany, refer to http://dev.mysql.com/doc/conn...

But the amount of data you have is not very large, so it doesn’t matter if you use for to traverse the insert

Answer 3

Write a stored procedure and use a loop to do it. . You can pass the first character array to the stored procedure. . .