mysql 存储过程的定义和使用

1）创建存储过程；并循环插入数据

create PROCEDURE sp_name()
BEGIN
    DECLARE i int;
    set i=0;
    while  i<50000 DO
        insert into t_topic(title,content,user_id,count_view) VALUES('PHP','php infomation',1,20);
        SET i=i+1;
    end while;
END

 

转载于:https://www.cnblogs.com/wanglijun/p/8920209.html