我在下面创建了一个表
CREATE TABLE Hospitable_Planets(
Planet_name VARCHAR(30) PRIMARY KEY,
Planetmass_JPT DOUBLE,
Radius_JPT DOUBLE,
Period_days DOUBLE,
Semi_MajorAxis_AU DOUBLE,
Surface_Temp DOUBLE, /* temparture is in kelivn*/
Discovery_Method VARCHAR(30),
Discovery_Year INT,
Age_Gyr FLOAT
)
但是,每当我尝试通过表数据导入向导手动将 .csv 文件导入此表时,都会出现此错误。以下是 .csv 文件中的几行:
PlanetIdentifier,PlanetaryMassJpt,RadiusJpt,PeriodDays,SemiMajorAxisAU,SurfaceTempK,DiscoveryMethod,DiscoveryYear,AgeGyr
KOI-1843.03,0.0014,0.054,0.1768913,0.0048,,transit,2012,
KOI-1843.01,,0.114,4.194525,0.039,,transit,,
KOI-1843.02,,0.071,6.356006,0.052,,transit,,
Kepler-9 b,0.25,0.84,19.22418,0.143,707.2,transit,2010,
Kepler-9 c,0.17,0.82,39.03106,0.229,557.9,transit,2010,
我真的修好了。我用 0 填充了 excel 表中的所有空单元格,然后将 csv 文件传递给导入向导,它将它们上传到表中。否则 csv 文件有太多逗号在一起,因为 excel 表中该列中没有任何内容