Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Are the transaction commands, BEGIN, COMMIT, and ROLLBACK supported?

April 26, 2017commands Rollback supported transaction

0

Posted

Are the transaction commands, BEGIN, COMMIT, and ROLLBACK supported?

1 Answer

0

Posted

No, and they will probably never be supported (once again that’s beyond the scope of mSQL). The mSQL server handles requests serially – that is only one user’s request is handled at a time. Therefore there is no danger of a user reading from a table that is currently being updated by another user. However, there is the possibility that the same read operations may straddle another user’s write operation so that different data will be returned from each read. mSQL version 2 will provide client initiated locking.