mysql随机赋值

INSERT INTO users (id, username, age) VALUES (1, 'user1', FLOOR(RAND() * 100));

INSERT INTO users (id, username, password) VALUES (2, 'user2', CONCAT('password', FLOOR(RAND() * 1000)));

INSERT INTO users (id, username, birthdate) VALUES (3, 'user3', DATE_ADD('1990-01-01', INTERVAL FLOOR(RAND() * 365) DAY));

INSERT INTO users (id, username, age) VALUES (4, 'user4', FLOOR(SHA1(CONCAT('random', NOW()))) % 100);

CREATE TEMPORARY TABLE random_numbers (id INT PRIMARY KEY, value INT);
INSERT INTO random_numbers (id, value) VALUES (1, FLOOR(RAND() * 100)), (2, FLOOR(RAND() * 100)), ...;

INSERT INTO users (id, username, age) SELECT id, CONCAT('user', id), value FROM random_numbers;