Navicat 导入Excel表格数据

1、建表

CREATE TABLE `t_dic_fatca_status` (
  `data_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '数据值',
  `value_zw` varchar(155) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '中文名称',
  `value_yw` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '英文名称',
  `sort` int DEFAULT NULL COMMENT '排序值'
  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

2、准备表格数据

3、

4、添加随机值

update t_dic_fatca_status set data_id = UUID()

5、设计数据表，重新设置data_id为主键