Did you commit the transaction?

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]



Reply via email to