How to Import a CSV File into MySQL

Hello hello! Today I'm going to be walking step-by-step through one of the ways we can import CSV files into MySQL: by using the 'LOAD DATA INFILE' command. I struggled a lot with this until I figured out a few tips and tricks, and figured I'd share it with you. As always, likes and comments are welcome, and subscriptions are much appreciated!

#MySQL #DataAnalytics #SQL #CSV

[raufrukayat]

Thanks so much, your video was so helpful

[sangeetakumawat]

Thank u so much ... This video help me a lot

[hamzaarif]

Hey Jacob
What if we don't have an UPLOAD folder in mysql server?
I have some other folders like bin, docs, etc, include, lib, share
Where to locate my downloaded csv file then?
Any other option

Regards,
Hamza

[donatusvictor]

please what if my csv dosen't have primary key in the column but I have it in the database table I created what should I do?

[milosmrkajic]

Hey great job! What is when l get an error: data truncated at row 1 or error: inccorect integer value. Do you know hot to go around this problems. They are giving me such a headache

[SDG-xupe]

Thanks for the info.

Is the TBN file available online or where can I get it?

I need the file to practise.

[okonkwochukwuebuka]

I tried what you did but I keep getting this error

Error Code: 2068. LOAD DATA LOCAL INFILE file request rejected due to restrictions on access

[Gksharma]

Hey brother
My csv doesnt contain tha (") conetainer
So may i jusst remove that specific syntax and will it work??

[d.o.balogun]

Thanks boos. Is it possible to retain any previous records in the mysql table?

[Fadein]

Would you happen to know where I would find the progam_data < MySql folder on a mac?