Im using MySQL/phpMyAdmin.
Ive got 2 identically structured tables. How do I update and add to all the records from one table with the other?
In the old table some rows have been added and some rows have been changed. All of these - together with all the other rows - need to be inserted into the new table.
Do I Empty the table first and then somehow insert the old records in there? I need everything to be identical - even the primary key ID.