发布于 4年前 MYSQL批量插入数据(A->B) INSERT INTO TABLE1 ( field1, field2, field3, ··· ) SELECT value1, value2, value3, ···from TABLE2 WHERE 1 = 1