List:General Discussion« Previous MessageNext Message »
From:Brandon Phelps Date:September 21 2011 6:41pm
Subject:Re: Stored Procedure Question [SOLVED]
View as plain text  
Ah ha!  Thanks Derek.  I thought INTO was used strictly for inserting the selected records
into another table.

Much appreciated.


On 09/21/2011 02:34 PM, Derek Downey wrote:
> SELECT id INTO @row_id FROM myTable WHERE<blah blah>  LIMIT 1;
>
> Source
> http://dev.mysql.com/doc/refman/5.5/en/select-into-statement.html
>
> On Sep 21, 2011, at 2:23 PM, Brandon Phelps wrote:
>
>> Hello all,
>>
>> I would like to create a stored procedure that does the following:
>>
>> 1. Accepts 4 values as parameters
>> 2. SELECTS 1 record (LIMIT 1) from a table where the 4 parameters match fields in
> that table
>> 	a. If a record was returned then UPDATE the table
>> 	b. If a record was not returned then INSERT into a different table
>>
>> My main question here is how can I execute a SELECT id FROM ... LIMIT 1 statement
> within a stored procedure then use the returned id field later in the procedure?
>>
>> Something like this:
>>
>> @row_id = SELECT id FROM myTable WHERE<blah blah>  LIMIT 1;
>>
>> IF @row_id != nothing THEN
>> 	UPDATE myTable ...
>> ELSE
>> 	INSERT INTO anotherTable ...
>> END IF
>>
>> So if no rows were returned from the select I perform the ELSE block, otherwise I
> perform the main IF block.
>>
>> Thanks!
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>
>
>
Thread
Stored Procedure QuestionBrandon Phelps21 Sep
  • Re: Stored Procedure QuestionDerek Downey21 Sep
    • Re: Stored Procedure Question [SOLVED]Brandon Phelps21 Sep