# replace 更新表字段
update `table_name` set `name` = replace (`name`,'年','-') where `id` > 0;

# 获取表的索引信息
show indexes from table_name;

# 登录数据库
mysql -uroot -p -P3306 -h127.0.0.1

# 创建数据库
create database `spring-boot-demo` character set 'utf8mb4' collate 'utf8mb4_general_ci';

# 创建用户
create user 'temp_user_01'@'%' identified by 'password';

# 修改用户密码
alter user 'root'@'%' identified by '123456';

# 授权用户
# db_01.* 是指可以访问db_01数据库下的所有表
# 'temp_user_01'@'%' %表示所有的ip
grant all privileges on db_01.* to 'temp_user_01'@'%' identified by 'password';

# 刷新权限
flush privileges;

# 导出数据
/usr/local/bin/mysqldump -h 10.10.8.204 -P 3307 -u root -ppwd dbname > /opt/backup/dbname.sql
docker exec -it mysql mysqldump -t -uroot -ppwd -P3306 dbname> /home/nvidia/dbname.sql

Q.E.D.