How to delete a row from 2 tables in one query?

Question

MySQL

I need to delete rows with Id = 80 in 2 tables, tell me what I'm doing wrong?

DELETE FROM table_1 A LEFT JOIN table_2 B ON (A.Id= B.Id) WHERE Id= '80' AND A.Type= '0'

Answer 1

DELETE 
    A,
    B
FROM 
    table_1 A
    LEFT JOIN table_2 B ON (A.Id= B.Id)
WHERE 
    A.Id=80

Answer 2

DELETE FROM table_1 WHERE ...; DELETE FROM table_2 WHERE ...;

Answer 3

Hang up foreign key with property ON DELETE... CASCADE on the necessary column. Then the DBMS will automatically remove related data from other tables.

Answer 4

BEGIN;
  DELETE FROM table_1 WHERE ID = 80; 
  DELETE FROM table_2 WHERE ID = 80;
COMMIT;

Answer 5

what am I doing wrong?

Believe that a record with the specified ID exists.
If there is no such record in table_1 , there will be no deletions, even if there are such records in the second table.
In general, a FULL JOIN is required to solve a problem with a single query. But alas, MySQL does not support it. Therefore, in the general case, the problem is unsolvable.