插入数据
CREATE DEFINER=`root`@`localhost` PROCEDURE `insert`()
BEGIN
#Routine body goes here...
DECLARE i int DEFAULT 1;
WHILE i<100000 DO
INSERT INTO `big`(num,`name`,`code`) VALUE(i,'big',i);
set i=i+1;
END WHILE;
END
插入数据
CREATE DEFINER=`root`@`localhost` PROCEDURE `insert`()
BEGIN
#Routine body goes here...
DECLARE i int DEFAULT 1;
WHILE i<100000 DO
INSERT INTO `big`(num,`name`,`code`) VALUE(i,'big',i);
set i=i+1;
END WHILE;
END