My problem is this: I have extracted data from MySQL using mysql front (about 400 INSERT statements) and what to insert the data to a remote MySQL Database. how can I do this without writing each one individually ?? The remote Server does not allow MySQL access other than through PHP.
Please send me a message if you have any ideas.
Cheers All.
Hi,
normally following should work:
INSERT INTO tbl_name (col1,col2) VALUES (1,2),(3,4),(5,6);
wizkid
PS: Have a look at the mySQL INSERT syntax.
