Re: [Sqlalchemy-users] Multiple delete and specific column select

you could use the table directly: t = class_mapper(MyClass).mapped_table t.delete().execute() select([t.c.col1, t.c.col2]).execute() On Jun 13, 2006, at 3:23 AM, Chetan Thapliyal wrote: > Hi > > I have two queries. > > 1. How can I delete multiple rows (may be all) of a table using > sess

[Sqlalchemy-users] Multiple delete and specific column select

Hi I have two queries. 1. How can I delete multiple rows (may be all) of a table using session query object based on a specific python class that is binded to a table using mapper? 2. Is there any way of selecting only specific columns of a table using the same session query object as above.