mysql : How to add data to the existing data stored in a variable?

Question

我希望将数据添加到我在 Mysql 中创建的现有变量中。

set @variable = select * from b where b.id = 35;

@variable = select * from b where b.name = "dheeraj";

我怎样才能继续进行这种类型的查询。

Answer 1

set @variable := (select name.* from a)  

set @variable := concat(@variable , ',' , select name.* from b)