begin/start transaction 显示的开启一个事务; commit/commit work 提交事务; rollback/rollback work 回滚事务,会结束事务,并撤销正在进行的所有未提交的修改; savepoint identifier 创建一个保存点identifier,一个事务中可以有多个保存点; release savepoint identifier 删
1. A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause. 2. In a commit, a user explicitly or implicitly requested that the changes in the transaction be made permanent. Changes made by the transaction are permanent and visible to other users only after a transaction commi...
0 - This is a modal window. No compatible source was found for this media. Example This example explains the query plan details of the customer with ID 1. EXPLAIN SELECT * FROM CUSTOMER WHERE ID = 1; The above command produces the following output − ...
I can now see the SAVEPOINT, RELEASE and ROLLBACK commands in the Application log. But I'm not sure if they are in the correct sequence. When I update a row I see the UPDATE first and the SAVEPOINT afterwards. My original post was mainly about documentation. So I have added an extra ...
Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 27 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 25 | +---+---+ 1 [21 Jan 2010 23:09] Omer Barnir This...
Handler_delete | 0 | | Handler_discover | 0 | | Handler_prepare | 0 | | Handler_read_first | 0 | | Handler_read_key | 4 | | Handler_read_next | 10130 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 0 | | Handler_rollback | 0 | | ...