List:Internals« Previous MessageNext Message »
From:Michael Widenius Date:June 11 2001 4:12pm
Subject:Re: SELECT ... INTO grammar enhancement
View as plain text  
Hi!

>>>>> "Paul" == Paul Cadach <paul@stripped> writes:

<cut>

>>>>> "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
Paul> zone=@zone AND status="O" ORDER BY tote_seq_no LIMIT 1;

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

Yes; (Sorry for the wrong set cut and paste)

Regards,
Monty
Thread
query engine and parserManish Chakrabarti6 Jun
  • query engine and parserMichael Widenius7 Jun
  • Re: query engine and parserSasha Pachev7 Jun
  • SELECT ... INTO grammar enhancementAntony T Curtis8 Jun
    • SELECT ... INTO grammar enhancementMichael Widenius10 Jun
  • Re: SELECT ... INTO grammar enhancementAntony T Curtis8 Jun
  • Re: SELECT ... INTO grammar enhancementAntony T Curtis8 Jun
  • Re: SELECT ... INTO grammar enhancementPaul Cadach11 Jun
    • Re: SELECT ... INTO grammar enhancementMichael Widenius11 Jun
  • Re: SELECT ... INTO grammar enhancementCharlie Root11 Jun
    • Re: SELECT ... INTO grammar enhancementMichael Widenius11 Jun
      • MySQL Model: Re: SELECT ... INTO grammar enhancementRussell E Glaue11 Jun
        • Re: MySQL Model: Re: SELECT ... INTO grammar enhancementAntony T Curtis12 Jun
        • MySQL Model: Re: SELECT ... INTO grammar enhancementMichael Widenius12 Jun