how to concat in mysql server

Question

Having trouble concat this code in mysql server any ideas?

DECLARE @letters TABLE(letter VARCHAR(3))

INSERT INTO @letters VALUES('A'),('B'),('C'),('D'),('E'),('F'),('G'),('H'),('I'),('J'),('K') ,('L'),('M'),('N'),('O'),('P'),('Q'),('R'),('S'),('T'),('U'),('V') ,('W'),('X'),('Y'),('Z')

The first idea: "Having trouble" isn't a technical explanation for the issue — zerkms, Jun 25 '14 at 02:20
Sorry, what i meant was I'm looking for the code of how to concat the code above — Amped, Jun 25 '14 at 02:27
Of course you are having problems. You are using SQL Server constructs in MySQL. You are declaring `table` as a table variable, which is SQL Server. — Gordon Linoff, Jun 25 '14 at 02:27
What do you mean by concat? One single row with all letters? — shree.pat18, Jun 25 '14 at 02:27

Mohd Dhiyaulhaq · Answer 1 · 2014-06-25T02:33:39.587

0

Try my suggestion

DECLARE @letters tableName (columnName)

INSERT INTO @letters
VALUES ('A'),('B'),('C'),('D'),('E'),('F'),('G'),('H'),('I'),('J'),('K'),
        ('L'),('M'),('N'),('O'),('P'),('Q'),('R'),('S'),('T'),('U'),('V'),
        ('W'),('X'),('Y'),('Z');

edited Jun 25 '14 at 02:33

answered Jun 25 '14 at 02:27

Mohd Dhiyaulhaq

89
1
14

Okay thanks now my only problem is how can i concat 3 random letter in 1 row here's my code. Missing is the concat. INFO: -queue_length is how many data will show -@letter is my table `SELECT TOP (@queue_length)* FROM @letters ORDER BY NEWID()` – Amped Jun 25 '14 at 03:00
maybe this is what you want [random row](http://stackoverflow.com/questions/4329396/mysql-select-10-random-rows-from-600k-rows-fast) – Mohd Dhiyaulhaq Jun 25 '14 at 03:16

how to concat in mysql server

1 Answers1