CODEWITHSUNDEEP
mysqlrdbms
kmarks2
kmarks2

Reputation: 4875

MySql stored procedure SET command -- when it errors

After Googling for awhile I didn't see an answer. Anyway I have a situation in a stored procedure where I do a set select like:

SET someVariable = (SELECT ...)

Anyway, due to some redundant records existing somewhere else in the system, this SELECT query used in the SET returns more than one row. I'm guessing this will cause breakage or badness? True, false?

Thanks.

Upvotes: 0

Views: 223

Answers (1)

bfavaretto
bfavaretto

Reputation: 71939

True. When assigning to a variable, the query must return a single row, containing a single column. You can also do it with this syntax:

SELECT someColumn INTO myVariable ... LIMIT 1;

Upvotes: 2

Related Questions