mysqli.transaction
/ MySQL Multi Queries / mysqli.transaction
1 2 3 4 5 6 7 8 9 |
[mysqli.transaction.commit o.set=template.junk] set @last_txn_id='[template.srow.row.last_txn_id/]'; insert into deleted_loan_entries (select *,"[env.app.user.login /]" as deleted_user,CURRENT_TIME() as deleted_stamp,"delete_last_txn" as deleted_activity,NULL from loan_entries where sublan_id='[module.sublan_obj.id]' and txn_set_id=@last_txn_id and txn_set_id=[esc.id template.last_txn_id /]); delete from loan_entries where sublan_id='[module.sublan_obj.id]' and txn_set_id=@last_txn_id and txn_set_id=[esc.id template.last_txn_id /]; update transactions set status='success' where transaction_id='[template.transaction_id /]' and step_id='delete_txn'; [/mysqli.transaction.commit] |