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

Scene

Due to the security requirements of MySQL, a Table has no partition for value error occurred when inserting data after a version upgrade.

Existing versions of 5.7.20-log are upgraded to 5.7.26-log

Description

During the table building process, specify the time identify_date (datetime type) as the primary key

Solution

ALTER TABLE `cs_oth_face_ capture` PARTITION BY RANGE (to_days (identify_date))

(

PARTITION p_Dec VALUES LESS THAN MAXVALUE

);

Partitioning is for better query. Of course, when you create a table, you don't have to specify a partition.

Quote

Https://blog.csdn.net/qq_35946990/article/details/75041672

Https://www.cnblogs.com/chenmh/p/5627912.html

Https://www.cnblogs.com/zmxmumu/p/4450857.html

Https://blog.csdn.net/qq_35946990/article/details/75041672

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.