Solution for Migrating @Tbl Table Variables
We are trying to migrate our T-SQL code to MySQL. However, we use T-SQL Table variable extensively throughout our code (see syntax below). Does anyone have a good solution in MySQL to accomplish the same goal as these Table Variables?
Declare @Tmp Table (myid int, myfield varchar(100))
insert @Tmp
select tblid, tblfield from Table1
Subject
Written By
Posted
Solution for Migrating @Tbl Table Variables
March 27, 2006 10:43AM
February 14, 2007 01:29PM
February 14, 2007 04:24PM
September 08, 2008 01:05PM
September 08, 2008 01:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.