MySQL one-time insertion of tens of thousands of data testing dedicated

During the boring period, MySQL can be used when you insert tens of thousands of data tests at once.

First create a table T3

CREATE table t3 (id int) ENGINE = MyISAM;

\d//The end sign of MySQL is changed to//by default the end sign of MySQL is;

This creates a procedure method that ends with the last End//

finally with \d; Bar MySQL native end symbol; I'm not going to put it back here.

Use the command call P3; (Call P3 to move brick:-))

Finally look at the number of T3;

MySQL one-time insertion of tens of thousands of data testing dedicated