Re: SELECT ... INTO grammar enhancement

[Paul Cadach]

Hi,

----- Original Message -----
From: "Michael Widenius" <monty@stripped>
To: "Antony T Curtis" <antony@stripped>
Cc: <internals@stripped>
Sent: Sunday, June 10, 2001 4:45 PM
Subject: SELECT ... INTO grammar enhancement


>
> Hi!
>
> >>>>> "Antony" == Antony T Curtis <antony@stripped> writes:
>
> Antony> Allows grammar such as
>
> Antony> SELECT tote_seq_no INTO @seq
> Antony>   FROM toteq WHERE tote_no=@tote AND zone=@zone AND status="O"
> Antony>   ORDER BY tote_seq_no
> Antony>   LIMIT 1;
>
> Thanks for the patch, but I wouldn't like to accept this in this form.
>
> The right way to do this would be to do:
>
> SET @SEQ= SELECT tote_seq_no INTO @seq FROM toteq WHERE tote_no=@tote AND
zone=@zone AND status="O" ORDER BY tote_seq_no LIMIT 1;

Do you mean
SET @SEQ= SELECT tote_seq_no FROM toteq WHERE ...?


WBR,
Paul.