MySql 添加联合约束

ALTER TABLE db_m_watchitem ADD UNIQUE KEY(number, watchTime);

[SQL]INSERT INTO `weatherservice`.`db_m_watchitem` (`bDelete`, `bForbidden`, `createTime`, `name`, `number`, `statue`, `watchTime`, `watchTimeStr`) VALUES ( ‘0’, ‘0’, ‘2017-07-04 14:22:21’, ‘金湖’, ‘58147’, ‘1’, ‘2017-07-04 00:05:00’, ‘2017-07-04 00:05:00’);
[Err] 1062 – Duplicate entry ‘58147-2017-07-04 00:05:00’ for key ‘number’