Mysql delete inner join ainult ühest tabelist

  |   by kadriad   |   Blogi, mysql  |  No Comments

Lihtsalt igaks juhusk panen kirja mysql delete query, kui on vaja kustutada ühest tabelist:

mysql> DELETE ab, b
-> FROM Authors AS a INNER JOIN AuthorArticle AS ab ON a.AuthID=ab
+.AuthID
-> INNER JOIN Articles AS b ON ab.ArticleID=b.ArticleID
-> WHERE AuthorFirstName='Tom';

 

http://www.perlmonks.org/?node_id=891236