http://www.innodb.com/ibman.html#InnoDB_transaction_model
Scroll down a bit to Section 8.5 Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Miguel Perez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, 09 June, 2003 18:44 Subject: INNODB Transactions Hi : I would like to know what happen if I start a transaction using BEGIN command I do some insert or update statements, and just before executing a ROLLBACK or COMMIT command I get disconnected and I can't execute those commands. For how long does the table remain locked, or in other words how unlock that table with another client connection?. Best regards _________________________________________________________________ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx -- 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]