Overclock.net banner

Adding fields to MySQL table

386 Views 3 Replies 2 Participants Last post by  kyotejones
Really ******ed question, but I have forgot how to do this and can't actually find anywhere to help.

If i add a new field like so:

mysql> create table userquintin ( user_id int PRIMARY KEY NOT NULL UNIQUE AUTO_INCREMENT );
Query OK, 0 rows affected (0.00 sec)
How do i do multiple fields in one line rather than having to ALTER the table each time to add a new field?
1 - 2 of 2 Posts

· Premium Member
29,288 Posts
Discussion Starter · #3 ·
Just on seperate lines, how stupid of me. I knew it was something simple. Cheers
1 - 2 of 2 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.