MySQL Forums
Forum List  »  Stored Procedures

Re: How to Exec variable contenting SQL statement in Procedure?
Posted by: Tuan Nguyen
Date: March 22, 2005 03:16AM

But when you creating new function you also collection the variable(fieldname) to make the SQL before you Exec to return result
EXample :
sql='select ' + fieldname + 'from table1'
' how to execute here
-if you do this sql
"select fieldname from table1" , you don't collecting fieldname from variable, error

Options: ReplyQuote

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.