<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Luca_s的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Luca_s</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Luca_s]]></copyright><item><title><![CDATA[pg数据库批量插入]]></title><link>https://blog.youkuaiyun.com/Luca_s/article/details/125292287</link><guid>https://blog.youkuaiyun.com/Luca_s/article/details/125292287</guid><author>Luca_s</author><pubDate>Wed, 15 Jun 2022 10:32:20 +0800</pubDate><description><![CDATA[目标：插入10w个手机号，每个企业下不能有重复的手机号解决方法1：先把10w拆分为3000为一组，然后循环遍历，去数据库里面查出是否有相同数据解决方法2：sql语句 where not exist， 存在问题，只能一行一行的插入，效率极差解决方法3： on conflict (字段) do nothing ， 可是只能 用于 一个字段的唯一性校验，还是选择第一个...]]></description><category></category></item><item><title><![CDATA[Pgsql数据库导入csv文件出现中文乱码]]></title><link>https://blog.youkuaiyun.com/Luca_s/article/details/122575595</link><guid>https://blog.youkuaiyun.com/Luca_s/article/details/122575595</guid><author>Luca_s</author><pubDate>Wed, 19 Jan 2022 10:38:09 +0800</pubDate><description><![CDATA[Pgsql导入]]></description><category></category></item><item><title><![CDATA[pgSql 不良的类型值 ：int]]></title><link>https://blog.youkuaiyun.com/Luca_s/article/details/122556830</link><guid>https://blog.youkuaiyun.com/Luca_s/article/details/122556830</guid><author>Luca_s</author><pubDate>Tue, 18 Jan 2022 11:47:48 +0800</pubDate><description><![CDATA[本来岁月静好，直到出现了

Error attempting to get column 'mobile' from result set. Cause: org.postgresql.util.PSQLException: 不良的类型值 int : 135****444
; 不良的类型值 int : 135*****4444; nested exception is org.postgresql.util.PSQLException: 不良的类型值 int : 135****4444

经过一大堆莫名其.]]></description><category></category></item></channel></rss>