MySQL Loop BULK INSERT test data

DELIMITER is actually defining a statement to execute the Terminator

Delimiter in MySQL:

Http://blog.sina.com.cn/s/blog_4c197d420101d3oa.html

1: Define Stored Procedure drop PROCEDURE test_insert;D elimiter $$//define Terminator Create PROCEDURE Test_insert () BEGIN DECLARE i INT DEFAULT 0     ;    START TRANSACTION;      While i<1000 does INSERT into T_user (column1,column2,column3) VALUES (Uuid_short (), I, ' test data ');     SET i=i+1;     END while; COMMIT;  END $ $DELIMITER; The Terminator is changed to; 2: Execute Stored procedure call Test_insert ();

This article is from the "Nothing-skywalker" blog, please be sure to keep this source http://tianxingzhe.blog.51cto.com/3390077/1676097

MySQL Loop BULK INSERT test data