I have a innodb with a join on two tables. The foreign key is the id column which is set to AI. I have been having an issue of the tables being out of sync in that the id is not the same on the two tables. I have corrected this a couple of times in phpmyadmin by resetting the auto_increment to the same number in both tables, but it is re-occurring.
I have tried to duplicate how this occurs, and I believe it is occurring on a page refresh, but I am not positive. I don't know what information / code to post that someone would be able to make a suggestion to a solution, so if someone could direct me to what to post I would be appreciative. -- Gary __________ Information from ESET Smart Security, version of virus signature database 6044 (20110415) __________ The message was checked by ESET Smart Security. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org