To hopefuly clarify to you some things.
to merge two tables with any chance of good result:
1. they have to have identical structure
2. merged table must have the same structure as the source ones
3.Imagine you have only one field in both source tables, and only one record and contence of it is in both 'john doe'
4. what do you expect in merged table ?
The second option would be choice for most people on this forum.
Hence the merged table has to have index !
In order that insert ignore command would work --> prevent duplictaes of 'john doe' in merged table.
And as you showed, there is no key/indexes in your source table. If you have a table with 1000 and one with 200, they should merge with no prob into 1200 records table.
Of course there will be a mess with id-s, ....
There, I told you same as old pedant, from another angle, hope it helps.
Last edited by BubikolRamios; 03-22-2013 at 04:31 AM..