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