Mysql Group_Concat : Alle Werte zeigen

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';

 

MySQL

Comments

Profile picture for user Guest

Sa, 11/02/2019 - 01:14

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

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

Suche

Neueste Kommentare

  • Intel(R) Xeon(R) E-2288G CPU @ 3.70GHz

    3 weeks 2 days ago
    CPU benchmarking with sysbench (single-threaded/all cores)

     

    # sysbench --threads="$(nproc)" cpu run

  • AMD Ryzen 7 PRO 3700 8-Core Processor

    3 weeks 2 days ago
    CPU benchmarking with sysbench (single-threaded/all cores)

    # sysbench --threads="$(nproc)" cpu run

  • Reload .bashrc without logging out

    3 weeks 2 days ago
    Linux Autovervollständigung - bash autocomplete
    source ~/.bashrc

    Diese Lösung wird empfohlen aber hat bei mir nicht funktioniert.

    Welche Alternative gibt es?

  • Composer + PHP 8.3

    3 weeks 2 days ago
    PHP-CLI auf PHP8.2 umstellen (für Composer, Drush etc)

    ln -snf /opt/plesk/php/8.3/bin/php /etc/alternatives/php

  • composer.json

    4 weeks ago
    Drush Update failed (require php >=8.2)

    In composer.json, update: 

     

  • Empty Flood Table

    4 weeks ago
    Drupal: Anmeldung fehlgeschlagen Es hat mehr als 5 fehlerhafte Anmeldeversuche für dieses Benutzerkonto gegeben. Es ist vorübergehend gesperrt. 
    drush sqlq "DELETE FROM flood"

  •  
    Gmail Apps (SMTP Login):…

    4 weeks ago
    Drupal SMTP + Gmail funktioniert nicht mehr (Passwort ist richtig); was ist die Lösung?

     

    Gmail Apps (SMTP Login):

    https://security.google.com/settings/security/apppasswords

  • Problem (symfony_mailer)

    4 weeks ago
    Failed to authenticate on SMTP server with username gmail.com using the following authenticators: "LOGIN", "PLAIN", "XOAUTH2". Authenticator "LOGIN" returned "Expected response code "235" but got code "535",

    Type    symfony_mailer
    Date    Mo, 28. 08 2024 - 10:14
    User    admin

  • Update DB Table 'config'

    1 month 1 week ago
    Failed to authenticate on SMTP server with username gmail.com using the following authenticators: "LOGIN", "PLAIN", "XOAUTH2". Authenticator "LOGIN" returned "Expected response code "235" but got code "535",

    Update two fields (blob) in Table "config"!

    Search 'name': 

    1. smtp.settings 
    2. symfony_mailer.mailer_transport.smtp

     

     

  • Admin:

    /admin/config…

    1 month 3 weeks ago
    The following embed button(s) are not using SVG icons and will not be compatible with CKEditor5

    Admin:

    • /admin/config/content/embed/button/manage/media
    • /admin/config/content/embed

     

    Convert PNG to SVG & Upload!