Is there a way to get comma separated values of a column regardless of group_concat_max_len size?
0
I need to get the contents of a column as a comma-separated list.
SELECT GROUP_CONCAT(column) FROM table;
does the job but the table is very large and the default value for
group_concat_max_len is 1024.
SET GLOBAL group_concat_max_len = 999999;
I tried that to increase the size but it is not allowed because the app is running on a shared server and I don't have the privilege. What else can I try, please?
mysql
asked Jan 3 at 13:38
oracleoracle
33
add a comment |
0
I need to get the contents of a column as a comma-separated list.
SELECT GROUP_CONCAT(column) FROM table;
does the job but the table is very large and the default value for
group_concat_max_len is 1024.
SET GLOBAL group_concat_max_len = 999999;
I tried that to increase the size but it is not allowed because the app is running on a shared server and I don't have the privilege. What else can I try, please?
mysql
asked Jan 3 at 13:38
oracleoracle
33
1
Can you use any scripting language (Php, Perl, javascript, java, c# ...) ?
– Daniel E.
Jan 3 at 13:53
add a comment |
0
0
0
I need to get the contents of a column as a comma-separated list.
SELECT GROUP_CONCAT(column) FROM table;
does the job but the table is very large and the default value for
group_concat_max_len is 1024.
SET GLOBAL group_concat_max_len = 999999;
I tried that to increase the size but it is not allowed because the app is running on a shared server and I don't have the privilege. What else can I try, please?
mysql
asked Jan 3 at 13:38
oracleoracle
33
I need to get the contents of a column as a comma-separated list.
SELECT GROUP_CONCAT(column) FROM table;
does the job but the table is very large and the default value for
group_concat_max_len is 1024.
SET GLOBAL group_concat_max_len = 999999;
I tried that to increase the size but it is not allowed because the app is running on a shared server and I don't have the privilege. What else can I try, please?
mysql
mysql
asked Jan 3 at 13:38
oracleoracle
33
asked Jan 3 at 13:38
oracleoracle
33
asked Jan 3 at 13:38
oracleoracle
33
asked Jan 3 at 13:38
oracleoracle
33
asked Jan 3 at 13:38
oracleoracle
33
33
1
Can you use any scripting language (Php, Perl, javascript, java, c# ...) ?
– Daniel E.
Jan 3 at 13:53
add a comment |
1
Can you use any scripting language (Php, Perl, javascript, java, c# ...) ?
– Daniel E.
Jan 3 at 13:53
1
1
Can you use any scripting language (Php, Perl, javascript, java, c# ...) ?
– Daniel E.
Jan 3 at 13:53
Can you use any scripting language (Php, Perl, javascript, java, c# ...) ?
– Daniel E.
Jan 3 at 13:53
add a comment |
1 Answer
1
active
oldest
votes
1
You can increase the group_concat_max_len per session instead. You will have the rights for that.
SET SESSION group_concat_max_len = 999999;
- read more about it in the manual
answered Jan 3 at 14:23
fancyPantsfancyPants
39.9k167085
Thank you for the reply. This works well on localhost but after running the statement on the server, the result is still the same.
– oracle
Jan 4 at 14:25
What do you mean with "the same". There's actually no way (I know of) to deny the right to do this. What version exactly is running on the server?
– fancyPants
Jan 4 at 14:33
When I execute the statement, it's successful but the result is still limited. The PHPMyAdmin version on the server is 4.7.3, Database client version: libmysql - 5.1.73, PHP version: 5.6.30. I only get the desired result when I execute it in localhost.
– oracle
Jan 7 at 19:46
Try it in the official mysql command line client. Other frontends I don't trust one bit. When it works there, file a bug for phpmyadmin or whereever it's not working. And when your client is 5.1, your server is also 5.1 I assume? If so, don't you think it's time to update? This is not a supported version anymore. 5.5 is not supported. 5.6 came out in 2011!
– fancyPants
Jan 7 at 21:31
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54023425%2fis-there-a-way-to-get-comma-separated-values-of-a-column-regardless-of-group-con%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
You can increase the group_concat_max_len per session instead. You will have the rights for that.
SET SESSION group_concat_max_len = 999999;
- read more about it in the manual
answered Jan 3 at 14:23
fancyPantsfancyPants
39.9k167085
Thank you for the reply. This works well on localhost but after running the statement on the server, the result is still the same.
– oracle
Jan 4 at 14:25
What do you mean with "the same". There's actually no way (I know of) to deny the right to do this. What version exactly is running on the server?
– fancyPants
Jan 4 at 14:33
When I execute the statement, it's successful but the result is still limited. The PHPMyAdmin version on the server is 4.7.3, Database client version: libmysql - 5.1.73, PHP version: 5.6.30. I only get the desired result when I execute it in localhost.
– oracle
Jan 7 at 19:46
Try it in the official mysql command line client. Other frontends I don't trust one bit. When it works there, file a bug for phpmyadmin or whereever it's not working. And when your client is 5.1, your server is also 5.1 I assume? If so, don't you think it's time to update? This is not a supported version anymore. 5.5 is not supported. 5.6 came out in 2011!
– fancyPants
Jan 7 at 21:31
add a comment |
1
You can increase the group_concat_max_len per session instead. You will have the rights for that.
SET SESSION group_concat_max_len = 999999;
- read more about it in the manual
answered Jan 3 at 14:23
fancyPantsfancyPants
39.9k167085
Thank you for the reply. This works well on localhost but after running the statement on the server, the result is still the same.
– oracle
Jan 4 at 14:25
What do you mean with "the same". There's actually no way (I know of) to deny the right to do this. What version exactly is running on the server?
– fancyPants
Jan 4 at 14:33
When I execute the statement, it's successful but the result is still limited. The PHPMyAdmin version on the server is 4.7.3, Database client version: libmysql - 5.1.73, PHP version: 5.6.30. I only get the desired result when I execute it in localhost.
– oracle
Jan 7 at 19:46
Try it in the official mysql command line client. Other frontends I don't trust one bit. When it works there, file a bug for phpmyadmin or whereever it's not working. And when your client is 5.1, your server is also 5.1 I assume? If so, don't you think it's time to update? This is not a supported version anymore. 5.5 is not supported. 5.6 came out in 2011!
– fancyPants
Jan 7 at 21:31
add a comment |
1
1
1
You can increase the group_concat_max_len per session instead. You will have the rights for that.
SET SESSION group_concat_max_len = 999999;
- read more about it in the manual
answered Jan 3 at 14:23
fancyPantsfancyPants
39.9k167085
You can increase the group_concat_max_len per session instead. You will have the rights for that.
SET SESSION group_concat_max_len = 999999;
- read more about it in the manual
answered Jan 3 at 14:23
fancyPantsfancyPants
39.9k167085
answered Jan 3 at 14:23
fancyPantsfancyPants
39.9k167085
answered Jan 3 at 14:23
fancyPantsfancyPants
39.9k167085
answered Jan 3 at 14:23
fancyPantsfancyPants
39.9k167085
39.9k167085
Thank you for the reply. This works well on localhost but after running the statement on the server, the result is still the same.
– oracle
Jan 4 at 14:25
What do you mean with "the same". There's actually no way (I know of) to deny the right to do this. What version exactly is running on the server?
– fancyPants
Jan 4 at 14:33
When I execute the statement, it's successful but the result is still limited. The PHPMyAdmin version on the server is 4.7.3, Database client version: libmysql - 5.1.73, PHP version: 5.6.30. I only get the desired result when I execute it in localhost.
– oracle
Jan 7 at 19:46
Try it in the official mysql command line client. Other frontends I don't trust one bit. When it works there, file a bug for phpmyadmin or whereever it's not working. And when your client is 5.1, your server is also 5.1 I assume? If so, don't you think it's time to update? This is not a supported version anymore. 5.5 is not supported. 5.6 came out in 2011!
– fancyPants
Jan 7 at 21:31
add a comment |
Thank you for the reply. This works well on localhost but after running the statement on the server, the result is still the same.
– oracle
Jan 4 at 14:25
What do you mean with "the same". There's actually no way (I know of) to deny the right to do this. What version exactly is running on the server?
– fancyPants
Jan 4 at 14:33
When I execute the statement, it's successful but the result is still limited. The PHPMyAdmin version on the server is 4.7.3, Database client version: libmysql - 5.1.73, PHP version: 5.6.30. I only get the desired result when I execute it in localhost.
– oracle
Jan 7 at 19:46
Try it in the official mysql command line client. Other frontends I don't trust one bit. When it works there, file a bug for phpmyadmin or whereever it's not working. And when your client is 5.1, your server is also 5.1 I assume? If so, don't you think it's time to update? This is not a supported version anymore. 5.5 is not supported. 5.6 came out in 2011!
– fancyPants
Jan 7 at 21:31
Thank you for the reply. This works well on localhost but after running the statement on the server, the result is still the same.
– oracle
Jan 4 at 14:25
Thank you for the reply. This works well on localhost but after running the statement on the server, the result is still the same.
– oracle
Jan 4 at 14:25
What do you mean with "the same". There's actually no way (I know of) to deny the right to do this. What version exactly is running on the server?
– fancyPants
Jan 4 at 14:33
What do you mean with "the same". There's actually no way (I know of) to deny the right to do this. What version exactly is running on the server?
– fancyPants
Jan 4 at 14:33
When I execute the statement, it's successful but the result is still limited. The PHPMyAdmin version on the server is 4.7.3, Database client version: libmysql - 5.1.73, PHP version: 5.6.30. I only get the desired result when I execute it in localhost.
– oracle
Jan 7 at 19:46
When I execute the statement, it's successful but the result is still limited. The PHPMyAdmin version on the server is 4.7.3, Database client version: libmysql - 5.1.73, PHP version: 5.6.30. I only get the desired result when I execute it in localhost.
– oracle
Jan 7 at 19:46
Try it in the official mysql command line client. Other frontends I don't trust one bit. When it works there, file a bug for phpmyadmin or whereever it's not working. And when your client is 5.1, your server is also 5.1 I assume? If so, don't you think it's time to update? This is not a supported version anymore. 5.5 is not supported. 5.6 came out in 2011!
– fancyPants
Jan 7 at 21:31
Try it in the official mysql command line client. Other frontends I don't trust one bit. When it works there, file a bug for phpmyadmin or whereever it's not working. And when your client is 5.1, your server is also 5.1 I assume? If so, don't you think it's time to update? This is not a supported version anymore. 5.5 is not supported. 5.6 came out in 2011!
– fancyPants
Jan 7 at 21:31
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54023425%2fis-there-a-way-to-get-comma-separated-values-of-a-column-regardless-of-group-con%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Can you use any scripting language (Php, Perl, javascript, java, c# ...) ?
– Daniel E.
Jan 3 at 13:53