How to use worm replication in Mysql data table

To put it simply, MySQL worm replication is to continuously insert the queried data into the specified data table. Normally, the MySQL worm is used to test table pressure when replicating.

Next, we will introduce the use of worm replication in MySQL data tables with a simple example.

First, we can query the information fields in the existing money table. The table information is as shown in the figure below.

The basic syntax of worm replication is:

insert into + data table name + field list/* + from data table name;

Example usage statement:

insert into money select null,name,money from money;

Then we use the command statement of the worm to copy the data in the money table. The specific operation is shown in the figure below.

Here we can see that the data grows in the order of 2, 4, 8, 16, 32..., which is the exponential increase we are familiar with. If you continue to operate, the data in the table can be expanded to a certain order of magnitude in a short period of time, thereby achieving the purpose of testing the table pressure.

The above is the method of using worm replication in MySQL data table. Thank you for your support to 123WORDPRESS.COM.