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

[eryksun]

On Thu, Feb 21, 2013 at 8:47 PM, Jim Byrnes <jf_byrnes at comcast.net> wrote:
>
>>>> cur.execute("delete from pwds where Account='xMe' limit 1")

If you need a alternate way to limit the delete, try the following,
for which the limit is on a select query:

    cur.execute('''
      delete from pwds where rowid in (
        select rowid from pwds where Account='xMe' limit 1)
    ''')