never mind. I found the answer: http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html
On 5/10/06, tom soyer <[EMAIL PROTECTED]> wrote:
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
