sqlmysqlmulti-table-delete

delete from table1,table2,table3 where?


If all tables I want to delete from have the column gamer_id

can i do a delete from table1, table2, table3 where gamer_id = 123?

or is there a different syntax?


Solution

  • MySQL supports multi-table deletes:

    DELETE t1, t2, t3
      FROM TABLE_1 t1
      JOIN TABLE_2 t2 ON t2.gamer_id = t1.gamer_id
      JOIN TABLE_3 t3 ON t3.gamer_id = t1.gamer_id
     WHERE t1.gamer_id = 123