How to use with SELECT * FOR UPDATE SKIP LOCKED?

go-ozzo / ozzo-dbx

A Go (golang) package that enhances the standard database/sql package by providing powerful data retrieval methods as well as DB-agnostic query building capabilities.

MIT License

638 stars 91 forks source link

How to use with SELECT * FOR UPDATE SKIP LOCKED? #92

Open kolkov opened 4 years ago

kolkov commented 4 years ago

Hi! How to use builder with this query? SELECT * FROMdislocationWHEREstatus='init' ORDER BYoperation_timeASC LIMIT 1 FOR UPDATE SKIP LOCKED https://mysqlserverteam.com/mysql-8-0-1-using-skip-locked-and-nowait-to-handle-hot-rows/