[Tutor] sqlite3 does it support limit in a delete clause?
Jim Byrnes
jf_byrnes at comcast.net
Fri Feb 22 02:47:21 CET 2013
ubuntu 12.04 python 2.7
Does sqlite3 in this version of python support a delete with a limit?
>>> cur.execute("delete from pwds where Account='xMe' limit 1")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
sqlite3.OperationalError: near "limit": syntax error
>>>
>>> cur.execute("delete from pwds where Account='xMe' limit=1")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
sqlite3.OperationalError: near "limit": syntax error
>>>
It seems not, but it may be me messing up the syntax so I thought I
would check.
Thanks, Jim
More information about the Tutor
mailing list