Skip navigation links

MySQL Forums :: Stored Procedures :: How to Exec variable contenting SQL statement in Procedure?


Advanced Search

How to Exec variable contenting SQL statement in Procedure?
Posted by: Tuan Nguyen ()
Date: March 21, 2005 04:12AM

I have one procedure Such as:
create procedure (in Fieldname varchar(100))
begin
declate SQL varchar(200);
set SQL='select '+Fieldname+' From Table1 where CodeID=0001';
Exec SQL;
'here i want to exec SQL variable SQL the same SQL server, but i can not
end
-I need so much, Help me, thanks.

Options: Reply•Quote


Subject Views Written By Posted
How to Exec variable contenting SQL statement in Procedure? 9232 Tuan Nguyen 03/21/2005 04:12AM
Re: How to Exec variable contenting SQL statement in Procedure? 4691 Andrew Gilfrin 03/21/2005 07:39AM
Re: How to Exec variable contenting SQL statement in Procedure? 4009 Tuan Nguyen 03/22/2005 01:26AM
Re: How to Exec variable contenting SQL statement in Procedure? 3944 Tuan Nguyen 03/22/2005 03:16AM
Re: How to Exec variable contenting SQL statement in Procedure? 3951 Andrew Gilfrin 03/22/2005 02:50AM
Re: How to Exec variable contenting SQL statement in Procedure? 3688 Atanas Todorov 03/29/2005 12:45AM
Re: How to Exec variable contenting SQL statement in Procedure? 7991 Andrew Gilfrin 03/29/2005 01:45AM


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

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.