行导入失败，错误：(“第1行'Planetmass_JPT‘列的数据截断”，1265)

Question

我在下面创建了一张桌子

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,

Answer 1

我真的修好了。我用0's填充了excel表中的所有空单元格，然后将csv文件传递给导入向导，将它们上传到表中。否则，csv文件有太多逗号在一起，因为该列在excel表中没有任何内容。