generating "...not in (1,2,3)" from Python list ?
Steve Zatz
slzatz at hotmail.com
Mon Feb 23 13:20:27 EST 2004
More information about the Python-list mailing list
Mon Feb 23 13:20:27 EST 2004
- Previous message (by thread): MySQLDB - generating "...not in (1,2,3)" from Python list ?
- Next message (by thread): MySQLDB - generating "...not in (1,2,3)" from Python list ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Don't you just want:
cursor.execute("select * from T where C1 not in (%s,%s,%s)",params)
The DBAPI should be fine with params being a python list of integers
(as long as there are three of them).
- Previous message (by thread): MySQLDB - generating "...not in (1,2,3)" from Python list ?
- Next message (by thread): MySQLDB - generating "...not in (1,2,3)" from Python list ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Python-list mailing list