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
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