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
I reckon, it's a bit hidden in the middle :
"Starting with MySQL 4.0.4, you can also perform UPDATE operations that cover multiple tables:"
in :
http://dev.mysql.com/doc/mysql/en/update.html
-- 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]
