Greetings I have MySQL 4.0.14 running on WinXP.
Whenever I create a temporary table from an existing table that has multiple keys ( the temporary table has columns reordered from the original table ) with a query like - create temporary table if not exists `mn`.`sqlyog_23796` ( `entryid` int(6) unsigned NOT NULL auto_increment , `caseid` int(6) unsigned NOT NULL DEFAULT '0' , `litigantid` int(6) unsigned NULL , `litiganttype` char(1) NULL , `counselid` int(6) unsigned NULL , primary key ( entryid ) ,KEY `caseid` ( `caseid` ), FULLTEXT KEY `counselid` ( `counselid` ), FULLTEXT KEY `litigantid` ( `litigantid` )); I get a error - Error No. 1005 Can't creat table 'C:\WINDOWS\TEMP\#sql794_37_2.frm' (errno: 140) Why the above query is not working? Is there anything wrong with the SQL? Karam __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]