Your last row attempts to declare a column named NB of type TEXT with size
of 5. TEXT columns don't take a size specifier. Either drop the size of 5
or change NB to type CHAR or VARCHAR.
Michael
David Blomstrom wrote:
I'm trying to create a new table in my database. I
patterned it after another table, so I didn't expect
any errors. Yet I get this error:
#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 '(5) DEFAULT
NULL) TYPE = InnoDB' at line 1
I don't have a clue what it's talking about. Error
#1064 is an "ER_PARSE_ERROR," which isn't much help.
I must have made a really basic, and presumably
obvious, mistake, but I can't identify it. Can you
spot it on the screenshot I put online at
http://www.geoworld.org/basics.gif ?
Thanks.
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
