Shulou(Shulou.com)06/01 Report--

Do the project encountered the need to insert orderly test data, do not want to write php cycle, online to find a way to review the stored procedure .

SQL statements are referenced from https://stackoverflow.com/questions/26981901/mysql-insert-with-while-loop

Delimiter $$

CREATE PROCEDURE myproc ()

BEGIN

DECLARE i int DEFAULT 9

WHILE i

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.