MySQL: variable = variable + select statement

Question

I've got several records in a temp table, and I'd like to take a value from each record and add it to a variable, e.g.

color          | caption
--------------------------------
red              stop
blue             state line
yellow           yield
orange           construction

var1 = 'red;blue;yellow;orange'

In MSSQL, I could do that this way:

-- MSSQL
select var1 = var1 + color
from signShapes

In MySQL, that doesn't work. I'd just get "orange."

-- mySQL
select var1 = concat(var1, color)
from signShapes

No, I know I could accomplish this with a cursor or a loop. I'm curious if I could do this without either, similarly to the MSSQL method.

Joel Coehoorn · Accepted Answer · 2015-01-05 03:18:01Z

2

 SELECT var1 = GROUP_CONCAT(color SEPARATOR ';')
 FROM signShapes
 GROUP BY color;

answered Jan 5, 2015 at 3:18

Joel Coehoorn

418k114 gold badges582 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Map's Edge Over a year ago

In the hopes of one day converting our company's rdbms to MySQL, I'm doing a few personal projects first to get a solid handle on things. I'm learning something new every day.

Gordon Linoff · Accepted Answer · 2015-01-05 03:17:40Z

1

Why not just do this?

select var1 = group_concat(color separator ';')
from signShapes;

answered Jan 5, 2015 at 3:17

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

MySQL: variable = variable + select statement

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related