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