这个SQL语句在Mysql中该怎样写？ selectididentity(int,1,1),cinto#from(selectc@str1unionselectc@str2
这个SQL语句在Mysql中该怎样写？
select id=identity(int,1,1),c into #
from (
select c=@str1
union select c=@str2
union select c=@str3
union select c=@str4) t
[解决办法]
create temporary table `#`(id int(11) not null auto_increment primary key,str varchar(255));
insert into `#`(str) values(@str1),(@str2),(@str3),(@str4);