I have written some scripts to create the table structures for my 'MYSQL' database. I have created some scripts which were ok and correct when run on my server, but i get this one problem one table script
the code:
CREATE TABLE Order
(
OrderID VARCHAR(50) NOT NULL PRIMARY KEY,
CustomerID INT,
CustomerOrderNum VARCHAR(50),
RequestDeliv DATETIME,
EndUserName VARCHAR(50),
BuildNum VARCHAR(50),
ChassisNum VARCHAR(50),
ModelConv VARCHAR(50),
ModelChassis VARCHAR(50),
OptionalExtras VARCHAR(50)
);
the error i get is as follows
Error 1064: at line 2: you have an error in your SQLsyntax near 'Order
(
OrderID VARCHAR(50) NOT NULL PRIMARY KEY,
CustomerID INT,
Custo' at line 1
Can anybody help me with this one??
Thanx in advance
