clustered index?

[amykhar]

I am very new to databases because I come from the embedded software engineering field. However, I was given an sql file to restore to a mysql database with the line:

Create Clustered Index TranHeader_CL on TranHeader (NCESID, TranType, TranStatus);


in it. It is blowing up. Can somebody tell me the correct way that this should be done in mysql?

It's somewhat of an emergency. Thank you.

Amy

[MattR]

That appears to be MS SQL, Sybase, or DB2 syntax. MySQL does not support clustered indexes. Remove the 'CLUSTERED' and it should work. Also, if it is in a pinch you should ALWAYS read the manuals on-line since it will usually result in an answer much faster.

www.mysql.com