MySQL Forums :: Newbie :: question about create a table


Advanced Search

question about create a table
Posted by: C C ()
Date: May 08, 2009 02:59PM

Hi,
I want to create a table using the following statement:

CREATE TABLE NonUniqRecords SELECT c.id, c.levels
FROM catalog_all c, UniqRecords u
WHERE c.id != u.id
ORDER BY c.levels DESC;

PS:Table catalog_all and UniqRecords are already in database.

However, it shows the following error message after running for 8 mins

ERROR 126 (HY000): Incorrect key file for table '#sql_d78_0.MYI'; try to repair it

Anyone can tell me why?
Thanks

Options: ReplyQuote


Subject Written By Posted
question about create a table C C 05/08/2009 02:59PM
Re: question about create a table Michael Piekarski 05/09/2009 11:29AM
Re: question about create a table Rick James 05/09/2009 01:17PM
Re: question about create a table Michael Piekarski 05/10/2009 02:14AM
Re: question about create a table Rick James 05/10/2009 03:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.