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

This article mainly introduces the relevant knowledge of what the concept of mysql level sub-table is, the content is detailed and easy to understand, the operation is simple and fast, and it has a certain reference value. I believe you will gain something after reading this mysql level sub-table concept. Let's take a look at it.

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 is the concept of mysql horizontal subtable" ends here, thank you for reading! I believe that everyone has a certain understanding of the knowledge of "what is the concept of mysql level subscale". If you want to learn more knowledge, 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.