I have :
mysql> select version();
+-------------------+
| version() |
+-------------------+
| 4.0.2-alpha-debug |
+-------------------+
1 row in set (0.00 sec)
But an error too :
mysql> delete
-> from
-> externallink as link,
-> topic as topic,
-> topiclink as joiner
-> where
-> link.resid = joiner.resid and
-> topic.catid = joiner.catid and
-> topic.rid like "%Industry%";
ERROR 1064: You have an error in your SQL syntax near 'as link,
topic as topic,
topiclink as joiner
?
thanks.
> mysql version 4.x does this
>
> -----Original Message-----
> From: David yahoo [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 01, 2002 5:28 PM
> To: [EMAIL PROTECTED]
> Subject: multiple delete for mysql
>
>
> Hi all,
>
> How can i do a delete from multiple table in mysql?
>
> Eg :
>
> I want ot delete record something like that I dont when to select but
delete
>
> delete
> from
> externallink as link,
> topic as topic,
> topiclink as joiner
> where
> link.resid = joiner.resid and
> topic.catid = joiner.catid and
> topic.rid like "%Industry%";
>
> I want to delete row from link joiner and topic too on cascad that
> correspond to that.
>
> Or have i to do 3 delete ?
>
> delete from topic where rid like "%industry%"
> and now how to delete ? where topic.id "not in" joiner ?
> and finaly how to delete link that doesnt have their id in joiner ?
>
>
> Thanks.
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
