469,648 Members | 1,417 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

GROUP_CONCAT not working for > 283

rizwan6feb
108 100+
I have created a table (with only 2 fields) with the following query
Expand|Select|Wrap|Line Numbers
  1. "CREATE TABLE `users` (
  2. `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  3. `name` VARCHAR( 20 ) NOT NULL
  4. ) ENGINE = MYISAM ;"
  5.  
There are 20,000 users in this table with ids from 1 to 20,000

On executing the following query
Expand|Select|Wrap|Line Numbers
  1. select group_concat(id separator ',') from users
returns only 283 ids separated with ','
May 15 '08 #1
2 1709
rizwan6feb
108 100+
I have found a solution myself, this is because of a session variable group_concat_max_len, which is set to 283, can be changed with
@@group_concat_max_len = 9999999;'
May 15 '08 #2
ronverdonk
4,258 Expert 4TB
Good to know. Thank you for this info. Good luck.

Ronald
May 15 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by peter stickney | last post: by
reply views Thread by gmorris | last post: by
2 posts views Thread by rastrol7 | last post: by
bilibytes
1 post views Thread by bilibytes | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.