Name

SQLITE_ENABLE_UPDATE_DELETE_LIMIT — Enable extended SQL syntax

Description

Enables an extended syntax for the UPDATE and DELETE commands that allows the inclusion of ORDER BY and LIMIT clauses. Because support for directives requires altering the SQL parser, this directive can only be used when building from a full development tree. It will not work if building from an amalgamation or a source distribution.

Get Using SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.