Mysql 拼接某列为一个值 && group_concat()函数
2023-09-14 09:13:14 时间
Mysql 拼接某列为一个值 && group_concat()函数
1.需求
将表中某一字段的值全部选出,并拼接成一个值。
2.代码
- 查看表数据
mysql> select * from t;
+------+
| a |
+------+
| x |
| x |
| x |
| y |
| y |
| z |
| a |
| z |
+------+
8 rows in set (0.04 sec)
- 将该列中的字段分组然后拼接
mysql> select
-> group_concat(a)
-> from t
-> group by a;
+-----------------+
| group_concat(a) |
+-----------------+
| a |
| x,x,x |
| y,y |
| z,z |
+-----------------+
4 rows in set (0.02 sec)
- 直接拼接该字段中的所有值
mysql> select
-> group_concat(a)
-> from t;
+-----------------+
| group_concat(a) |
+-----------------+
| x,x,x,y,y,z,a,z |
+-----------------+
1 row in set (0.00 sec)
- 拼接而成的字符串不使用,号分隔,使用自定义的分隔符
mysql> select replace(group_concat(a),',','...') from t;
+------------------------------------+
| replace(group_concat(a),',','...') |
+------------------------------------+
| x...x...x...y...y...z...a...z |
+------------------------------------+
1 row in set (0.00 sec)
相关文章
- 【MySQL】常见的mysql 进程state
- 【MySql】mysql 慢日志查询工具之mysqldumpslow
- 基于Solr DIH实现MySQL表数据全量索引和增量索引
- 【异常】ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
- navcat导入mysql.sql出现:2006, 'MySQL server has gone away'
- MySQL ALTER语法的运用方法 && 操作索引和字段
- Java通过mysql-connector-java-8.0.11连接MySQL Server 8.0遇到的几个问题
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- connection to dat Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- Ruby on Rails 3 Can't connect to local MySQL server through socket '/tmp/mysql.sock' on linux
- 大叔经验分享(72)mysql时区
- MySQL · 答疑解惑 · MySQL 优化器 range 的代价计算
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
- MySQL中的char和varchar&mysql中varchar能存多少汉字、数字,以及varchar(100)和varchar(10)的区别
- MySQL数据库加密和解密~认证登陆密码(mysql.user)和MySQL不区分大小写
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'L
- mysql 查看 脏页_MySQL:刷脏页
- MySQL报错`ERROR: No query specified`
- Mysql报错:Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- MySQL下载安装 & 完美卸载
- MySQL数据库备份(INTO OUTFILE)
- [MySQL] 解决办法: Error: Transaction test error: file /etc/my.cnf from install of mysql-community-server