数据库明明没这数据 批量插入时候提示主键唯一存在我也很萌了 应该是生成语句有问题? 返回

求助
360
该叫什么 John 发布于2019/7/7
悬赏:5 飞吻

数据库明明没这数据 批量插入时候提示主键唯一存在我也很萌了 应该是生成语句有问题?

据库的唯 一约束错误

https://github.com/sunkaixuan/SqlSugar/issues/446 

这里反馈过一个问题 一样我也很纳闷.

唯一键约束有问题.png



INSERT INTO `T_urls_guid`  (`guid`,`url`,`Host`,`status`,`count`,`weight`)

 SELECT '76b071f7d96115137e49a1418de04b8c' AS `guid`,'https://news.163.com/19/0706/17/EJDUVOH80001875N.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'a373aba425eb2c4b9b601a0b17ab670b' AS `guid`,'https://news.163.com/19/0705/23/EJBVVE7I0001899O.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'f4a7f3baf9a0cd2adb7103bf283f8b61' AS `guid`,'https://news.163.com/19/0706/10/EJD78CDM0001875O.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'e9a3c14045308a042b16d544f83f0e14' AS `guid`,'https://news.163.com/19/0706/17/EJDVME5M0001875P.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '01bfa1148012f701561d0eefb65b43e3' AS `guid`,'https://news.163.com/19/0706/15/EJDOKN5E0001875P.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '3a7131dd85120b650a870e314b451f02' AS `guid`,'https://news.163.com/19/0706/12/EJDCECQ30001875P.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'efc7fd2f7a6063332cad3ede430de815' AS `guid`,'https://news.163.com/19/0706/19/EJE3IVFH0001875N.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'a10cdaa9a9a055645804f74d47e47c63' AS `guid`,'https://news.163.com/19/0706/12/EJDDH7IO0001899O.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'e6288fc9472bb73864a946efa0b7ef8b' AS `guid`,'https://news.163.com/19/0706/22/EJEH1BA00001875P.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '767f4b4bc4e3b37741ff06700b9870df' AS `guid`,'https://news.163.com/19/0706/16/EJDQDU3J0001875P.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '2a4ce7b41902d8e6333dfe6e1c835c6e' AS `guid`,'https://news.163.com/19/0706/19/EJE3OO8C0001899O.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '8b95bc359706584cadaebba19fcd76a5' AS `guid`,'https://news.163.com/19/0706/13/EJDGDFGG0001875P.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'c608313d880dd3d84613ae14972a67a2' AS `guid`,'https://news.163.com/19/0706/17/EJDUMETJ0001875P.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '1550c5288a4f4c45b15628a4abdec47f' AS `guid`,'https://news.163.com/19/0706/21/EJECVPKM0001875P.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '8cf5027851791c95db67628a41df5bef' AS `guid`,'https://news.163.com/19/0706/19/EJE5MH5P0001899O.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'a373aba425eb2c4b9b601a0b17ab670b' AS `guid`,'https://news.163.com/19/0705/23/EJBVVE7I0001899O.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'd912880dca6fb994277eaca392a99607' AS `guid`,'https://home.163.com/19/0706/07/EJCQN8T200108GL2.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '8d0ebe43ce86aa619cf2eb4046f98c75' AS `guid`,'https://sports.163.com/19/0706/07/EJCSNN590005877V.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'bee0fbb7704d68c47f3d61ab45072584' AS `guid`,'https://home.163.com/19/0706/07/EJCQNCMJ00108GL2.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '3fa89b093efa1c5c206340eb98591461' AS `guid`,'https://news.163.com/19/0706/14/EJDL1N3E0001899O.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'adcd1a205bb8ef97e627c6f402af760b' AS `guid`,'https://news.163.com/19/0706/16/EJDQ5SLD0001875P.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '08e7abdd1a1fd4c24bd1db1065cf50d7' AS `guid`,'https://news.163.com/19/0706/14/EJDLHEFG0001875P.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'efc7fd2f7a6063332cad3ede430de815' AS `guid`,'https://news.163.com/19/0706/19/EJE3IVFH0001875N.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'ab59954051d1197eace2d6a518c99c19' AS `guid`,'https://travel.163.com/19/0706/00/EJC2F9CG00068AIR.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'dd23f154e59771d867818321bb1a66a6' AS `guid`,'https://mobile.163.com/19/0706/08/EJD0MNP900119821.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'd8d9bbfce7fcb94633ed726aab61813c' AS `guid`,'https://tech.163.com/19/0706/09/EJD1559B00097U7R.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '0d013ba298313812aca1935a7946a407' AS `guid`,'https://news.163.com/19/0706/06/EJCOI2BP0001899O.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'f6e49c2cd4805294d53be09696cc4e23' AS `guid`,'https://lady.163.com/19/0706/10/EJD749AA00267VQQ.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT '2d993e576b19d03ba4f9f48b6a347536' AS `guid`,'https://ent.163.com/19/0706/14/EJDJSQCQ00038FO9.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'ce607bc3071952f7a117f21ba36ff7e1' AS `guid`,'https://sports.163.com/19/0706/20/EJE7NTCD0005877U.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'd8d9bbfce7fcb94633ed726aab61813c' AS `guid`,'https://tech.163.com/19/0706/09/EJD1559B00097U7R.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'ad4d7636a36d1cfeebea3c4b97fbce53' AS `guid`,'https://money.163.com/19/0706/15/EJDNK4JN00259DLP.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

UNION ALL 

 SELECT 'be79c9452db829133e454f67c5688fed' AS `guid`,'http://renjian.163.com/19/0705/13/EJATR24C000181RV.html' AS `url`,NULL AS `Host`,'0' AS `status`,'0' AS `count`,'0' AS `weight`

;




热忱回答0

版块

学习文档

最新会员

发布达人

回贴达人