group_concat column/text limitation

aagha posted 1 week ago in General

I'm faced with a table with approx. 100 columns. However, when I run this query, I only get about 57 rows returned--and the last value is a partial so I'm guessing there's a text limitation:

select group_concat(column_name) from information_schema.columns where table_name = 'my100columntable' and table_schema = 'mydb';

Is there a way to get the full output or extend the text limitation?

aagha posted 1 week ago

Looks like I found my answer here:

stackoverflow.com / questions/2567000/mysql-and-group-concat-maximum-length

Please login to leave a reply, or register at first.