Categories
Dev

Mysql Delete with null left join

If you do: Select * from table left join other_table on id=ext_id where ext_id is null it works great. But if you want to convert that select to a delete you need to include ‘table.*‘: Delete table.* left join other_table on id=ext_id where ext_id is null It kind of makes sense, but MySql could be […]