i got error in mysql database

Question

0.00/5 (No votes)

See more:

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]

Posted 26-Dec-14 3:08am

hareshdgr8

Updated 10-Jan-15 2:35am

OriginalGriff

v2

Add a Solution

Comments

CodingLover 26-Dec-14 9:44am

How many rows you have in that table?

hareshdgr8 26-Dec-14 10:04am

77500

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sisir Patro · Answer 1 · 2014-12-28T23:23:00

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