On 22-Jan-2004 Michael McTernan wrote:
Hi there,
Thanks for your quick response!
Why all the locks, temp tables and updates? You can just do:
SELECT
CASE WHEN B.y IS NULL THEN A.x ELSE B.y END AS newX
FROM
A LEFT JOIN B ON A.x = B.x
Spot on - many thanks! I wasn't aware of the
Michael McTernan said:
I'm using MySQL 4.0.15-standard-log, on RedHat 9.0 with InnoDb tables.
Essentially I have two tables, one table is a list of integers,
while the second is a table of integer pairs. e.g.
+---+ +-+-+
| A | | B.x | B.y |
+---+ +-+-+
| 1 | | 1
something now :)
Thanks,
Mike
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: 22 January 2004 16:38
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: LOCK TABLES and multi table UPDATE
Michael McTernan said:
I'm using MySQL 4.0.15-standard-log