Adding fields to MySQL table

385 Views 3 Replies 2 Participants Last post by kyotejones, Mar 8, 2009

98uk

Discussion Starter · #1 · Mar 8, 2009

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

kyotejones

· Registered

Joined Mar 31, 2007

·

308 Posts

#2 · Mar 8, 2009

http://dev.mysql.com/doc/refman/5.1/...ate-table.html

Code:

Code:

CREATE TABLE tablename ( 
col_01 datatype,
col_02 datatype,
col_03 datatype
);

kyotejones

· Registered

Joined Mar 31, 2007

·

308 Posts

#4 · Mar 8, 2009

it can be on the same line. I just like doing it like that because it is easier to read.

Code:

Code:

CREATE TABLE tablename ( col_01 datatype, col_02 datatype, col_03 datatype );

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.