在表中增加一些数据:
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('1','河南','安阳','-03-05 10:14:27');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('2','河南','郑州','-03-05 10:14:27');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('3','河南','洛阳','-03-05 10:14:27');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('4','河南','漯河','-03-05 10:14:27');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('5','河南','新乡','-03-05 10:14:27');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('6','河南','濮阳','-03-05 10:14:27');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('7','河南','焦作','-03-05 10:14:27');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('8','河南','鹤壁','-03-05 10:14:27');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('9','河南','开封','-03-05 10:14:27');
如果觉得《mysql数据库唯一性_mysql表的字段怎么设置唯一性》对你有帮助,请点赞、收藏,并留下你的观点哦!