Shulou(Shulou.com)06/03 Report--

This article mainly explains "how to migrate part of the data from the t_lives table to other databases". The explanation in the article is simple and clear and easy to learn and understand. please follow the editor's ideas to study and learn "how to migrate part of the data from the t_lives table to other databases".

A project user requires that the data in the t_lives table need to be migrated to other databases, but do not want to migrate all databases. To ensure that the data content is error-free and can be used properly, the basic steps are as follows:

1. First of all, download all the "Id" data you need in the linux server, and find it accurately as shown below:

two。 Transfer the resulting Id.txt files to the Windows desktop and replace the previously unneeded "Id" with an empty one.

3. After the replacement is completed, the database will be run in the database software Navicat.exe.

4. Then click "query" in the left sidebar to create a new query project, and enter the database command as follows:

5. After running the query, you will get the following results:

6. Copy this data into an insert statement, and then go to the migrated database to run the replicated insert statement:

7. After the operation is completed, the LVB list in database No. 1 will be migrated directly to the new database without losing other data, and the migration to this data list will be completed.

Thank you for your reading, the above is the content of "how to migrate part of the data from the t_lives table to other databases". After the study of this article, I believe you have a deeper understanding of how to migrate part of the data from the t_lives table to other databases. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.