MySQL - Multiple Queries - Any way to chain queries together / execute all in one statement?

[eluser]SPeed_FANat1c[/eluser]
I thinks this is what you want:

http://ellislab.com/codeigniter/user-gui...tions.html


Your tables have to use InnoDB engine.

check if InnoDB is possible.

Code:

mysql> show engines;

if so, then check what engine is used for your table

Code:

mysql> show table status like 'table name';

if its not InnoDB then change it

Code:

mysql> alter table table_name engine = InnoDB;

Edit:
then you don't execute in on php query ut it act like one query - if on of queries fail, then all are backed to original state, like nothing has happened.