List:General Discussion« Previous MessageNext Message »
From:Derek Downey Date:September 21 2011 6:34pm
Subject:Re: Stored Procedure Question
View as plain text  
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