BestHub
Sign in
Tag

GROUP_CONCAT

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 31, 2023 · Databases

Useful MySQL Functions and SQL Techniques for Data Manipulation

This article presents a collection of practical MySQL functions and SQL commands—including GROUP_CONCAT, CHAR_LENGTH, LOCATE, REPLACE, NOW, INSERT…SELECT, INSERT…IGNORE, SELECT FOR UPDATE, ON DUPLICATE KEY UPDATE, SHOW CREATE TABLE, CREATE TABLE … SELECT, EXPLAIN, SHOW PROCESSLIST, and mysqldump—explaining their purposes, usage patterns, and providing concrete example queries with results.

Database AdministrationGROUP_CONCATMySQL
0 likes · 13 min read
Useful MySQL Functions and SQL Techniques for Data Manipulation
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 2, 2021 · Databases

Resolving MySQL GROUP_CONCAT Length Limit Issues in Doctor Scheduling

This article explains a real‑world MySQL GROUP_CONCAT truncation problem caused by the default length limit, demonstrates how it affected a doctor‑scheduling system, and provides two practical solutions: increasing the group_concat_max_len setting or adjusting the business logic to reduce concatenated data.

DatabaseGROUP_CONCATMySQL
0 likes · 6 min read
Resolving MySQL GROUP_CONCAT Length Limit Issues in Doctor Scheduling