INSERT INTO sys_user (username, password, nickname, email, phone, address, avatar_url)
SELECT
CONCAT(‘用户’, LPAD(id, 3, ‘0’)),
MD5(CONCAT(‘密码’, LPAD(id, 3, ‘0’))),
CONCAT(‘昵称’, LPAD(id, 3, ‘0’)),
CONCAT(‘用户’, LPAD(id, 3, ‘0’), ‘@example.com’),
CONCAT(‘123-’, LPAD(id, 3, ‘0’), ‘-’, LPAD(id, 3, ‘0’)),
CONCAT(‘地址’, LPAD(id, 3, ‘0’)),
CONCAT(‘https://example.com/avatar_’, LPAD(id, 3, ‘0’), ‘.jpg’)
FROM (
SELECT
(FLOOR(RAND() * 10000)) + 1 AS id
FROM
sys_user
GROUP BY
id
LIMIT
50
) AS t;