When I run the query below, I only get half my column names surrounded by single quotes(which was exactly 1025 characters). I using Sequel Pro's query execution window. I have tried to type cast @columnNames. No luck.
select group_concat(concat("'",column_name, "'")) into @columnNames
where [email protected];
Because I have to know..... :)
Change the value of the
group_concat_max_len server variable, which by default is 1024, prior to executing your query.
The maximum permitted result length in bytes for the GROUP_CONCAT() function.
The default is 1024.
SET SESSION group_concat_max_len = 1000000; -- or any other appropriate value