mysql联合唯一_MYSQl 联合唯一约束 根据两个字段 唯一

CREATE TABLE tb_month_report_chapter_main(

`id` INTEGER(11) NOT NULL AUTO_INCREMENT,

`record_month` char(7) NOT NULL ,

`customer_id` int(11) NOT NULL,

PRIMARY KEY(`id`),

UNIQUE KEY `record_month` (`record_month`, `customer_id`) #创建了联合唯一约束 当月份和用户id有重复时会报错

);

CREATE TABLE tb_month_report_chapter_main(

`id` INTEGER(11) NOT NULL AUTO_INCREMENT,

`record_month` char(7) NOT NULL ,

`customer_id` int(11) NOT NULL,

PRIMARY KEY(`id`),

UNIQUE KEY `record_month` (`record_month`, `customer_id`)

);

CREATE TABLE tb_month_report_chapter_text(

`id` INTEGER(11) AUT