Skip to main content

All Questions

Filter by
Sorted by
Tagged with
1 vote
2 answers
3k views

Can I emulate Oracle's autonomous transaction in MySQL?

I have a number of tables that have triggers on them that insert records in queueing and logging tables. The problem is that those inserts are then part of the same transaction. That means that any ...
SQB's user avatar
  • 478
9 votes
3 answers
8k views

Using MySQL triggers or transactions?

I want to ask your opinion in using MySQL triggers or transactions in a website. Actually I have a history payment table with - UserId | OperationId | Comment | Credits | Sign (debit or credit). So ...
EKK's user avatar
  • 295