MySQL脚本出错时回滚

I am trying to create a transaction in MySql which will roll back when an exception occurs during the transaction. Similar using the following in a stored procedure.I am trying to create a transaction in MySql wh