MySQL Forums :: Newbie :: help with a script

the sql statement

create table accounts (id int not null auto_increment primary key) ;

that is the only line that is working so far.

using the syntax from that for the next line:

(username varchar(30) not null)

creates a syntax error on the username in the statement.

/Joakim