Hi there. I'm using MySQL-Max version 3.23.46 for Linux-i386 and I just found a problem.
It seems that every once in a while MySQL changes the references of a foreign key when it's using temporary table. A show table status would give us the following: InnoDB free: 21504 kB; (usr_id) REFER conline/#sql2-1a4-80a(usr_id); (emp_id) REFER conline/emp(emp_id) And the table it should be referencing was the table usr. This names looks particularly as a temporary table it changed for a while and didn't change it back to normal after the transaction was ready. -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
