菜单
  • 字节-豆包AI
  • 阿里-通义AI
  • 讯飞-星火AI
  • 百度-文心AI
  • GPT-代码AI
  • 写作助手
  • 论文助手

create table `py_plan_opportunity_point` ( `id` bigint not null auto_increment comment '主键id', `location_code` varchar(32) character set utf8mb4 collate utf8mb4_0900_ai_ci not null comment '规划点/机会点编码', `location_name` varchar(20) character set utf8mb4 collate utf8mb4_0900_ai_ci default null comment '规划点名称', `point_type` char(2) character set utf8mb4 collate utf8mb4_0900_ai_ci default null comment '点类型(1:规划点/2:机会点)', primary key (`id`), unique key `py_plan_opportunity_point_uniq` (`location_code`

It looks like you want to create a MySQL table named `py_plan_opportunity_point`. However, it seems like your query got cut off. Below is the corrected and completed SQL statement for creating this table: ```sql CREATE TABLE `py_plan_opportunity_point` ( `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键id', `location_code` VARCHAR(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '规划点/机会点编码', `location_name` VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '规划点名称', `point_type` CHAR(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '点类型(1:规划点/2:机会点)', PRIMARY KEY (`id`), UNIQUE KEY `py_plan_opportunity_point_uniq` (`location_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; ``` This table has the following fields: - `id`: A unique identifier for each record. - `location_code`: A unique code for each planning point or opportunity point. - `location_name`: The name of the planning point or opportunity point. - `point_type`: Indicates whether the point is a planning point (`1`) or an opportunity point (`2`). The table also includes a primary key on `id` and a unique constraint on `location_code` to ensure that each location code is unique within the table. [2024-09-04 16:09:36 | 阿里-通义千问 | 348字解答]

相关提问