in reply to Unable to load entire CSV file into DB
Something for you to investigate:
- Are you sure that the file is uploaded completely?
- Are you checking for database errors?
- Have you read Before asking a database related question ...?
- Did you try that SQL statement outside your script? I mean, manually, from the mysql monitor?
- Does the table structure correspond to the CVS structure?
If the answer to all the above questions is "yes", then I am prepared to accept that you might have a Perl problem. Otherwise, I should address you to a a more appropriate place where to ask your question.
Moreover, you are asking for a database related error, and then you are showing us an uploading script.
Is that relevant?
If not, why don't you skim the example to the only thing that matters?
In Section
Seekers of Perl Wisdom