Re: Stored_Procedure/table_names and from table_name errors [SOLVED]

On Sun, 2006-10-29 at 22:06 +0800, Ow Mun Heng wrote: > Hi, > > Learning about MySQL's stored procedure programming. > > trying to do things like count(*) of the # of rows in a specific table. > When I try to put the table_names as a variable I don't get anything > > eg: > DELIMITER $$ > DROP PR

Stored_Procedure/table_names and from table_name errors

Hi, Learning about MySQL's stored procedure programming. trying to do things like count(*) of the # of rows in a specific table. eg: DELIMITER $$ DROP PROCEDURE IF EXISTS `test`.`sp_countrows`$$ CREATE [EMAIL PROTECTED] PROCEDURE `sp_countrows`() BEGIN SELECT count(*) AS 'Test1(QTY)' FROM test