Insert columns from another table

Question

I'm not sure if I'm going the right way about this but I want to create another table with an auto increment ID.

I created another table but how do I add the columns from the first table into the new table and an auto increment ID?

Possible duplicate of [Copy data into another table](https://stackoverflow.com/questions/13237623/copy-data-into-another-table) — Nathan Hinchey, Oct 25 '17 at 16:06
I'm assuming you tried `INSERT INTO newtable SELECT * FROM oldtable`, not specifying the columns? — Nathan Hinchey, Oct 25 '17 at 16:10
Your tables are not identical, so you want to use the second suggestion from that accepted answer: `INSERT INTO newTable (col1, col2, col3) SELECT column1, column2, column3 FROM oldTable` — Nathan Hinchey, Oct 25 '17 at 16:14
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/157504/discussion-between-nathan-hinchey-and-tryingtolearn). — Nathan Hinchey, Oct 25 '17 at 16:18

score 0 · Answer 1 · answered Oct 25 '17 at 16:08

0

Basically this is the same as copying any table into another table, just be sure not to specify the ID column.

INSERT INTO newTable (col1, col2, col3)
SELECT column1, column2, column3
FROM oldTable

1 Answers1