MySQL Forums
Forum List  »  Newbie

SQL Table Error
Posted by: Cameron Habib
Date: August 17, 2005 02:28PM

Whenever I try to create this table through PHPMyAdmin

CREATE TABLE `info_drop` (
`Quote` BLOB( 1000 ) NOT NULL ,
`FName` VARCHAR( 30 ) NOT NULL ,
`LName` VARCHAR( 30 ) NOT NULL ,
`City` VARCHAR( 30 ) NOT NULL ,
`State` VARCHAR( 10 ) NOT NULL ,
`Country` VARCHAR( 25 ) NOT NULL ,
`Age` INT( 3 ) NOT NULL ,
`Gender` VARCHAR( 10 ) NOT NULL ,
`Marital` VARCHAR( 20 ) NOT NULL ,
`Occupation` VARCHAR( 40 ) NOT NULL ,
`Education` VARCHAR( 20 ) NOT NULL ,
`Mail` VARCHAR( 30 ) NOT NULL
) COMMENT = 'Information drop'

I get this error message

You have an error in your SQL syntax near '( 1000 ) NOT NULL ,
`FName` VARCHAR( 30 ) NOT NULL ,
`LName` VARCHAR( 30' at line 1

What is the matter with my code that it won't go through? I can't see anything that I did incorrectly.

Options: ReplyQuote


Subject
Written By
Posted
SQL Table Error
August 17, 2005 02:28PM
August 17, 2005 03:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.