20230920数据库插入数据

-- 创建测试表 CREATE TABLE test ( id INT PRIMARY KEY, name VARCHAR(50), age INT, address VARCHAR(100) ); -- 插入 10 万条数据 DELIMITER $DECLARE i INT DEFAULT 1; WHILE i <= 100000 DO INSERT INTO test (id, name, age, address) VALUES (i, CONCAT('name', i), FLOOR(RAND() * 100), CONCAT('address', i)); SET i = i + 1; END WHILE;$ DELIMITER ;