Mysql 批量插入数据存储过程

Mysql的批量插入数据脚本

# 批量插入数据
DROP PROCEDURE procedure_insert_auto;
CREATE PROCEDURE
    procedure_insert_auto()
BEGIN
    DECLARE count integer DEFAULT 10000; /*插入一万条*/

    WHILE count > 0 DO
    INSERT INTO table_1 (col_1, col_2, col_3, col_4)
    VALUES (concat('id-', count), 0, '5', CURDATE());
    SET count = count - 1;

    # 可以设置提交事物的条件

    END WHILE;
    COMMIT;
END;