Error: 'demo.table_name' doesn't exist

422 Views Asked by At

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....??

0

There are 0 best solutions below