Forum Moderators: open

Message Too Old, No Replies

create table query

what is wrong with this?

         

chameleon3

8:34 pm on Apr 20, 2006 (gmt 0)



create table subjects (email CHAR (25), fname CHAR (25), lname CHAR (25), condition ENUM ('1', '2'), pretest_score SMALLINT (2), posttest_score SMALLINT (2), time_stamp TIMESTAMP, PRIMARY KEY (email));

it returns:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition ENUM ('1', '2'), pretest_score SMALLINT (2), posttest_score SMALLINT (' at line 1

Thanks