Re: Multi Table Delete in 3.23.47

[zzapper]

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??

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