SQLize | PHPize | SQLtest

create table accounts( `id` bigint(20) UNSIGNED NOT NULL auto_increment, data varchar(36), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ); insert into accounts(data, created_at, updated_at) values('Test 1', now(), now()); insert into accounts(data, created_at, updated_at) values('Test 2', now(), now()); insert into accounts(data, created_at, updated_at) values('Test 3', now(), now()); create table account_locks( account_id bigint(20) UNSIGNED NOT NULL, pid varchar(36), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ); insert into account_locks(account_id, pid) select id, UUID() from accounts left join account_locks on account_id = accounts.id group by id having count(account_locks.account_id) < 3 limit 1; insert into account_locks(account_id, pid) select id, UUID() from accounts left join account_locks on account_id = accounts.id group by id having count(account_locks.account_id) < 3 limit 1; insert into account_locks(account_id, pid) select id, UUID() from accounts left join account_locks on account_id = accounts.id group by id having count(account_locks.account_id) < 3 limit 1; insert into account_locks(account_id, pid) select id, UUID() from accounts left join account_locks on account_id = accounts.id group by id having count(account_locks.account_id) < 3 limit 1; insert into account_locks(account_id, pid) select id, UUID() from accounts left join account_locks on account_id = accounts.id group by id having count(account_locks.account_id) < 3 limit 1; select * from account_locks;