Question about unite-merge 2 tables
Hello .
I have 2 tables with the same name, under the same database name in 2 pc's , but now i want to combine then in to a 3rd one that will contain all the data together.
I used this query to achieve this :
CREATE TABLE movemetsAll SELECT * FROM (SELECT * FROM movement1 UNION ALL SELECT * FROM movement2) AS movemetsAll
But the produced table doesnt have a primary key,and the records id's are not auto increment.
For example the 1st table has 5 reconds, and the 2nd 3, the result table from the union its like this :
1
2
3
4
5
1
2
3
So it doesnt assign new ids to the new table which would be like
1
3
4
5
6
7
8
How can i do the trick? Pls help me :)
Thank you in advance