Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what is the concept of mysql worm replication". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Description

1. Worm replication inserts replicated data from an existing table directly into another table (the same table)

2. the goal of worm replication is to rapidly increase the data in the table, to replicate the data in the table (for data backup or migration), and to increase exponentially (mostly for testing).

Example

Create table tweets 1 (id int primary key auto_increment, stu_name varchar (20) not null, course varchar (20) not null, score decimal (5 Magazine 2)) charset utf8; insert into tweets 2 select * from tweets 1; "what is the concept of mysql worm replication" ends here, thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.