So, I wrote this sample code to show how to achieve an all or nothing transaction across four tables. While I thought troubleshoot some broken MySQL SQL/PSM logic would be a good learning experience for students, it wasn’t. Surprisingly, transaction management wasn’t covered well in Alan Beaulieu’s Learning SQL because he only provided pseudo code logic. However, they require a structured programming approach, like a store procedure or like API implemented in an imperative language. Transactions across two or more tables are a natural extension of ACID compliance features provided by DML commands. The idea of ACID transactions are a basic feature of SQL’s individual Data Manipulation Language (DML) commands, like the INSERT, UPDATE, and DELETE statements.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |