Function limit

lib/sqlalchemy/dialects/mysql/dml.py:46–59

apply a LIMIT to an UPDATE or DELETE statement e.g.:: stmt = t.update().values(q="hi").ext(limit(5)) this supersedes the previous approach of using ``mysql_limit`` for update/delete statements. .. versionadded:: 2.1

(limit: _LimitOffsetType)

def limit(limit: _LimitOffsetType) -> DMLLimitClause:
    """apply a LIMIT to an UPDATE or DELETE statement

    e.g.::

        stmt = t.update().values(q="hi").ext(limit(5))

    this supersedes the previous approach of using ``mysql_limit`` for
    update/delete statements.

    .. versionadded:: 2.1

    """
    return DMLLimitClause(limit)


class DMLLimitClause(SyntaxExtension, ClauseElement):