mysql存储过程插入40W条数据

创建表

use test;
drop table if exists enterprise;
create table enterprise(
    id bigint(20) not null AUTO_INCREMENT,
    name varchar(36),
        status TINYINT DEFAULT '1',
    primary key (id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT; 
drop