在Ubuntu16.04上运行MySQL加载csv文件,老报错ERROR 1265 (01000): Data truncated for column ‘v_sate’ at row 1.网上查到的方法都不管用,发现terminated by ‘,’ optionally enclosed by ‘”’ escaped by ‘”’ lines terminated by ‘\r\n’的最后的’\r\n’改为’\n’就OK了.
MySQL报错ERROR 1265 (01000): Data truncated for column 'v_sate' at row 1
最新推荐文章于 2022-07-07 14:08:28 发布