創(chuàng)建測試表
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`age` int(10) DEFAULT NULL,
`ctime` datetime DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
`utime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COMMENT='用戶測試表';
插入方法
DROP PROCEDURE if exists test_insert ;
DELIMITER ;;
CREATE PROCEDURE test_insert ()
BEGIN
DECLARE i INT DEFAULT 1;# can not be 0
-- 插入條數(shù)
WHILE i<100
DO
-- 插入語句
INSERT INTO user(id, name, age, ctime, utime) VALUES (i, CONCAT("姓名",i), 32, now(), null);
SET i=i+1;
END WHILE ;
commit;
END;;
CALL test_insert();
