这个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);