Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Using SQLyog › Error No.1005
Hi.
I have get the error No.1005 when try to reorder columns of a table. “Can't create table 'C:tmp…..(errno:140)”
How can I fix it?
Thanks in Advance.
Julian
PD: I'm using sQLyog ver 4.01 free
Have you tried v4.02?
You can download the FREE version of v4.02 from http://www.webyog.com/sqlyog/SQLyog402.exe.
Let me know your results.
If the problem still persists then can you tell me your MySQL version and the structure of the table that you are reordering?