提问人:Mohamed Elbana 提问时间:11/5/2023 更新时间:11/5/2023 访问量:64
我在使用 dbeaver 将 CSV 文件导入我的数据库时遇到问题
I have a problem importing a CSV file into my database using dbeaver
问:
这是我第一次使用 dbeaver,当我导入数据时,出现以下错误消息:
Error occurred during batch insert
(you can disable batch insert in order to skip particular rows).
Reason:
SQL Error [22001]: Batch entry 178 INSERT INTO public.banklist ("Bank Name","City","State",cert,"Acquiring Institution","Closing Date",fund)
VALUES ('Coastal Bank','Cocoa Beach','FL',34898,'Florida Community Bank, a division of Premier American Bank, N.A.','6-May-11',10364) was aborted: ERROR: value too long for type character varying(64) Call getNextException to see other errors in the batch.
我尝试导入的 CSV 文件是从以下 URL 下载的:https://www.fdic.gov/resources/resolutions/bank-failures/failed-bank-list/
我试图剪除它,但注意到对我有用
答: 暂无答案
评论