Re: stored procedure and random table name -> temp table, merge, prepared statement

2009-12-10 Thread D. Dante Lorenso
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

RE: stored procedure and random table name -> temp table, merge, prepared statement

2009-12-10 Thread Gavin Towey
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

stored procedure and random table name -> temp table, merge, prepared statement

2009-12-10 Thread Dante Lorenso
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