Enterprise Shortcode Category: MySQL Multi Queries
mysqli.transaction
[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
mysqli.cud
Single query
[mysqli.cud o.set=template.data] Delete * from a [/mysqli.cud]
Multiple Queries
[mysqli.multi.cud o.set
mysqli.fetch
[mysqli.fetch.row o.set=template.data]
select * from < table name > limit 1
[/mysqli.fetch.row]
[template.data
mysqli.multi
[mysqli.multi.fetch.rows o.set=template.data]
select * from < table name > limit 10
[/mysqli.multi.fetch.rows