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?