yhow, let me know what you think of this strategy for sidestepping the
need for prepared statements when working with MyISAM tables passed to
stored procedures.
-- Dante
Regards,
Gavin Towey
-Original Message-----
From: Dante Lorenso [mailto:da...@lorenso.com]
Sent: Thursday, December 10, 2009 3:20
To: mysql@lists.mysql.com
Subject: stored procedure and random table name -> temp table, merge, prepared
statement
All,
I have a stored procedure that I'm writing where I need to run a lot of
queries against a particular table. The name of the table will be a
parameter to the stored procedure
All,
I have a stored procedure that I'm writing where I need to run a lot of
queries against a particular table. The name of the table will be a
parameter to the stored procedure ... example:
CALL normalize_data('name_of_table_here');
Since I want to run queries against this table, I don't want