Jump to content

HELP: DEADLINE TODAY, Syntax Error


webmedium

Recommended Posts

The mySQL query is as follows:

 

 


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 am not sure what the error is, it is the same if I add single quotes around the field names or not....I don\'t know what I am not seeing...

 

Thanks

Link to comment
Share on other sites

Try this

 

CREATE TABLE listings( 

id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY , 

PROPERTY_NM CHAR(15) , 

BEDROOM_NB TINYTEXT, 

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 , 

COMMENT_TX TINYTEXT, 

CONTACTCITY_NM TINYTEXT , 

CONTACTSTATE_CD TINYTEXT, 

CONTACTZIP_CD SMALLINT( 5 ) , 

COVEREDPARKING_ID TINYTEXT , 

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 ) 

) 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.