Sorry if this has already been addressed, did a quick forum search and couldn't find anything...
I am fairly new to the MySQL / PHP world, have been using Informix / 4GL / 4js / Genero for 15 years. Love MySQL and PHP. Hosting site I am using provides phpMyAdmin as the interface into MySQL. In the Informix ISQL or DBACCESS world, I am used to issuing a BEGIN WORK to start a transaction, puttering around with a bunch of insert / delete / update / screwup interactive SQL commands, realizing I bollixed something up, and doing a ROLLBACK WORK to start over.
I'm using all InnoDB tables. In myPhpAdmin, as far as I can tell, each page submission is treated as a transaction - if I issue a SET AUTOCOMMIT = 0 then execute a query, look at the results, execute another query, look at the results, realize I goofed, and try to ROLLBACK, I find that each intermediary query has actually been commited when I executed the command.
Am I missing something obvious, not using the SET AUTOCOMMIT syntax correctly, making some other kind of mistake, or is this not possible to do using phpMyAdmin?
Thanks!
Ray Garrison
