数据库行政区划SQL脚本文件,适用于MySQL导入
-- 删除表格如果存在 dict_division
; CREATE TABLE dict_division
( code
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 不为空, name
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 默认空, 主键 (code
) 采用 BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; ------- dict_division 表中的记录 ------- 插入
用户评论