当我导入csv文件时,出现以下错误:
ERROR: extra data after last expected column SQL state: 22P04 Context: COPY everyhighschool, line 1: "B100005528,서울특별시,구암고등학교,구암고등학교,,,,,"
我的表格:
CREATE table everyhighschool(
schoolcode varchar(10),
region varchar(20),
shortschoolname varchar(30),
schoolname varchar(30))
我的复制代码
COPY everyhighschool(schoolcode, region, shortschoolname, schoolname)FROM 'C:\Users\Administrator\Desktop\code.csv' WITH DELIMITER ',';