[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