mysql 存储过程 求大神指点
在SqlServer中编写的 这个语句
DECLARE @t TABLE(id INT ,class VARCHAR(100) ,pid INT)
INSERT INTO t
execute
( 'SELECT ' + idName + ' AS id,' + className
+ ' AS class,' + pidName + ' AS pid FROM ' + tableName
+ ''
)
如何转换成可以在 mysql中也能执行,现在转换成下面格式,但execute处出错,要怎么修改才能执行呢??
CREATE TEMPORARY TABLE t (id INT ,class VARCHAR(100) ,pid INT);
INSERT INTO t
execute
( 'SELECT ' + idName + ' AS id,' + className
+ ' AS class,' + pidName + ' AS pid FROM ' + tableName
+ ''
)