mysql-replace(uuid(), ‘-‘, ‘‘)批量插入

 select @@version;
 
 ------------------------------
 @@version
 5.7.35-log
 
mysql在某客户端，某次执行了如下sql

select replace(uuid(), '-', '') as id, u.user_id from t_user u;

------------------------------
# replace(uuid(), '-', '')    user_id
a6d41686fb6e11ed88490cc47ac164c8    1658680608840843264
a6d41686fb6e11ed88490cc47ac164c8    1658680977654382592

结果发现，生成的uuid重复了，

经过排查，发现是客户端连接是有默认“init-connect='SET NAMES utf8mb4'”导致“character_set_connection=utf8mb4”的问题，需要做如下调整:
命令
SET NAMES 'charset_name' [COLLATE 'collation_name']
相当于
SET character_set_client = charset_name;
SET character_set_results = charset_name;
SET character_set_connection = charset_name;

character_set_client 是指客户端发送过来的语句的编码;
character_set_connection 是指mysqld收到客户端的