Can I use transaction like capability in MySQL trigger
I have an insert trigger which takes a set of column values from rows in table A and inserts some of them in table B and remaining in table C. I need this operation to be a transaction wherein if there is some error whilst data is inserted in table B and not C, the entire insertion operation should be rolled back.

I studied the manual and it says at the last of this page :http://dev.mysql.com/doc/refman/5.0/en/trigger-syntax.html that transaction is not allowed in triggers

Is there a way to achieve what I want in mysql. 
Can I use transaction like capability in MySQL trigger
===

I have an insert trigger which takes a set of column values from rows in table A and inserts some of them in table B and remaining in table C. I need this operation to be a transaction wherein if there is some error whilst data is inserted in table B and not C, the entire insertion operation should be rolled back.

I studied the manual and it says at the last of this page :http://dev.mysql.com/doc/refman/5.0/en/trigger-syntax.html that transaction is not allowed in triggers

Is there a way to achieve what I want in mysql. 