mysql 8.x transaction with skip locked

Posts   
 
    
goose avatar
goose
User
Posts: 392
Joined: 06-Aug-2007
# Posted on: 07-Mar-2020 09:22:43   

Hello, is the following supported in 5.6.2 ?

START TRANSACTION;
SELECT * FROM tableName FOR UPDATE SKIP LOCKED;

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 08-Mar-2020 09:46:26   
Frans Bouma | Lead developer LLBLGen Pro
goose avatar
goose
User
Posts: 392
Joined: 06-Aug-2007
# Posted on: 09-Mar-2020 04:17:08   

Thanks, I will experiment with it and let you guys know how it went.