Overclock.net banner

Adding fields to MySQL table

385 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:

Code:
Code:
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
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.
Top