How to Concatenate Strings in MySQL (xeround)

Question

I'm in a Stored Procedure, and I need to concatenate 3 parameters PLUS a static string to create a unique ID for a table.

So the SP has, let's say, p1, p2 and p3 as varchar parameters, and I want to insert a new row in a table with values p1, p2, p3 and the 4th column would be 'ABC'+p1+p2+p3. I'm using || but it doesn't work. It returns 1. How do I concatenate in MySQL (xeround) and, also, do I need to use @p1 as in transact sql? I mean, using p1 worked for the INSERT.

Thanks.

score 7 · Accepted Answer · answered Sep 11 '12 at 15:51

7

CONCAT is used for concatenation in mysql. So your code should be,

CONCAT('ABC', p1, p2, p3)

answered Sep 11 '12 at 15:51

John Woo

258,903
69
498
492

@Amarundo i can help you in mysql but not in `xeround`. it's new technology to me . sorry. – John Woo Sep 11 '12 at 16:20
I'm such a donkey... I was missing a parenthesis... THANKS! – Amarundo Sep 11 '12 at 16:24
1

xeround is just a MySQL hosting service for ignorami like me. – Amarundo Sep 11 '12 at 16:25

score 1 · Answer 2 · edited Oct 02 '15 at 16:48

1

Use GROUP_CONCAT() as explained further here.

edited Oct 02 '15 at 16:48

Ross Rogers

23,523
27
108
164

answered Sep 11 '12 at 16:31

CodeTalk

3,571
16
57
92

How to Concatenate Strings in MySQL (xeround)

2 Answers2

Linked

Related