The correct parameter to set the maximum length is:
SET @@group_concat_max_len = value_numeric;
value_numeric must be > 1024; by default the group_concat_max_len value is 1024.
Featured Post
What is the purpose of the php.ini file?
The PHP configuration file, php.ini , is the final and most immediate way to affect PHP's functionality. The php.ini file is read ea...
Subscribe to:
Post Comments (Atom)
Popular Posts
-
You can find maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum sala...
-
Answer: select * from emp where hiredate < (’01-jan-81’);
No comments:
Post a Comment