mysql 为什么主键删除,分区还在?
根据主键的asin 创建了分区, 然后删除了主键,分区没有删除,gpt是这样说的
https://poe.com/s/J3H4HssKOHmvJ0bIfS01
-- db_junglescout_amazon.tb_sales_estimates_weekly_v2 definition
CREATE TABLE `tb_sales_estimates_weekly_v2` (
`created_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modified_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`marketplace` varchar(5) NOT NULL,
`root_category_id` bigint NOT NULL,
`year` int NOT NULL,
`week` varchar(3) NOT NULL,
`start_date` date NOT NULL,
`end_date` date NOT NULL,
`asin` varchar(40) NOT NULL,
`is_available` int DEFAULT NULL,
`category_rank` bigint DEFAULT NULL,
`subcategory_rank` bigint DEFAULT NULL,
`brand` varchar(1000) DEFAULT NULL,
`name` varchar(1000) DEFAULT NULL,
`image_url` varchar(1000) DEFAULT NULL,
`price` decimal(10,2) DEFAULT NULL,
`review_count` bigint DEFAULT NULL,
`ratings` decimal(3,1) DEFAULT NULL,
`breadcrumb_path_category_ids` varchar(1000) DEFAULT NULL,
`ranking_category_ids` varchar(1000) DEFAULT NULL,
`first_date_available` datetime DEFAULT NULL,
`revenue` decimal(20,2) DEFAULT NULL,
`revenue_1p` decimal(20,2) DEFAULT NULL,
`revenue_3p` decimal(20,2) DEFAULT NULL,
`sales` decimal(20,2) DEFAULT NULL,
`sales_1p` decimal(20,2) DEFAULT NULL,
`sales_3p` decimal(20,2) DEFAULT NULL,
`seller_ids` varchar(1000) DEFAULT NULL,
`seller_id_mode` varchar(1000) DEFAULT NULL,
`seller_types` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY KEY (asin)
PARTITIONS 1024 */;