June 27th, 2000, 07:18 PM
Does anyone know a good way to dump all the existing records in one MySql table into another existing MySql table? Both tables are identical in structure, but the data fron Table1 needs to update all the data in Table2.
(I know how to do it one row update at a time, but because of the nature of the beast, I need it to do the whole table at once (13 rows), rather than one row at a time.)
June 29th, 2000, 09:12 AM
look in the mysql manual for
select * into outfile 'file.txt' from table1;
this will create a tab or comma delimited file that can then be loaded into table two with
load data infile 'file.txt' into table table2;
check the manual for exact syntax...