bleNameIn,"
order by ",ColNameIn);
Prepare s1 from @selStmt;
Execute s1;
Deallocate Prepare s1;
END|
DELIMITER ;
Dan
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 04, 2006 10:58 AM
To: mysql@lists.mysql.com
Subject: Stored Procedures Q
I have a dozen tables and I need to perform the same operations on them so
I thought I'd create a stored procedure and just pass the table name,
column name.
I was hoping it would take the parameters and substitute that in the code.
So it looks like this:
create procedure RankStock(IN TableN
