I am trying to create a procedure in MySql as following
delimiter //
create procedure search11(in table_name char(10))
begin
select * from table_name;
end; //
But when I am calling it as CALL search11('account');
It gives this error
ERROR 1146 (42S02): Table 'demo.table_name' doesn't exist
what's wrong with this....??