在表中增加一些數據：

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('1','河南','安陽','2019-03-05 10:14:27');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('2','河南','鄭州','2019-03-05 10:14:27');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('3','河南','洛陽','2019-03-05 10:14:27');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('4','河南','漯河','2019-03-05 10:14:27');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('5','河南','新鄉','2019-03-05 10:14:27');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('6','河南','濮陽','2019-03-05 10:14:27');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('7','河南','焦作','2019-03-05 10:14:27');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('8','河南','鶴壁','2019-03-05 10:14:27');

insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`) values('9','河南','開封','2019-03-05 10:14:27');

總結

以上是生活随笔為你收集整理的mysql数据库唯一性_mysql表的字段怎么设置唯一性的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。