[webmedium]

The mySQL query is as follows:

PHP Code:

CREATE TABLE listings(

`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
PROPERTY_NM CHAR( 15 ) ,
BEDROOM_NB TINYTEXT( 1 ) ,
MINIMUMRENT_AT TINYINT( 4 ) ,
MAXIMUMRENT_AT TINYINT( 4 ) ,
MINIMUMBATHROOM_NB CHAR( 1 ) ,
MAXIMUMBATHROOM_NB CHAR( 1 ) ,
MINIMUMSQUAREFEET_NB TINYINT( 4 ) ,
MAXIMUMSQUAREFEET_NB TINYINT( 4 ) ,
URL_NM CHAR( 85 ) ,
IMAGEURL_NM TINYTEXT( 54 ) ,
COMMENT_TX TINYTEXT( 983 ) ,
CONTACTCITY_NM TINYTEXT( 7 ) ,
CONTACTSTATE_CD TINYTEXT( 2 ) ,
CONTACTZIP_CD SMALLINT( 5 ) ,
COVEREDPARKING_ID TINYTEXT( 1 ) ,
GARAGEDIRECTACCESS_ID CHAR( 1 ) ,
GARAGEDETACHED_ID CHAR( 1 ) ,
ASSIGNEDPARKING_ID CHAR( 1 ) ,
GATEDCOMMUNITY_ID CHAR( 1 ) ,
ONSITEPATROL_ID CHAR( 1 ) ,
PLAYGROUND_ID CHAR( 1 ) ,
POOL_ID CHAR( 1 ) ,
JACUZZI_ID CHAR( 1 ) ,
FITNESSCENTER_ID CHAR( 1 ) ,
TENNISCOURT_ID CHAR( 1 ) ,
RACQUETBALLCOURT_ID CHAR( 1 ) ,
CLUBHOUSE_ID CHAR( 1 ) ,
BUSINESSCENTER_ID CHAR( 1 ) ,
LAUNDRYFACILITY_ID CHAR( 1 ) ,
ELEVATOR_ID CHAR( 1 ) ,
STORAGE_ID CHAR( 1 ) ,
WHEELCHAIRACCESS_ID CHAR( 1 ) ,
DOGSALLOWED_ID CHAR( 1 ) ,
CATSALLOWED_ID CHAR( 1 ) ,
FURNISHED_ID CHAR( 1 ) ,
BALCONY_ID CHAR( 1 ) ,
YARD_ID CHAR( 1 ) ,
WASHERDRYER_ID CHAR( 1 ) ,
WASHERDRYERHOOKUP_ID CHAR( 1 ) ,
INTRUSIONALARM_ID CHAR( 1 ) ,
AIRCONDITIONING_ID CHAR( 1 ) ,
CEILINGFAN_ID CHAR( 1 ) ,
REFRIGERATOR_ID CHAR( 1 ) ,
DISHWASHER_ID CHAR( 1 ) ,
GARBAGEDISPOSAL_ID CHAR( 1 ) ,
MICROWAVE_ID CHAR( 1 ) ,
HARDWOODFLOOR_ID CHAR( 1 ) ,
CARPETING_ID CHAR( 1 ) ,
FIREPLACE_ID CHAR( 1 ) ,
WALKINCLOSET_ID CHAR( 1 ) ,
VAULTEDCEILING_ID CHAR( 1 ) ,
HIGHSPEEDINTERNET_ID CHAR( 1 ) ,
CABLEREADY_ID CHAR( 1 ) 
) 

MySQL said: 


You have an error in your SQL syntax near '(1), MINIMUMRENT_AT TINYINT(4), MAXIMUMRENT_AT TINYINT(4), MINIMUMBATHROOM_NB CH' at line 1 


I get the same error even if I remove the single quotes. What is the syntax error , anyone have an idea or see what I am missing?

Thanks

[aus]

You don't want to specify a length with TEXT columns:

BEDROOM_NB TINYTEXT,

Not

BEDROOM_NB TINYTEXT(1),

If you want to specify length of a character string column use

CHAR(xx)

instead of TEXT