mcubedma
09-13-2007, 11:43 AM
Hello. I'm new to developing databases and am having trouble creating the following table. I keep getting an error around line 14, but I can't find a syntax problem. I would appreciate any assistance available.
Thank you.
CREATE TABLE car_desc (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
car_id INT NOT NULL,
mbr_id INT NOT NULL,
date_added DATETIME,
date_modified DATETIME,
year YEAR,
model ENUM ('L','K','KA','KB'),
body_num VARCHAR (255),
engine_num VARCHAR (255),
designer VARCHAR (255),
builder VARCHAR (255),
body_style VARCHAR (255),
condition ENUM ('O','D','R','U','I','P','X'),
history VARCHAR (255),
photo BLOG
);
Thank you.
CREATE TABLE car_desc (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
car_id INT NOT NULL,
mbr_id INT NOT NULL,
date_added DATETIME,
date_modified DATETIME,
year YEAR,
model ENUM ('L','K','KA','KB'),
body_num VARCHAR (255),
engine_num VARCHAR (255),
designer VARCHAR (255),
builder VARCHAR (255),
body_style VARCHAR (255),
condition ENUM ('O','D','R','U','I','P','X'),
history VARCHAR (255),
photo BLOG
);