We have this table which has over 30 million rows. We would like to move data from this table to another table with the exact same schema.
The data needs to be moved using "SELECT" and "INSERT"
Important: We cannot use "INSERT... SELECT".
We want to use INSERT with multiple records:
[url removed, login to view]
And the number of records which can be selected and inserted at the same time has to be a parameter.
So for instance if we want to work on "10" rows at a time, the php script will pull the next 10 records from the initial table in one query.
Then in a following query it will insert 10 rows in one query.
Attached is the table schema.
10 freelance font une offre moyenne de $62 pour ce travail
Cheers, mate :) I accepted the two project and will start working ASAP on them. I think I'll finish them all today. Including this one, if it's no problem for you ;)