Tag: delete

  • 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 smart and get that we only want to delete from where there actually exists content.