MySQL Forums
Forum List  »  German

Re: delete with inner join doesnt work
Posted by: steve perp
Date: April 22, 2019 03:03AM

Hi Peter
Thanks!
But my tables T1 and T2 have the same parameter as primary key.
Thats why line 3

DELETE T1, T2
FROM T1
INNER JOIN T2 ON T1.id = T2.id
WHERE T1.name = "TG-%";

I didnt create/implemenrt a foreign key.
Is it possible to create that later/now?
Steve

Options: ReplyQuote


Subject
Views
Written By
Posted
970
April 20, 2019 12:08PM
Re: delete with inner join doesnt work
380
April 22, 2019 03:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.