Re:In Praise of PostgreSQL
by evanelias on Friday August 06, 2021 @10:57AM
(#28088022)
MySQL 8 supports FOR UPDATE SKIP LOCKED [1], but does not have a RETURNING clause.
MariaDB 10.5+ supports a RETURNING clause, and 10.6 now has FOR UPDATE SKIP LOCKED. This is quite new though (10.6 went GA a month ago) so there might be some wrinkles.
MariaDB 10.5+ supports a RETURNING clause, and 10.6 now has FOR UPDATE SKIP LOCKED. This is quite new though (10.6 went GA a month ago) so there might be some wrinkles.
[1] https://mysqlserverteam.com/mysql-8-0-1-using-skip-locked-an...