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
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 ...
INSERT INTO anotherTable ...
So if no rows were returned from the select I perform the ELSE block, otherwise I perform
the main IF block.