How to write and execute the dynamic stored procedure in mysql database

See more:

MySQL

CREATE PROCEDURE `Get_Reports_Dyanamic`(
IN pTableName varchar(20),
IN pColumnName varchar(2000)
)
begin

set @s=Concat("Select", @ColumnName, 'From',@TableName);
Prepare stmt from @s;
EXECUTE stmt;
DEALLOCATE Prepare stmt;
END


hii dear all,i have create this procedure to select columns from table dynamically but i dont have any idea about how to run this stored procedure...so anyone can help me this sortout this issue..plz

What I have tried:

CREATE PROCEDURE `Get_Reports_Dyanamic`(
IN pTableName varchar(20),
IN pColumnName varchar(2000)
)
begin

set @s=Concat("Select", @ColumnName, 'From',@TableName);
Prepare stmt from @s;
EXECUTE stmt;
DEALLOCATE Prepare stmt;
END