MySQL Stored Procedure

[buddhad]

Hello All,

I am trying to create a stored procedure in MySQL that takes as input, among other values, a parameter that gives a column name to select. I can't seem to get this to work and am not even sure if it is possible. So my question would be, is this possible and if so how? I am posting some code to show what I have tried so far.


create procedure myProc (col_name varchar(100), ...)
begin
select col_name from table where ....;
end

create procedure myProc(col_name varchar(100),...)
begin
set @s = "select " + col_name + " from table where ...";
prepare testStmt from @s;
execute testStmt using ...;
deallocate testStmt;
end


Thanks in advance

AG

[HNPFL]

Depending on the version of MySql that your server is running will depend on weather or not you can even run a stored procedure. The newest version does.