Hello,
This is currently not supported, but a feature request is on the road map:
https://github.com/jOOQ/jOOQ/issues/714
As an intermediate workaround, you can probably find a solution along these
lines:
DELETE FROM *tbl_name*
WHERE *tbl_name.id *IN (
SELECT *id *
FROM *tbl_name*
ORDER BY ...
LIMIT *row_count*
)
Cheers
Lukas
2013/6/5 Yuri Zayats <[email protected]>
> How can I use LIMIT on DELETE operations?
>
> DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM *tbl_name*
> [WHERE *where_condition*]
> [ORDER BY ...]
> [LIMIT *row_count*]
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
