Mycat+Mysql 插入数据报错 i[Err] 1064 - partition table, insert must provide ColumnList

逻辑库结构和物理库表结构如下(逻辑库结构=物理库表结构)：

CREATE TABLE `order_key` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`goods_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',`place` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下单地点',`make_date` date NULL DEFAULT NULL COMMENT '下单日期',`make_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下单时间',`modify_date` date NULL DEFAULT NULL COMMENT '修改日期',`modify_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改时间',`gender` int(1) NULL DEFAULT NULL COMMENT '性别',`status` int(1) NULL DEFAULT NULL COMMENT '上下架 0-上架 1-下架',`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名称',`user_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户电话',PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;

在mycat中插入数据如下：

INSERT INTO `order_key` VALUES (1, '苹果1', '上海1', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕1', '1'); INSERT INTO `order_key` VALUES (2, '苹果2', '上海2', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕2', '2'); INSERT INTO `order_key` VALUES (3, '苹果3', '上海3', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕3', '3'); INSERT INTO `order_key` VALUES (4, '苹果4', '上海4', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕4', '4'); INSERT INTO `order_key` VALUES (5, '苹果5', '上海5', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕5', '5'); INSERT INTO `order_key` VALUES (6, '苹果6', '上海6', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕6', '6'); INSERT INTO `order_key` VALUES (7, '苹果7', '上海7', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕7', '7'); INSERT INTO `order_key` VALUES (8, '苹果8', '上海8', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕8', '8'); INSERT INTO `order_key` VALUES (9, '苹果9', '上海9', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕9', '9'); INSERT INTO `order_key` VALUES (10, '苹果10', '上海10', '2019-08-25', '15:44:32', '2019-07-21', '15:44:32', 1, 0, '雨昕10', '10');

异常信息如下：

INSERT INTO `order_key` VALUES (10, '苹果10', '上海10', '2019-082-5', '15:44:32', '2019-07-21', '15:44:32', 1, 0, '雨昕10', '10'); ERROR 1064 (HY000): partition table, insert must provide ColumnList

解决方案：
插入数据是要指定列名
正确插入sql语句如下：

INSERT INTO `order_key` (`id`,goods_name,place,make_date,make_time,modify_date,modify_time,gender,status,user_name,user_phone) VALUES (1, '苹果1', '上海1', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕1', '1'); INSERT INTO `order_key` (`id`,goods_name,place,make_date,make_time,modify_date,modify_time,gender,status,user_name,user_phone) VALUES (2, '苹果2', '上海2', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕2', '2'); INSERT INTO `order_key` (`id`,goods_name,place,make_date,make_time,modify_date,modify_time,gender,status,user_name,user_phone) VALUES (3, '苹果3', '上海3', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕3', '3'); INSERT INTO `order_key` (`id`,goods_name,place,make_date,make_time,modify_date,modify_time,gender,status,user_name,user_phone) VALUES (4, '苹果4', '上海4', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕4', '4'); INSERT INTO `order_key` (`id`,goods_name,place,make_date,make_time,modify_date,modify_time,gender,status,user_name,user_phone) VALUES (5, '苹果5', '上海5', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕5', '5'); INSERT INTO `order_key` (`id`,goods_name,place,make_date,make_time,modify_date,modify_time,gender,status,user_name,user_phone) VALUES (6, '苹果6', '上海6', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕6', '6'); INSERT INTO `order_key` (`id`,goods_name,place,make_date,make_time,modify_date,modify_time,gender,status,user_name,user_phone) VALUES (7, '苹果7', '上海7', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕7', '7'); INSERT INTO `order_key` (`id`,goods_name,place,make_date,make_time,modify_date,modify_time,gender,status,user_name,user_phone) VALUES (8, '苹果8', '上海8', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕8', '8'); INSERT INTO `order_key` (`id`,goods_name,place,make_date,make_time,modify_date,modify_time,gender,status,user_name,user_phone) VALUES (9, '苹果9', '上海9', '2019-08-25', '15:44:32', '2019-08-25', '15:44:32', 1, 0, '雨昕9', '9'); INSERT INTO `order_key` (`id`,goods_name,place,make_date,make_time,modify_date,modify_time,gender,status,user_name,user_phone) VALUES (10, '苹果10', '上海10', '2019-08-25', '15:44:32', '2019-07-21', '15:44:32', 1, 0, '雨昕10', '10');

截图附上：

总结

以上是生活随笔为你收集整理的Mycat+Mysql 插入数据报错 i[Err] 1064 - partition table, insert must provide ColumnList的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。