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
--
zzapper
vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?"
http://www.rayninfo.co.uk/tips/ vim, zsh & success tips
