Need help creatin a table
Posted: Fri Jun 29, 2007 6:09 pm
hi all, I'm in phpMyAdmin and trying to create a table, here it is :
and this is the error that gave me, I've done this before, and i've never had that problem. Anyone knows?
Code: Select all
CREATE TABLE vehicle_inventory(
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
ccode NUMERIC( 15 ) ,
added NUMERIC( 10 ) ,
updated NUMERIC( 10 ) ,
viewed NUMERIC( 10 ) ,
numimages NUMERIC( 2 ) ,
stockCHAR( 20 ) ,
vinCHAR( 30 ) ,
year NUMERIC( 4 ) ,
makeCHAR( 20 ) ,
modelCHAR( 30 ) ,
conditionCHAR( 4 ) ,
categoryCHAR( 20 ) ,
mileageCHAR( 9 ) ,
priceCHAR( 15 ) ,
exteriorCHAR( 30 ) ,
interiorCHAR( 30 ) ,
bodyCHAR( 20 ) ,
doorsCHAR( 1 ) ,
ENGINE CHAR( 40 ) ,
fuelCHAR( 20 ) ,
transCHAR( 20 ) ,
stereoCHAR( 40 ) ,
comments TEXT
)Im using PHP Version 5.2.2 and phpMyAdmin - 2.10.1#1064 - 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 CHAR(4),
category CHAR(20),
mileage CHAR(9),
price CHAR(15),
e' at line 12