What is the syntax for the "where id in (select ... ) " ? On Jun 13, 5:17 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: > That's a MySQL specific syntax you might be better off not using, perhaps you > could say "delete from table where id in (select id from table order by > timestamp limit 10)". > > To get the exact statement, it's probably easiest just to emit the string > SQL. If you wanted the sqlalchemy.sql.delete() construct to do it you'd need > to subclass Delete, add order_by() and limit() to it, and augment its > compilation as described inhttp://www.sqlalchemy.org/docs/core/compiler.html > > On Jun 13, 2011, at 10:10 AM, Moshe C. wrote: > > > > > > > > > Hi, > > I am using Sqlalchemy 0.6.5 . > > > How do I generate the following statement usin Sqlalchemy expressions > > (not ORM). > > > DELETE FROM table ORDER BY timestamp LIMIT 10; > > > TIA > > > -- > > You received this message because you are subscribed to the Google Groups > > "sqlalchemy" group. > > To post to this group, send email to sqlalchemy@googlegroups.com. > > To unsubscribe from this group, send email to > > sqlalchemy+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/sqlalchemy?hl=en.
-- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.