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='[EMAIL PROTECTED]') >>>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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]