我在mysql数据库中遇到错误 [英] i got error in mysql database

问题描述

当我将文件加载到MySQL时



我收到错误



ERROR 1261（01000） ：行2190679不包含所有列的数据



测试：根据报告的问题更改标签 - http://www.codeproject.com/Messages/4977026/about-Tags-in-Ask-Question-forum.aspx [ ^ ] OriginalGriff [/ edit]

when I load file in to MySQL

I got error

ERROR 1261 (01000): Row 2190679 doesn't contain data for all columns

[edit]Test: changing tags as per problem reported - http://www.codeproject.com/Messages/4977026/about-Tags-in-Ask-Question-forum.aspx[^] OriginalGriff[/edit]

推荐答案

一般在导入时excel sheet到DB有可能出现这个问题。假设我有一张excel表，其中只有一条记录，其余的行都是空的。有时当我们尝试将Excel工作表导入数据库时​​，应该手动删除没有任何数据的行，然后将其导入到数据库中，否则数据库会将剩余的行作为有价值的行进行处理并尝试插入到数据库中，从而导致您遇到的相同错误。



所以如果任何行没有任何数据或者你可以有一个数据，你可以删除记录检查数据库中的条件以跳过这些行。



请按照以下链接更好地理解。

点击此处查看链接参考信息



谢谢

Sisir Patro

Hi,

Generally while importing an excel sheet to DB there is a chance of this issue. Lets say I am having one excel sheet where only one record is there and rest of the rows are empty. Some times when we try to import an excel sheet into DB the rows which does not have any data should be deleted manually and then it should be imported to DB, or else the database will treate the rest of the rows as valued row and try to insert into database and thus result into the same error that you are facing.

So You can delete the records if any row is not having any data or you can have a check condition in the database for the same to skip those rows.

Please follow the following link for better understanding.
Click here for link reference

Thanks
Sisir Patro

这篇关于我在mysql数据库中遇到错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！