开始的时候表是这样
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| id | varchar(255) | NO | PRI | NULL | |
| contacter | varchar(255) | YES | | NULL | |
| mobilePhone | varchar(255) | YES | UNI | NULL | |
| idCard | varchar(255) | YES | | NULL | |
| contacterTitle | varchar(255) | YES | | NULL | |
| state | bit(1) | YES | | NULL | |
| password | varchar(255) | YES | | NULL | |
| taxCompany | varchar(50) | YES | MUL | NULL | |
| createTime | datetime | YES | | NULL | |
| beginServiceTime | datetime | YES | | NULL | |
| endServiceTime | datetime | YES | | NULL | |
+------------------+--------------+------+-----+---------+-------+
然后查看表的create语句
show create table t_taxpayer;
| t_taxpayer | CREATE TABLE `t_taxpayer`
`id` varchar(255) NOT NULL,
`contacter` varchar(255) DEFAULT NULL,
`mobilePhone` varchar(255) DEFAULT NULL
`idCard` varchar(255) DEFAULT NULL,
`contacterTitle` varchar(255) DEFAULT N
`state` bit(1) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`taxCompany` varchar(50) DEFAULT NULL,
`createTime` datetime DEFAULT NULL,
`beginServiceTime` datetime DEFAULT NUL
`endServiceTime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `mobilePhone` (`mobilePhone`
KEY `FKA70EF9F59B145028` (`taxCompany`)
CONSTRAINT `FKA70EF9F59B145028` FOREIGN
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
发现了 UNIQUE KEY 'mobilePhone' 这个约束索引.
然后删除他.
alter table t_taxpayer drop index mobilePhone;
好啦 在看表结构
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| id | varchar(255) | NO | PRI | NULL | |
| contacter | varchar(255) | YES | | NULL | |
| mobilePhone | varchar(255) | YES | | NULL | |
| idCard | varchar(255) | YES | | NULL | |
| contacterTitle | varchar(255) | YES | | NULL | |
| state | bit(1) | YES | | NULL | |
| password | varchar(255) | YES | | NULL | |
| taxCompany | varchar(50) | YES | MUL | NULL | |
| createTime | datetime | YES | | NULL | |
| beginServiceTime | datetime | YES | | NULL | |
| endServiceTime | datetime | YES | | NULL | |
+------------------+--------------+------+-----+---------+-------+
唯一性检查不见了