Import Excel / CSV To MySQL table without any Software

[@robbief7947]

You're my hero! I struggled with this all day; I missed the \\ on the file path. Thank you!

[@khaledabo5573]

this is exactly what I was looking for, thank you so much!

[@poolwaiter]

If you get the permission denied (using mySQL 8 or later) here is how to fix. Open my.ini in Notepad (it is in your ProgramData/MySQL/MySQL Server 8 folder). Under each header (for Client and Server), paste this line: local_infile=ON and resave.

[@nguyenanh3824]

Hi I cannot find my.ini in folder. Pls could you show me how

[@poolwaiter]

@@nguyenanh3824 ProgramData is a hidden folder. Bring up your files (ThisPC) go to the C: folder. Click on "View" in the top menu and check the box for "Hidden Items". ProgramData should display. Then follow the path I showed above and my.ini will be in the MySQL Server 8 root folder.

[@myhobbies1288]

@@poolwaiter I got the my.ini but where exactly to paste I am confused can you please guide

[@poolwaiter]

@@myhobbies1288 If you scroll down, you will see [client] on its own line, under that, paste what I showed you. A little lower you should see [mysql]. Paste that line under that as well.

[@benokhattirach310]

This is so brilliant! Thank you so much! May God bless you

[@fredrickmsomba4123]

Thank you for this tutorial it was very helpful.

[@danielpaez2877]

Thanks you my friend for sharing, it was so useful for me, i takes notes!!

[@akshaysav5547]

How to solve error
Loading local data is disabled
This must be enabled both on client and server side

[@gandikotadharani3947]

I TOO GOT THE SAME ERROR...CAN U PLEASE SUGGEST HOW U RESOLVE..IF U HAVE RESOLVED

[@JamesWelbes]

Is it possible to do this with a live feed, password protected csv?

[@tahirjanwari8775]

Extremely helpful

[@debendra2010]

excellent explanation

[@abishekhedaoo8196]

Great video, Thanks
I have one query
What should be the date format in STR_TO_DATE() for 2-Jan-21
this type of date.

[@akshdeepkumar5225]

I want to keep the date in the string format what will be the syntax then???

[@erichepperle7085]

Looking forward to trying this!

[@davy5537]

I will start a new rock 'n roll band in your honor, thanks my firend

[@jumpingnieh2378]

This video is so helpful

[@collinsonyegbado309]

Thanks a lot for the video. Is there anyway one can set date sync on registration form so that if a user registers,we will know the date and time the user registered

[@jackfanny2392]

Nice video bro .. Thanks for sharing your ideas. If it has like multiple sheets in MSXCEL and want to read particular sheet . In this case how can i set path ?

[@saikannan665]

can tell what is the syntax for time instead of the date

[@kimchris5721]

Thank you very much it’s really I have wanted.Because I failed to install phpmyadmin

[@rajnishpsinha4683]

Thank a lot, It saved me a day!

[@marclinstanleyderalin]

Good job! I appreciate. But I wonder why this code doesn't want to work on my computer anyway.

[@vikram-ud5df]

Thank you very much............

[@onson]

I got an error
ERROR: Loading local data is disabled - this must be enabled on both the client and server sides

[@gurdeepsaluja2746]

Getting similar error and no solution found on google search ..did you get through this ?

[@lacineberthe7599]

@@gurdeepsaluja2746 SET GLOBAL local_infile = true; copy it on mysql it will be ok

[@gandikotadharani3947]

@@lacineberthe7599 I TRIED THAT COMMAND EVEN ..BUT I AM GETTING "" LIKE THISLOAD DATA LOCAL INFILE file request rejected due to restrictions on access" PLEASE SUGGEST HOW TO RESOLVE THIS
mysql> LOAD DATA LOCAL INFILE "/home/tinku/Downloads/INPUTDATA.CSV" INTO TABLE INPUTDATA FIELDS TERMINATED BY ',' LINES TERMINATED BY '
' IGNORE 1 LINES (on_Date ,cases_total,deaths_total,cases_age_0_17,cases_age_18_29,cases_age_30_39,cases_age_40_49,cases_age_50_59,cases_age_60_69,cases_age_70_79,cases_age_80_above,deaths_age_0_17,deaths_age_18_29,deaths_age_30_39,deaths_age_40_49,deaths_age_50_59,deaths_age_60_69,deaths_age_70_79,deaths_age_80_above );
ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.
mysql>

[@karankainth1363]

Can you plz help me with datetime format, i tried STR_TO_DATE but my command line said its incorrect parameter in the call to native function, can you help plzz.
i want to add date and time, both

[@sunniecheng3473]

Can these files be called to execute under PHP code?

[@JitendraDas-pe3ve]

How to append files using this query

[@isilcaliskan3939]

This is great, thanks!

[@aymanmoutaouakil6070]

can you tall me please the right forma for the time (dd/mm/yyyy hh:mm) like in the video
thank you

[@cenkcamkiran]

Your csv file is small. I have csv file with 270k data (row). This is too slow for me. Can you help me

[@RulliR]

you have same case with me, im not using looping for this case, i try to do it with load data infile < try to search this

[@ramilijaonampoina3862]

Thank you Sir

[@johnp8875]

Nice topic , can you save this a php script and then call it in a cron job

[@pranavjoshi9234]

thanks man i love u

[@gaichrinmalangmei692]

i cannot able to import 30000 rows
how to do pls help...

[@SinghSikarwar12100]

With me it's show permission denied. What can I do with this

[@poolwaiter]

See my comment.

[@philtoa334]

Thanks , nice.

[@lacineberthe7599]

I have this error : LOAD DATA LOCAL INFILE file request rejected due to restrictions on access. someone can help me

[@rishavsengupta1059]

how to handle null values?

[@ЮрийНиколаенко-я7с]

thank 's bro

[@rishabhchou]

showing and error
invalid utf8mb4 character string: konftel 250

[@nancybergen5998]

Because my Table has 85 columns, and I can't make structure manually.I found very fast and elegance decision Search - ( excel2mysql es ) - online very useful tool. Converts .xsls , xls , csv files to SQL code for easy import in database.

[@BellTollsForThee]

You are the fucking man!
Thank you sir!

[@vitorsilva-or1dj]

thankssssssssss