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 > 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. > > Thank for any sort of help in advance. > > Regards > Chetan > > > > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users