All Questions
1 question
17
votes
1
answer
24k
views
Autoincrement primary key in CREATE TABLE ... AS SELECT
I created table using a complicated select query via CREATE TABLE ... AS SELECT.... How can I add an autoincrement primary key in this query?
For example:
create table `user_mv` select `user`.`...
- 663