V
V
vahan212020-03-01 19:41:52
PHP
vahan21, 2020-03-01 19:41:52

How can I specify the deletion of records from several tables. php mysql?

Hello!
Please tell me how can I do this
Thanks in advance!

I have two tables " application_form_by_id " , " lottery_start " .
5e5be282c1455252861960.png
and
5e5be2a201a05427297879.png

now I want to delete only those who have Id = 12 in lottery_start and prizeId = 12

I want to do all this this way, but I don’t know how to use it because I don’t know where to write

DELETE t1, t2 FROM t1 INNER JOIN t2 INNER JOIN t3
WHERE t1. id=t2.id AND t2.id=t3.id;
I found this cat from this
website

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question