gerald_clark wrote:
Did you commit the transaction?
Yes, the transaction was committed. I was using MyCC at the same time
the anomaly occurred, also. Could this have had anything to do with it?
Kevin Carlson wrote:
I am using MySQL version 4.0.11 gamma on Linux 7.1 and have just
experienced the following problem:
INSERTed a record into a InnoDB table, then used SELECT to retrieve
the recordID (auto numbered field) from the same table using a key.
The SELECT returned the proper ID. However, when browsing the
original table no record with this ID exists.
Is it possible that due to some internal error that a successfully
INSERTED and subsequently SELECTED error would be deleted from the
database? Has anyone seen this type of behavior before?
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]