Re: [sqlalchemy] Update join in core

2016-11-06 Thread mike bayer
an update join using SQLAlchemy core? In MySQL, it'd be something like this: update a left outer join b on a.x = b.x set a.y = 1 where b.x is null In other words, I want to modify a but only for the rows that do not exist in b according to my join criterion. The naive attempt that calls update

[sqlalchemy] Update join in core

2016-11-05 Thread T Johnson
How do I do an update join using SQLAlchemy core? In MySQL, it'd be something like this: update a left outer join b on a.x = b.x set a.y = 1 where b.x is null In other words, I want to modify a but only for the rows that do not exist in b according to my join criterion. The naive attempt