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