En cours

Small project to move data between two mysql tables using php

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.

Compétences : MySQL, PHP

Voir plus : project to work on, data query, mysql insert multiple records, insert multiple records, small data table, rows insert, mysql multiple insert, php insert select, mysql inserted, php mysql query multiple, insert mysql table, mysql tables rows, mysql schema, query project data, php insert multiple records mysql, php mysql small project table, script mysql query php, jumpist, mysql php insert script, small project mysql, follow unfollow using php jquery mysql, project query, create dynamic table using php ajax mysql, ajax search using php jquery mysql, move www

Concernant l'employeur :
( 14 commentaires ) Istanbul, Turkey

N° du projet : #2378764

Décerné à :

chienthuatxd

I can do it, please pm for me

30 $ USD en 0 jours
(28 Commentaires)
4.7

10 freelance ont fait une offre moyenne de 62 $ pour ce travail

rinsadsl

I can help you on this

40 $ USD en 1 jour
(193 Commentaires)
6.7
zeke

Available to start immediately and finish as soon as possible.

50 $ USD en 0 jours
(145 Commentaires)
6.8
yunuscse

I could understand your requirements. I can do it perfectly. Please view my PM. Thanks

50 $ USD en 1 jour
(73 Commentaires)
6.2
mdjavedakhtar

hi we can do this in few hours please check pmb

30 $ USD en 1 jour
(23 Commentaires)
5.6
bogdanperian

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 ;)

80 $ USD en 2 jours
(17 Commentaires)
5.2
pollux1er

I can help you doing this project!

50 $ USD en 1 jour
(26 Commentaires)
4.5
MatKauton

I can do it in PHP.

35 $ USD en 1 jour
(6 Commentaires)
3.1
puneethmech

I can do this..

100 $ USD en 4 jours
(1 Commentaire)
2.5
deitysoft

HI please check your PMB.

150 $ USD en 4 jours
(1 Commentaire)
1.2