MySQL: Concat all columns

Question

for example we have a table with the columns "id", "name", "type", "year". My target output would be SELECT CONCAT(id, name, type, year) FROM table.

Is it possible to do this without knowing the columns, so I can use it with every table I want without analysing its columns first? Something like CONCAT(*)?

I hope you can help me.

Thank you very much.

Regards Wulf

It is not possible. The fileld names have to be known. But you can output data into the CSV file without field separator. — Devart
– Devart, Commented Oct 28, 2011 at 9:48

kasimir · Accepted Answer · 2011-10-28 11:05:40Z

6

AFAIK, you first have to know the columns. This

SHOW COLUMNS FROM table

will return all columns. Use the result to make your SELECT query.

answered Oct 28, 2011 at 11:05

kasimir

1,5441 gold badge21 silver badges30 bronze badges

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

1 Comment

Wulf Over a year ago

Too bad that there is no * way, but thanks anyway! This is how I'm doing it already.

Nanocom · Accepted Answer · 2011-10-28 09:45:37Z

2

Check the information_schema table of MySQL, it contains meta-information concerning your tables. http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

answered Oct 28, 2011 at 9:45

Nanocom

3,7265 gold badges34 silver badges46 bronze badges

Collectives™ on Stack Overflow

MySQL: Concat all columns

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