looks to me like the error is with the semicolon at the end of the Service CHAR (80);
That would indicate the end of the statement, not that something follows Rance Hall 308.238.2455 Internal Office Extensions: 2455 or 6655 PC Programmer, The Buckle, Inc. [EMAIL PROTECTED] -----Original Message----- From: Jim Swanson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:07 AM 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
