MySQL Forums
Forum List  »  Quality Assurance

Re: Cursor cannot explicitly SELECT more than one item of different type
Posted by: Thomas CORBIERE
Date: October 04, 2007 01:01AM

Hello,

This is not a bug, it's because you use a variable with the same name as the table field.
Variable name used in a query have priority hover column name.
Since your value variable has not been initialized, it effectively contains NULL,
and you are assigning this value to itself.

By using "SELECT *", you are not using the variable name in the query anymore.
That's why the problem is solved.

Regards,

Thomas CORBIERE

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cursor cannot explicitly SELECT more than one item of different type
2491
October 04, 2007 01:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.