Search code examples
mysqlpivotsqlfiddle

Mysql, pivot table working in sqlfiddle but not working in phpmyadmin

I had recently posted a question that was miraculously answered in regards to pivoting a mysql result. Although it was solved and worked in the accompanied sqlfiddle, I can't seem to get the query working when I bring it back onto my database (in phpmyadmin). I checked the versions, and the fiddle is version 5.1.61 and my MySql is 5.1.66-cll. Any thoughts? Here is the fiddle: http://sqlfiddle.com/#!8/59727/1 thank you in advnace for any help.

Solution

  • Based on your comment and previous question about pivoting. It sound like you need to increase the length of the GROUP_CONCAT() function.

    The default length is 1024.

    To change the length you will want to use the following before your code to generate the dynamic sql query:

    SET [GLOBAL | SESSION] group_concat_max_len = val;

    You can either change the GLOBAL or SESSION length and replace the val with the length that you need.