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

This article mainly tells you about the simple method of merging two tables in mysql. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on the simple method of merging two tables in mysql can bring you some practical help.

Mysqldump-d: only export table structure, without data export complete database data does not include table structure

Mysqldump-t: only export data, no table structure

Solution:

Mysqldump-t only exports table data in the original database

And then import it into the database to be merged.

Note: if you do not add-t, both the table structure and the table data will be derived, so that when merging the table, because there is a table structure, he will delete the original table structure and data, and then import the new data, so that there will be no original data.

This is the simple way to merge two tables in mysql. If you want to know about other related issues, you can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.