[Tutor] sqlite3 does it support limit in a delete clause?

[eryksun]

On Thu, Feb 21, 2013 at 10:41 PM, eryksun <eryksun at gmail.com> wrote:
>     >>> from ctypes import *
>     >>> import _sqlite3
>     >>> lib = CDLL(_sqlite3.__file__)
>
>     >>> lib.sqlite3_compileoption_used(
>     ...     "ENABLE_UPDATE_DELETE_LIMIT")
>     1

A simpler way using a SQL function:

http://www.sqlite.org/lang_corefunc.html#sqlite_compileoption_used

Windows, Python 2.7.3:

>>> cur.execute('''
...   select sqlite_compileoption_used(
...     'ENABLE_UPDATE_DELETE_LIMIT')''').fetchone()
(0,)

Debian, Python 2.7.3:

>>> cur.execute('''
...   select sqlite_compileoption_used(
...     'ENABLE_UPDATE_DELETE_LIMIT')''').fetchone()
(1,)