这个文件在什么位置？
同时 ，这个问题都发生在分区表上
以下为mysql语法
– zh_shenbao.t_sb_bsdt_zdylj definition
CREATE TABLE t_sb_bsdt_zdylj (
id varchar(60) NOT NULL
user_id varchar(60) NOT NULL COMMENT ‘用户id’,
bsdt_id varchar(60) NOT NULL COMMENT ‘地图菜单id’,
parent_id varchar(60) DEFAULT NULL COMMENT ‘父级菜单id’,
level int(2) NOT NULL COMMENT ‘菜单层级’,
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘更新时间’,
del_flag varchar(10) NOT NULL DEFAULT ‘enable’ COMMENT ‘是否删除 enable-未删除；disable-删除’,
PRIMARY KEY (id,user_id) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT=‘申报-地图自定义链接’
/*!50100 PARTITION BY KEY (user_id)
(PARTITION p0 ENGINE = InnoDB,
PARTITION p1 ENGINE = InnoDB,
PARTITION p2 ENGINE = InnoDB,
PARTITION p3 ENGINE = InnoDB,
PARTITION p4 ENGINE = InnoDB,
PARTITION p5 ENGINE = InnoDB,
PARTITION p6 ENGINE = InnoDB) */;
以下为tidb自动创建语法
CREATE TABLE t_sb_bsdt_zdylj (
id varchar(60) NOT NULL COMMENT ‘地图菜单自定义链接id’,
user_id varchar(60) NOT NULL COMMENT ‘用户id’,
bsdt_id varchar(60) NOT NULL COMMENT ‘地图菜单id’,
parent_id varchar(60) DEFAULT NULL COMMENT ‘父级菜单id’,
level int(2) NOT NULL COMMENT ‘菜单层级’,
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘更新时间’,
del_flag varchar(10) NOT NULL DEFAULT ‘enable’ COMMENT ‘是否删除 enable-未删除；disable-删除’,
PRIMARY KEY (id,user_id) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘申报-地图自定义链接’
PARTITION BY KEY (user_id) PARTITIONS 7;
PARTITION p6 ENGINE = InnoDB) */;