> Is it indexed? > > And don't forget you can use the command > SHOW INNODB STATUS\G > > to show the last FK related error.
ahh yes - i did not know about this command ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 040422 14:39:09 Error in foreign key constraint creation for table TNMailServer/TNSession. A foreign key constraint of name TNMailServer/0_20 already exists (note that internally InnoDB adds 'databasename/' in front of the user-defined constraint name). thankyou for your quick response as this has fixed my error Tom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
