|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
April 17th, 2009, 03:34 AM
|
|||
|
|||
|
SQL query error
Hi
I am getting the follwing query error when making a table in phpmyadmin. MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''BuyerID') Name VARCHAR(100) NOT NULL, Address1 VARCHAR(100) NOT NULL, Addres' at line 2 Here is my sql tables Code:
CREATE TABLE IF NOT EXISTS Buyers(
PRIMARY KEY ('BuyerID')
Name VARCHAR(100) NOT NULL,
Address1 VARCHAR(100) NOT NULL,
Address2 VARCHAR(100) NOT NULL,
City VARCHAR(100) NOT NULL,
State CHAR(2) NOT NULL,
Zip VARCHAR(20) NOT NULL,
Email VARCHAR(100) NOT NULL,
DayPhone VARCHAR(100) NOT NULL,
EvePhone VARCHAR(100) NOT NULL,
Contact INT(1) NOT NULL,
PayMethod VARCHAR(100) NOT NULL,
CCType VARCHAR(100) NOT NULL,
CCNum VARCHAR(100) NOT NULL,
CCExpire VARCHAR(100) NOT NULL,
OrderTotal DECIMAL(8,2) NOT NULL,
Date VARCHAR(100) NOT NULL,
OrderNumber BIGINT NOT NULL,
UserID VARCHAR(100) NOT NULL,
BuyerID BIGINT NOT NULL AUTO_INCREMENT,
);
CREATE TABLE IF NOT EXISTS 'CartItems' (
UserID VARCHAR(100) NOT NULL,
ItemID VARCHAR(25) NOT NULL,
ItemQuantity INT(4) NOT NULL,
Date VARCHAR(100) NOT NULL,
CartItemsID BIGINT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (CartItemsID)
);
CREATE TABLE IF NOT EXISTS 'Category' (
Category VARCHAR(100) NOT NULL,
CategoryID BIGINT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (CategoryID)
);
CREATE TABLE IF NOT EXISTS 'Items' (
ItemSKU VARCHAR(25) NOT NULL,
ItemName VARCHAR(100) NOT NULL,
ItemDescription MEDIUMTEXT NOT NULL,
ItemCost DECIMAL(7,2) NOT NULL,
Category BIGINT NOT NULL,
ShippingCost DECIMAL(6,2) NOT NULL,
ItemID BIGINT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (ItemID)
);
CREATE TABLE IF NOT EXISTS 'Orders' (
BuyerID BIGINT NOT NULL,
UserID VARCHAR(100) NOT NULL,
Date VARCHAR(100) NOT NULL,
OrderTotal DECIMAL(8,2) NOT NULL,
OrderNumber BIGINT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (OrderNumber)
);
CREATE TABLE IF NOT EXISTS 'Receipts' (
BuyerID BIGINT NOT NULL,
UserID VARCHAR(100) NOT NULL,
OrderNumber BIGINT NOT NULL,
Date VARCHAR(100) NOT NULL,
ItemID BIGINT NOT NULL,
ItemSKU VARCHAR(25) NOT NULL,
ItemName VARCHAR(100) NOT NULL,
ItemCost DECIMAL(7,2) NOT NULL,
ShippingCost DECIMAL(6,2) NOT NULL,
ItemQuantity INT NOT NULL,
TotalCost DECIMAL(8,2) NOT NULL
);
CREATE TABLE IF NOT EXISTS 'Users' (
User VARCHAR(100) NOT NULL,
Date INT(4) NOT NULL
);
|
|
#2
June 17th, 2009, 06:43 AM
|
|||
|
|||
|
Don't use quotes for BuyerID.i.e
Just make it as PRIMARY KEY (BuyerID) instead of PRIMARY KEY ('BuyerID'),Add comma after PRIMARY KEY (BuyerID) in second line and remove comma after last line.It will work.It doesn't throw any error messages. CREATE TABLE IF NOT EXISTS Buyers( PRIMARY KEY (BuyerID), Name VARCHAR(100) NOT NULL, Address1 VARCHAR(100) NOT NULL, Address2 VARCHAR(100) NOT NULL, City VARCHAR(100) NOT NULL, State CHAR(2) NOT NULL, Zip VARCHAR(20) NOT NULL, Email VARCHAR(100) NOT NULL, DayPhone VARCHAR(100) NOT NULL, EvePhone VARCHAR(100) NOT NULL, Contact INT(1) NOT NULL, PayMethod VARCHAR(100) NOT NULL, CCType VARCHAR(100) NOT NULL, CCNum VARCHAR(100) NOT NULL, CCExpire VARCHAR(100) NOT NULL, OrderTotal DECIMAL(8,2) NOT NULL, Date VARCHAR(100) NOT NULL, OrderNumber BIGINT NOT NULL, UserID VARCHAR(100) NOT NULL, BuyerID BIGINT NOT NULL AUTO_INCREMENT );
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > SQL query error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
