delete from three tables

Question

Please Anyone there
if any conditions or query

i need to delete the details are matching accroding to Table adl_auth_user A

id      user_id     type_id     type_value  
66428     1919          1           97

table user_details B

user_id     first_name      last_nam    
1919        Rins TE       Kola

table adl_user C

id         email                   password 
1919    email@DOMAIN.COM         SOME PASSWORD

i want delete from these three

tables table1. user_id = table2.
> user_id and table1. user_id = table3.id

and group by

table1.type_id,table1.type_value

So... did you just post your password for your gmail accounts?!? — Nic3500, Nov 15 '17 at 04:09
Do you want to delete from 'adl_auth_user' Table? or Delete from the three tables? — DineshDB, Nov 15 '17 at 04:10
i want delete from these three tables table1. user_id = table2. user_id and table1. user_id = table3.id and group by table1.type_id,table1.type_value — Rinshan techintl, Nov 15 '17 at 04:13

Sambhu · Answer 1 · 2017-11-15T07:05:39.023

try this . delete the records from table according to the table dependencies.

i think grouping is not required as you are trying to delete the records


DELETE FROM adl_auth_user 
from adl_auth_user  A 
INNER JOIN user_details  B ON a.user_id=B.user_id
INNER JOIN adl_user  C ON b.user_id=c.id
WHERE A.user_id =1919 AND A.type_id =1

DELETE FROM user_details  
FROM user_details B 
INNER JOIN adl_user C ON b.user_id=c.id
WHERE B.user_id =1919 

DELETE FROM adl_user  
WHERE adl_user .id =1919

delete from three tables

1 Answers1