mysql批量插入操作
DROP FUNCTION IF EXISTS mock_data;
DELIMITER $$
CREATE FUNCTION mock_data()
RETURNS INT
BEGIN
DECLARE num INT DEFAULT 20;
DECLARE i INT DEFAULT 11;
WHILE i <= num DO
INSERT INTO student(`name`, `sex`, `age`)
VALUES(CONCAT('trsss',i), 1,11);
SET i = i + 1;
END WHILE;
RETURN i;
END;
SELECT mock_data();