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.

GROUP_CONCATON DUPLICATE KEY UPDATEchar_length

0 likes · 13 min read

Useful MySQL Functions and SQL Techniques for Data Manipulation

ITPUB

Dec 24, 2022 · Databases

Master MySQL: 13 Essential Functions and Commands Every Developer Should Know

This guide walks you through 13 practical MySQL techniques—from aggregating values with GROUP_CONCAT and measuring string length with CHAR_LENGTH, to locating substrings, replacing text, retrieving timestamps, bulk inserting data, handling duplicate keys, inspecting table structures, and using diagnostic commands like EXPLAIN and SHOW PROCESSLIST—complete with ready‑to‑run SQL examples and visual results.

GROUP_CONCATInsertNOW

0 likes · 13 min read

Master MySQL: 13 Essential Functions and Commands Every Developer Should Know

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.

ConfigurationGROUP_CONCATdatabase

0 likes · 6 min read

Resolving MySQL GROUP_CONCAT Length Limit Issues in Doctor Scheduling