You have a semicolon(;) after the line Service CHAR (80) Besides after CREATE TABLE tablename syntax you have to define the columns and their datatypes in parenthesis.
See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html Gurhan -----Original Message----- From: Jim Swanson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: SQL Script stopping I have a script I'm trying to run through the mysql command. When I run the script, I get a 1064 error, specifically CREATE TABLE 185_s_Prices\g PriceID INT NOT NULL DEFAULT 0, Service CHAR (80); Category CHAR (20), <--- here Can anyone tell me what's wrong with this line? I dumped the tables, changed Category to ctg, still the same error. I'm running a fresh install of Mandrake 8.2. Thanks in advance. Jim Swanson --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
