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