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

Editor to share with you what the sub-table in mysql refers to, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. The sub-table is to split a super-large data table into several smaller tables, which can be effectively alleviated.

2. Before the emergence of MySQL partitioning function, in order to solve the problem of super-large table, we can only use sub-table operation, partition is the database implementation version of sub-table.

The function of horizontal table can be replaced by more convenient partition, but the function of vertical table can not be replaced by partition.

Example

Mysql > create table tb_member1 like member;mysql > create table tb_member2 like member;mysql > create table tb_member (- > id bigint auto_increment primary key,-> name varchar (20),-> sex tinyint not null default'0'->) engine=merge union= (tb_member1,tb_member2) insert_method=last charset=utf8; is all the contents of this article "what does the sub-table in mysql refer to?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, 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.