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.
