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]