MySQL数据库唯一索引

最新推荐文章于 2025-04-25 09:34:49 发布

martin_violet

最新推荐文章于 2025-04-25 09:34:49 发布

阅读量514

点赞数

文章标签： mysql

本文链接：https://blog.youkuaiyun.com/martin_violet/article/details/122865276

版权

DROP TABLE IF EXISTS `pms_watchword_temp`;
CREATE TABLE `pms_watchword_temp`
(
    `id`                 bigint(20)                                                   NOT NULL AUTO_INCREMENT COMMENT 'id',
    `lottery_session_id` bigint(20)                                                   NULL DEFAULT NULL COMMENT '抽奖场次id',
    `watchword_key`      varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '口令值',
    `status`             tinyint(1)                                                   NULL DEFAULT 0 COMMENT '状态（0未使用 1已使用）',
    `gmt_create`         datetime(0)                                                  NULL DEFAULT NULL COMMENT '创建时间',
    `gmt_modified`       datetime(0)                                                  NULL DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX uniq_lottery_session_id_watchword_key (lottery_session_id, watchword_key)

) ENGINE = InnoDB
  AUTO_INCREMENT = 11
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT = '抽奖口令信息表'
  ROW_FORMAT = Dynamic;


show index from pms_watchword_temp;

insert into pms_watchword_temp (lottery_session_id, watchword_key) value (1, '1234');

select * from pms_watchword_temp;