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
The semi-colon (;) after "Service CHAR(80)" should be a comma (,).
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 DEFAUL
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_Pri
D]
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),<--- h
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
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 th
