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
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 Mes
ERROR 1064 at line 1: You have an error in your SQL syntax near ' ' at
line 1
- perhaps you'd prefer the semicolon to complete your query -
C:~
-Original Message-
From: Jim Swanson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:07 AM
To: [EMAIL PROTECTED]
Subject: SQL S
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 PROTE
