Re: Solution for Migrating @Tbl Table Variables

[Jay Pipes]

Just use a temporary table in the procedure:

DELIMITER //
CREATE PROCEDURE my_proc () BEGIN

CREATE TEMPORARY TABLE TempTable (myid int, myfield varchar(100));
INSERT INTO TmpTable SELECT tblid, tblfield FROM Table1;

/* Do some more stuff .... */

END//

Cheers,

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com