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

2009-12-10 Thread D. Dante Lorenso
Gavin Towey wrote: Creating a temporary merge table works fine for me on 5.0. Your table isn't innodb is it? That will fail with an error like you're getting. Strange. Now that I am on my home network and trying this again, it seems to be working. mysql> SELECT version(); +---

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

2009-12-10 Thread Gavin Towey
Creating a temporary merge table works fine for me on 5.0. Your table isn't innodb is it? That will fail with an error like you're getting. Regards, Gavin Towey -Original Message- From: Dante Lorenso [mailto:da...@lorenso.com] Sent: Thursday, December 10, 2009 3:20 PM To: mysql@lists.m