zzapper wrote:
> On Wed, 27 Apr 2005 09:50:37 +0100, wrote:
>
>
>>zzapper wrote:
>>
>>>On Tue, 26 Apr 2005 23:22:46 +0100, wrote:
>>>
>>>
>>>
>>>>Hi,
>>>>
>>>>The following query runs fine in recent versions of mysql 4.1x etc
>>>>
>>>>delete from t2 using tbl_User as t1,tbl_UserTopic as t2 where
> (t1.txtemail='fredred@stripped')
>>>>and (t1.intID = t2.intID);
>>>>
>>>>But not in 3.23.47 I can't find any reference in the manuals to why this
> might be.
>>>>
>>>>Is there any change in syntax which will make the query work in 3.23.47?
>>>
>>>
>>>I mean how did you do this before 4.x??
>>>
>>
>>No trick will make it work with a 3.23. You'll need to program it
>>yourself with your favorite langage (PHP, Perl, Templeet, C...).
>>I know it's painful... (but it's great to have it in 4.0 as well as
>>multi-table updates)
>>
>>--
>>Philippe Poelvoorde
>>COS Trading Ltd.
>
> Thanx Philippe that stops me scratching about looking for a non-existant solution.I'm
> happy to write
> a perl script just wished I tried it sooner! It's so wretched when your ISP won't
> upgrade their S/W
I reckon, it's a bit hidden in the middle :
"Starting with MySQL 4.0.4, you can also perform UPDATE operations
that cover multiple tables:"
in :
http://dev.mysql.com/doc/mysql/en/update.html
--
Philippe Poelvoorde
COS Trading Ltd.
