Re: MySQL DELETE with INNER JOIN

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 AuthorLastName='Tom';
Query OK, 0 rows affected (0.01 sec)
[download]

You may want to consider an example that actually deletes something.

But don't post it here. This site is about Perl, not MySQL. The MySQL documentation explains it in detail, giving alternative syntaxes as well.

Comment on Re: MySQL DELETE with INNER JOIN Download Code

Replies are listed 'Best First'.
Re^2: MySQL DELETE with INNER JOIN by lancer (Scribe) on Mar 03, 2011 at 16:26 UTC
I know it doesn't work. I just think it is a good example, if the code can be fixed. I have done this once already, when I first saw this example on the net. Then it proved to be a very valuable learning resource for me. I needed this knowledge again today, so I've google'd it up. I decided to post it here so that others can learn from it. I know it's not Perl, but I remember reading here somewhere that about 5% of the posts can be off-topic, and, it's possible to use MySQL from Perl, so I believe it can be useful to at least a few people on this site.	[reply]

Replies are listed 'Best First'.

Re^2: MySQL DELETE with INNER JOIN
by lancer (Scribe) on Mar 03, 2011 at 16:26 UTC

I know it doesn't work.

I just think it is a good example, if the code can be fixed. I have done this once already, when I first saw this example on the net. Then it proved to be a very valuable learning resource for me.

I needed this knowledge again today, so I've google'd it up.

I decided to post it here so that others can learn from it. I know it's not Perl, but I remember reading here somewhere that about 5% of the posts can be off-topic, and, it's possible to use MySQL from Perl, so I believe it can be useful to at least a few people on this site.

[reply]