Assuming that the record "named B" is insterted using connection "2", and the transaction is started and rolled back using connection "1", that record should not be rolled back.
You can experiment with things like that easily from multiple terminal windows or a graphical client. -----Original Message----- From: Andre Matos [mailto:[EMAIL PROTECTED] Sent: Monday, February 07, 2005 6:45 PM To: mysql@lists.mysql.com Subject: InnoDB and Transactions Hi List, Let's suppose that I have this sequence of events: - create a connection "1" -- start a transaction --- create a new connection "2" ---- insert a new record "named B" --- close the connection "2" --- insert a new record "named A" -- rollback - close the connection "1" This sequence will be written in PHP4. My question is: Will the record "named B" be written in the database or it will be rollback with the record "named A"? Thanks for any help!!! Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]