I thought we have a github for DELETE..LIMIT but we dont. This would be a
construct specific to the MySQL dialect: from sqlalchemy.dialects.mysql import
delete , where it would include order_by() and limit() params.We don't have
internal resources to carry this through so we'd rely upon
Hi. Can you do a sub query with the ones you want to delete selected (with limit) and then delete with an IN clause on the sub query items?Warwick A. PrinceMushroom Systems International Pty. Ltd.On 22 Sep 2023, at 9:16 pm, 'Grennith' via sqlalchemy wrote:Hi everyone,I'd like to issue a LIMIT
Hi everyone,
I'd like to issue a LIMIT for a DELETE statement.
By default, this is not possible as far as I can see it. The function
limit() is available for SELECT in general however.
Searching through documentation, I found a reference to
with_dialect_option():