Member Avatar for rajuchacha007

Hello,

I am importing a in.csv file in mysql. I t contains one variable called CaptureDate.

load data infile 'C\in.csv' into table table name
lines terminated by '\n'
ignore 1 lines;

Once I executed, I got errors like row 1 doesn't contain data for all columns. I changed the data types from date to varchar,long and numeric but still not able to resolve he problem. Later I tried to use str_to_date(). But still not able to get it executed. Please advise. Thank you very much in advance.

  • 2 Contributors
  • 1 Reply
  • 68 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by autofesa
Member Avatar for autofesa

Hi.

I think you should put the code for understan better your problem. Initially it seems that the CSV is not well formed

-----------------------------------------------------------
coches de segunda mano

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.