Entry

how does one rollback in MYSQL? i've tried connection.rollback() but it does not work help plz!

Mar 15th, 2004 11:26
Matt Chatterley, vin ven,

Difficult to answer, since it's unclear how you are accessing the database!
Issuing the SQL 'ROLLBACK' statement will cause MySQL to roll-back a
currently open transaction (e.g from PHP, mysql_query("ROLLBACK",
$database_connection)).
If a connection is terminated leaving a transaction open, that
transaction will be rolled back automatically.