What is the concept of mysql horizontal subtable

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.