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

In MySQL, The While statement loop is different from that in SQL Server, and the code passes the test.

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

Sample Code:Copy codeThe Code is 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, 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:Copy codeThe Code is as follows: 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;