Mysql and MSSQL code to generate test data using the while statement _mysql

In MySQL, the code test passes with a while statement loop that differs from SQL Server.

Method of using the while statement to generate data in MSSQL:

Sample code:

Copy Code code as follows:

DECLARE @a int
Set @a = 1
While @a<25
Begin
INSERT into Demotable (id,item1,item2) VALUES (@a, "abc", "123")
Set @a = @a + 1
End

In MySQL, use a while loop to process data methods: You need to create a new stored procedure to call the Execute stored procedure directly.

Sample code:

Copy Code code as follows:

CREATE definer= ' root ' @ ' localhost ' PROCEDURE ' newprocedure ' ()
BEGIN
DECLARE i INT;
SET I=1;
While i<100 do
INSERT into Demotable (id,item1,item2) VALUES (i, "Test questions", "0");
SET i = i + 1;
End while;
End;