Mysql Group_Concat : Alle Werte zeigen

Submitted by Gast (nicht überprüft) on Di, 02/19/2019 - 01:39

Man muss erst group_concat_max_len  erhöhen;


SET SESSION group_concat_max_len = 123456789;

select group_concat(nid, ',') from news where year='2019';

 

Comments

Gespeichert von Gast (nicht überprüft) am/um Sa, 11/02/2019 - 01:14

Permanenter Link

SET SESSION group_concat_max_len = 10240 ; insert into `test_text` values (null, ( concat( ( select SUBSTRING_INDEX(GROUP_CONCAT(title separator ' '), ',', 10) from news where id>4000123 and lang='french' ORDER BY rand() ), ' ', ( select SUBSTRING_INDEX(GROUP_CONCAT(description separator ' '), ',', 10) from news where id>4000123 and lang='french' ORDER BY rand() ) ) ) )

Neuen Kommentar schreiben

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.