How about removing the comma before the close parenthesis at the end of the statement - or adding a Primary Key clause after the comma but before the close parenthesis?
Rhino ----- Original Message ----- From: "B Wiley Snyder" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Friday, January 07, 2005 3:28 PM Subject: weird syntax error > When I use 4.0 on windows I don't get this error but now that i'm using > 4.1.x I'm getting error 1064 , is BLOB depricated or something ??? Please > help ! > > thanks in advance > =============================================== > > Your MySQL connection id is 97 to server version: 4.1.8-standard > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> CREATE TABLE demoCart ( > -> ProductID int primary key, > -> CategoryID int, > -> ModelNumber varChar(75), > -> ModelName varChar(250), > -> ProductImageThumb varchar(250), > -> ProductImage varchar(250), > -> UnitCost decimal(9,2), > -> Description BLOB, > -> ); > ERROR 1064 (42000): 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 ')' at line 10 > mysql> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
