I also tried to do this via subquery, but MySQL apparently doesn't support subqueries with LIMIT:
NotSupportedError: (NotSupportedError) (1235, "This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'") 'DELETE FROM twitter_tweets WHERE twitter_tweets.uid IN (SELECT twitter_tweets.uid \nFROM twitter_tweets \nWHERE twitter_tweets.created_at < date_sub(UTC_TIMESTAMP, INTERVAL 90 DAY) ORDER BY twitter_tweets.created_at ASC \n LIMIT %s)' (2,) -- You received this message because you are subscribed to the Google Groups "sqlalchemy-alembic" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
