How could DBI or MySQL even know whether the affected tables are transaction based? What if you mixed them up in your transaction?

 $dbh->do( "INSERT INTO nontrans VALUES ( 'hi' )" );
 $dbh->do( "UPDATE trans SET name = 'hey' WHERE id = 4" );
 $dbh->commit;
[download]

How could either MySQL or DBI deal with this? It's probably a good idea to create two separate connections: one for transactions, one for non-transactions. And is it a good idea to even mix transaction and non-transactional tables in a database? This seems ripe for mistakes to me... but I haven't used transactions in MySQL before, so maybe this is recommended behavior?

Chris
M-x auto-bs-mode