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
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