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

This article will explain in detail what the mysql level subtable refers to. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

1. The horizontal table is divided into row records.

2. It can be divided according to the range of a field, such as the order number field, a table from 0 to 10000 and a table from 10001 to 20000.

3. It can be divided according to the HASH of a field, and it can also be divided according to time.

Example

CREATE TABLE `msg_ 2` (`id` int (11) NOT NULL AUTO_INCREMENT, `uid` int (11) NOT NULL, `content` varchar (50) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 's article on "what the mysql level subtable refers to" ends here. I hope the above content will be helpful to you so that you can learn more knowledge. If you think the article is good, please share it for more people to read.

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.