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