# 新增表# MYISAM存储引擎不产生事物,插入速度极快createtableifnotexists big_data (
id intprimarykeynotnullauto_increment,
name varchar(20)notnull,
age int(11),
email varchar(64)defaultnull)engine=MYISAM defaultcharset=utf8;# 定义存储过程DELIMITER $$
CREATEPROCEDURE insert_data()BEGINDECLARE i INT;SET i =0;WHILE i >=0&& i <=1000000DOINSERTINTO big_data (name,age,email)VALUES(concat('test',i), rand()*50, concat('test', i,'@163.com'));SET i = i +1;ENDWHILE;END$$
DELIMITER;#执行存储过程call insert_data();# 插入100万条数据,用时:20.74 sec#删除存储过程dropPROCEDURE insert_data;# 修改数据表引擎altertable big_data engine=InnoDB;# 修改引擎,数据加锁,用时:4.41 sec