MySql SQL语句生产32位UUID

SQL语句生产32位UUID：

SELECT REPLACE(UUID(),'-','') AS id;

临时表的使用：

-- 删除临时表
DROP TABLE IF EXISTS cu_user_temp;
-- 创建临时表
CREATE TABLE cu_user_temp LIKE cu_user;
-- 赋值临时表
INSERT INTO cu_user_temp SELECT * FROM cu_user;

-- 插入数据
INSERT INTO cu_user_channel_log (id, userId) 
SELECT
	cu_user_temp.id,
	cu_user_temp.ringUserName
FROM
	cu_user_temp
LEFT JOIN cu_user ON cu_user_temp.id = cu_user.id;


-- 删除临时表
DROP TABLE IF EXISTS cu_user_temp;