How can I alter a temp table?
Posted
by William
on Stack Overflow
See other posts from Stack Overflow
or by William
Published on 2010-03-12T17:33:55Z
Indexed on
2010/03/12
17:37 UTC
Read the original article
Hit count: 307
Filed under:
sql
I need to create a temp table, than add a new int NOT NULL AUTO_INCREMENT field to it so I can use the new field as a row number. Whats wrong with my query?
SELECT post, newid FROM ((SELECT post`test_posts`) temp ALTER TABLE temp ADD COLUMN newid int NOT NULL AUTO_INCREMENT)
© Stack Overflow or respective owner
