/*创建原始数据表*/
DROP TABLE IF EXISTS `articleinfo`;
CREATE TABLE `articleinfo`(
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`title` VARCHAR(20) DEFAULT NULL,
`content` VARCHAR(20) DEFAULT NULL,
`comment_time` VARCHAR(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
/*创建存储过程来新增部分数据到原始数据表*/
delimiter $$
drop procedure if exists proc_articleinfo;
create procedure proc_articleinfo()
begin
declare i int;
set i=1;
while(i<=32) do
insert into articleinfo(title,content,comment_time)
values (concat(‘数据库基础‘,i),concat(‘努力学习基础知识‘,i%4),DATE_FORMAT(NOW(),‘%Y-%m-%d %H:%i:%S‘));
set i=i+1;
end while;
end;
$$
delimiter ;
/*调用存储过程*/
call proc_arti