The thing is to use Start Transaction with SELECT ... FOR UPDATE COMMAND. CREATE PROCEDURE P_TEST() line 1 START TRANSACTION; line 2 SELECT * from test_table FOR UPDATE; line 3 DELETE FROM test_table ; line 4 COMMIT; line 5 thanx Jay anyway, i found it while reading about...
START TRANSACTION; line 2 SELECT * from test_table FOR UPDATE; line 3 DELETE FROM test_table ; line 4 COMMIT; line 5 thanx Jay anyway, i found it while reading about REPEATABLE READ :-). Subject Views Written By Posted ERROR 1314 (0A000): LOCK is not allowed in stored procedures ...
今天,西数硬盘“黄盘”家族又迎来了一个新的成员“Re+”,不过它并不是Re系列的升级版,而是节能版,持续读写功耗从9.4/9.2W降低到了5.8/6.2W,随机读写功耗从10.6W降低到5.5W,待机功耗从7.5W降低到4.6W,同时空闲、寻道噪音也从31、34分贝降到了27、29分贝,号称是能效最高的3.5寸数据中心硬盘。 但代价就是转...