备份数据 和 使用存储过程正确 造30万条数据后 ，批量修改字段数据

导出备份
#mysqldump --skip-lock-tables -ucloud -p cloud t_user_vital > /tmp/t_user_vital.sql

导入还原
#mysqldump --skip-lock-tables -ucloud -p cloud t_user_vital < /tmp/t_user_vital.sql

条件1. 在这里造正常的 造出了 21万条数据

条件2. 唯一索引字段可使用随机数 RAND()*100000000000000+RAND(i)+RAND(i)

条件3.出现 Duplicate entry ‘70964913322558.14’ for key ‘username’ 适当修改 条件2

删除存储过程

DROP PROCEDURE IF EXISTS insert_customer000;

CREATE PROCEDURE insert_customer000()
BEGIN
DECLARE i int(126);
SET i = 1;
WHILE i <= 210000 DO

INSERT INTO t_user_vital_copy (
username,
password,
user_type,
group_id,
email,
phone_number,
register_source,
ctime,
mtime,
user_status,
enable_flag,
logout_number
) VALUES (RAND()*10000000000+RAND(i)+RAND(i), ‘6b21c28e72d4399c5bfebc5ba0f539b1’, ‘0’, ‘0’, 0, null, ‘0’, ‘2020-10-21 14:06:46’, ‘2021-01-18 14:56:33’, ‘0’, ‘1’, ‘0’);

SET i = i + 1;
END WHILE;
END

CALL insert_customer000;

select * from t_user_vital_copy

批量修改数据 库语句

#update t_user_vital_copy set