sql语句查询结果

[java_303]

比如select id from room where roomcode = 1;
我想把这个查询出来的结果给一个变量可以不了？
怎么弄了。请牛人帮忙解决下，谢谢！

[WWWWA]

select id INTO 变量 from room where roomcode = 1;

[ydage]

#把字段id的值赋给变量id
select @id := id from room where roomcode = 1;

#查询变量内容
select @id;