Re: CREATE TABLE Failure

2006-06-27 Thread Martijn Tonies
In addition to Ben's answer... > Hi All, > > I have been repeatedly trying to create the following table - without > __ANY__ success. Looks like there is REALLY something wrong with the > MySQL engine or something! Here is the script: Posting the error itself would help. Martijn Tonies Databas

Re: CREATE TABLE Failure

2006-06-27 Thread Dan Buettner
Asif, I note 3 problems: 1 - your table is named 'order', which is a reserved word in MySQL and most other db engines. I'd suggest using a different name. If you must use 'order' for the name, enclose it in backticks, a la `order`, in the create statement. 2 - you have IDNEX instead of IND