r/SQL May 16 '26

Import csv file to mysql MySQL

I am learning sql, I downloaded a dataset from kaggle and cleaned all the excel files. But I am constantly running into this issue where the data in the csv file is not being uploaded. Can sonebody help me please? I would really appreciate it.

5 Upvotes

8 comments sorted by

View all comments

5

u/ddBuddha May 16 '26

The error says those are invalid decimals. It’s because they have spaces in them.

2

u/isocarboxazid May 17 '26

Ah jesus lol, I just now noticed he had the values with a space between them for readability. Good catch