mySQL code problem..

[jonese]

Anyone see anything wrong with this code?

CREATE TABLE 3psub (ID INT not null AUTO_INCREMENT, 3PID INT not null , sub VARCHAR (220) not null , descrip LONGBLOB not null , price VARCHAR (220) not null , contract ENUM (y,n) DEFAULT 'y' not null , PRIMARY KEY (ID))
MySQL


i'm getting:

MySQL said: You have an error in your SQL syntax near 'y,n) DEFAULT 'y' not null , PRIMARY KEY (ID))' at line 1

please respond to jonese@atlantech.net

[Hierophant]

Originally posted by jonese
Anyone see anything wrong with this code?

CREATE TABLE 3psub (ID INT not null AUTO_INCREMENT, 3PID INT not null , sub VARCHAR (220) not null , descrip LONGBLOB not null , price VARCHAR (220) not null , contract ENUM (y,n) DEFAULT 'y' not null , PRIMARY KEY (ID))
MySQL


i'm getting:

MySQL said: You have an error in your SQL syntax near 'y,n) DEFAULT 'y' not null , PRIMARY KEY (ID))' at line 1

please respond to jonese@atlantech.net

change it to:
CREATE TABLE 3psub (ID INT not null AUTO_INCREMENT, 3PID INT not null , sub VARCHAR (220) not null , descrip LONGBLOB not null , price VARCHAR (220) not null , contract ENUM ('y','n') DEFAULT 'y' not null , PRIMARY KEY (ID))

[jonese]

thanks wayne i changed it to 'Yes','No' and that worked. phpMYadmin must be funky.