1

I have saved a dataframe (pandas) in python as a CSV file and am trying to import it into a table using Heidi SQL and I get the error "SQL Error: Data truncated for column 'SlNo' at row 1". Here is the error: The error message

Here is my table: Here is the table

And this is the CSV file: https://drive.google.com/open?id=1qDfkTNZNTOKTSpnia3CFoW1ahHm6LQ5v

jarlh
  • 42,561
  • 8
  • 45
  • 63
Shobhit Kumar
  • 626
  • 1
  • 5
  • 21

1 Answers1

2

As fields in your csv file separated by comma, you have to specify "," (comma) as field terminator on import dialog instead of ";" (semicolon).

fifonik
  • 1,556
  • 1
  • 10
  • 18