mysqlConcatenate column values from multiple rows
SELECT post_id, GROUP_CONCAT(tag SEPARATOR ', ')
FROM post_tags GROUP BY post_id;ctrl + cSELECT post_idselect id of a post as a first column | GROUP_CONCAT(tag SEPARATOR ', ')will concatenate values from multiple rows based on a grouping rule |
post_tagsour table that has 2 columns: | GROUP BY post_idgroup by |
More of Mysql
- Insert/update multiple rows in single query
- Disable ONLY_FULL_GROUP_BY mode
- How to find my.cnf config file
- Truncate all tables in a specific database
- Get largest tables list
- What is the MEDIUMTEXT column max size (length) in Mysql
- What is the TINYINT column max value and size in Mysql
- How to find duplicate varchar/text column values in table
- Make a pager (limit / offset) select query
- Reset autoincrement for a table
See more codes...