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

How does mysql merge two tables? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Mysql merges two tables: first make sure that the fields of the two tables must be the same and the book order is the same; then write SQL directly and connect it with UNION ALL.

How mysql merges two tables:

1. Before merging the result set, there is a condition that the fields of the two tables must be the same and the book order must be the same.

As shown in the figure: the first table: zp_201707

2. The second table: zp_201708. The fields and order of the two tables are the same

3. We can write SQL directly and connect it with UNION ALL, and the result will come out!

4. It's the same for us to add conditional queries. It's very simple.

Thank you for reading! After reading the above, do you have a general understanding of how mysql merges the two tables? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.