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 wa
ion, but I've
certainly learnt 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, 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
Hi there,
I've got a small issue which looks a little like a bug. 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 |