ozzo-dbx
ozzo-dbx copied to clipboard
How to use with SELECT * FOR UPDATE SKIP LOCKED?
Hi! How to use builder with this query?
SELECT * FROM
dislocationWHERE
status='init' ORDER BY
operation_time ASC LIMIT 1 FOR UPDATE SKIP LOCKED
https://mysqlserverteam.com/mysql-8-0-1-using-skip-locked-and-nowait-to-handle-hot-rows/