Mysql官网

https://dev.mysql.com/downloads/mysql/

mysql集群安装

[root@localhost ~]# docker search mysql
//指定版本
[root@localhost ~]# docker pull mysql:8.0.23
[root@localhost ~]# docker images

可以保存镜像jar方便使用

[root@localhost ~]# docker save mysql -o mysql.8.0.23.tar

//使用方式
[root@localhost ~]# docker load -i mysql.8.0.23.tar

创建网段

[root@localhost ~]# docker network create --subnet=172.18.0.0/18 mynet
[root@localhost ~]# docker run -it -d --name mysql_1 -p 12001:3306 \
--net mynet --ip 172.18.0.2 \
-m 400m -v /root/mysql_1/data:/var/lib/mysql \
-v /root/mysql_1/config:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD=abc123456 \
-e TZ=Asia/Shanghai --privileged=true mysql:8.0.23 \
--lower_case_table_names=1

语法

替换字段内容

-- 替换 
UPDATE bt_rwd SET gcnr = REPLACE(gcnr, ' ', '');
-- 替换空格
UPDATE bt_rwd SET gcnr=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(gcnr,CHAR(9),''),CHAR(10),''),CHAR(13),''),' ',''),'\r\n','');
-- 替换
UPDATE bt_rwd SET gcnr = REPLACE(gcnr, '<p>', '');
UPDATE bt_rwd SET gcnr = REPLACE(gcnr, '</p>', '');
UPDATE bt_rwd SET gcnr = REPLACE(gcnr, '<br>', '');
UPDATE bt_rwd SET gcnr = REPLACE(gcnr, '</div>', '');
UPDATE bt_rwd SET gcnr = REPLACE(gcnr, '<div>', '');

按照列表统计

SELECT   
    s.bmid,  
    d.name AS bmmc,  
    COUNT(CASE WHEN YEAR(s.cjsj) = '2024' THEN 1 END) AS "2024",  
    COUNT(CASE WHEN YEAR(s.cjsj) = '2025' THEN 1 END) AS "2025"  
FROM BT_SPJL s  
JOIN ST_DEPT d ON s.bmid = d.id  
WHERE s.ssmk = 'gwgl001'   
  AND s.sphj = 'cbfzrls'   
  AND s.yxzt = '1'  
GROUP BY s.bmid, d.name;

查询索引

SHOW INDEX FROM bt_sggl_gcjc;

创建用户

-- 创建用户（假设用户名为 'vspn70_rel'，密码为 'password'）
CREATE USER 'vspn70_rel'@'%' IDENTIFIED BY 'password';
-- 赋予该用户对 vspn70_rel 数据库的所有权限
GRANT ALL PRIVILEGES ON vspn70_rel.* TO 'vspn70_rel'@'%';
-- 刷新权限
FLUSH PRIVILEGES;

安装 Mysql 8

mkdir -p /data/mysql/data /data/mysql/conf

docker run -d --name pigx-mysql \
  -p 3306:3306 \
  -e MYSQL_ROOT_HOST="%" \
  -e MYSQL_ROOT_PASSWORD=root \
  --restart unless-stopped \
  -v /data/mysql/data:/var/lib/mysql \
  -v /data/mysql/conf:/etc/mysql/conf.d \
  registry.cn-hangzhou.aliyuncs.com/dockerhub_mirror/mysql-server:8.4.4 \
  --lower_case_table_names=1

备份表

CREATE TABLE bt_rwd_20250414 AS SELECT * FROM bt_rwd;