Adding fields to MySQL table
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:
How do i do multiple fields in one line rather than having to ALTER the table each time to add a new field?
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)
