Also, the CREATE TABLE statement doesn't look right. It should probably be:
create table 185_s_Prices ( PriceID INT NOT NULL DEFAULT 0, Service CHAR (80), Category CHAR (20) ); See the MySQL Manual section on "CREATE TABLE". On Mon, 8 Apr 2002, Jim Swanson wrote: > 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
