9 minutes ago, musicmaster said:Do you mean that in the old table the order is id-name and in the new one name-id? Yes, that and missing fields in one of the tables are handled correctly.
One thing that can cause problems is when the new table has a unique key that in the old one wasn't unique.
not, i mean when oldtable has fields
.png.022b5452a8f28f552bc9430097a16da2.png)
id_name,
field2,
field3,
field4
and newtable has fields
field2,
id_name,
field3,
field4
as you can see, the same fields but different position.
4 minutes ago, musicmaster said:Do you mean that in the old table the order is id-name and in the new one name-id? Yes, that and missing fields in one of the tables are handled correctly.
One thing that can cause problems is when the new table has a unique key that in the old one wasn't unique.
not, i mean when oldtable has fields
id_name,
field2,
field3,
field4
and newtable has fields
field2,
id_name,
field3,
field4
as you can see, the same fields but different position.
2 minutes ago, musicmaster said:Do you mean that in the old table the order is id-name and in the new one name-id? Yes, that and missing fields in one of the tables are handled correctly.
One thing that can cause problems is when the new table has a unique key that in the old one wasn't unique.
not, i mean when oldtable has fields ( id_name, field2, field3, field4) and newtable has fields (field2, id_name, field3, field4), as you can see, the same fields but different position.