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

This article shows you how to achieve horizontal and vertical tables in Mysql. The content is concise and easy to understand. It will definitely make you shine. I hope you can gain something through the detailed introduction of this article.

Horizontal sub-table:

As shown in the above figure: The other three tables have the same table structure, but the data is stored in these three tables separately. If you want to insert or query, you need to take the remainder of the id and then splice the table name, so it is a complete table_name.

But what if I need to tabulate name or email?

Then you need to use MD5 encryption because MD5 encryption is 16-ary then you can carry out the remainder, the same idea.

Vertical sub-table:

Why do we need vertical tables?

Because if there is a large field in a table and it is not necessary to display or is not currently needed, although there is no deliberate query, the large field will be found together when querying according to id or other indexes, which will seriously affect the query performance. Therefore, there is a vertical table.

For details, please see the following picture:

The above content is how to achieve horizontal and vertical tables in Mysql. Have you learned knowledge or skills? If you want to learn more skills or enrich your knowledge reserves, please pay attention to 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.