Hi, I tried to pass the name of a table into a procedure and use that in a select statement. Somehow it doesn't work. Here is the code:
create procedure sp3(in tablename varchar(10)) begin select count(*) from tablename; end$ When the procedure is called, I got the following error: ERROR 1146 (42S02): Table 'test.tablename' doesn't exist. Does anyone know why my code generated an error? Is this a bug? Thanks, Tom