MySQL and MSSQl use the While statement to generate test data cyclically _ MySQL

In MySQL, the code bitsCN.com that uses the While statement to generate test data cyclically is different from that in SQL Server. the code passes the test.

In MSSQL, the while statement is used to generate data cyclically:

Sample code:

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, the while loop is used to process data: you need to create a stored procedure and directly call and execute the stored procedure.

Sample code:

Create definer = 'root' @ 'localhost' PROCEDURE 'newprocedure '()
BEGIN
DECLARE I INT;
SET I = 1;
WHILE I & lt; 100 DO
Insert into demotable (id, item1, item2) VALUES (I, "Test Question", "0 ");
SET I = I + 1;
End while;
END;
BitsCN.com