How to do transactions?

[wgcs]

How does one deal with transactions in MySql through ODBC?

Can you send several statements in one ODBC SQLEXEC() and have them protected by a transaction (so all of them or none of them are committed)?

Can you have a transaction span several ODBC SQLEXEC() calls?

 

[vulcand4]

It's my understanding that transactions are not available with MySQL when using the standard MyISAM tables.

InnoDB tables will allow you to do transactions by allowing the Commit and Rollback commands. Basically, the queries are done in a buffer and when a commit is executed, the buffer updates are commited to the database. A Rollback will undo those updates.

Any Query done before a commit will be part of the transaction. Therefore, a commit has to be done even after a single query (that wouldn't normally be thought of as part of a transaction).