Delete data from two tables with one query?

Question

i want to delete data's from two tables:

something like this:

$rez = mysql_query("delete from slike where slike_id='$del' or delete from foto where foto_id='$del'");

How i can to do that? Thanks.

http://stackoverflow.com/questions/1233451/delete-from-two-tables-in-one-query — antoox, May 15 '13 at 10:22
But situtation is small specify, i have one list where i select data's from tables and show them both into list, i now want when i press delete to delete some selected value from list... — user1814358, May 15 '13 at 10:26
this doesn't work $del = $_POST['list']; $rez = mysql_query("delete from slike where slike_id='$del'; delete from foto where foto_id=$del"); — user1814358, May 15 '13 at 10:27
i need something like "or", if some of two queries is possible then run it ... — user1814358, May 15 '13 at 10:28

score 0 · Answer 1 · answered May 15 '13 at 10:29

0

you should first search what you are asking ..

DELETE  FROM slike  INNER JOIN foto on  slike.slike_id= foto.foto_id where slike.slike_id='$del'

answered May 15 '13 at 10:29

Rajeev Ranjan

score 0 · Answer 2 · edited May 23 '17 at 11:51

0

I think this isn't posible unless you use MySQL triggers or have relation between columns.

edited May 23 '17 at 11:51

Community

answered May 15 '13 at 10:30

martin

it has a relation slike_id = foto_id according to sql_query. – Rajeev Ranjan May 15 '13 at 10:31
SOLVED, i delete foto table, and just add tho new columns in slike table, and set all columns to allow null. – user1814358 May 15 '13 at 10:53

score 0 · Answer 3 · answered May 15 '13 at 10:55

0

$rez = mysql_query("DELETE FROM slike WHERE slike_id='$del' AND TRUE=DELETE FROM foto WHERE foto_id='$del'");

answered May 15 '13 at 10:55

Amir

3 Answers3