You're my hero! I struggled with this all day; I missed the \\ on the file path. Thank you!
@khaledabo5573
4 жыл бұрын
this is exactly what I was looking for, thank you so much!
@rajnishpsinha4683
Жыл бұрын
Thank a lot, It saved me a day!
@debendra2010
Жыл бұрын
excellent explanation
@benokhattirach310
3 жыл бұрын
This is so brilliant! Thank you so much! May God bless you
@abishekhedaoo8196
3 жыл бұрын
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.
@tahirjanwari8775
2 жыл бұрын
Extremely helpful
@danielpaez2877
5 жыл бұрын
Thanks you my friend for sharing, it was so useful for me, i takes notes!!
@fredrickmsomba4123
4 жыл бұрын
Thank you for this tutorial it was very helpful.
@jackfanny2392
3 жыл бұрын
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 ?
@marclinstanleyderalin
3 жыл бұрын
Good job! I appreciate. But I wonder why this code doesn't want to work on my computer anyway.
@erichepperle7085
3 жыл бұрын
Looking forward to trying this!
@kimchris5721
4 жыл бұрын
Thank you very much it’s really I have wanted.Because I failed to install phpmyadmin
@collinsonyegbado309
5 жыл бұрын
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
@pranavjoshi9234
3 жыл бұрын
thanks man i love u
@JamesWelbes
5 жыл бұрын
Is it possible to do this with a live feed, password protected csv?
@davy5537
4 жыл бұрын
I will start a new rock 'n roll band in your honor, thanks my firend
@philtoa334
2 жыл бұрын
Thanks , nice.
@isilcaliskan3939
3 жыл бұрын
This is great, thanks!
@poolwaiter
4 жыл бұрын
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
3 жыл бұрын
Hi I cannot find my.ini in folder. Pls could you show me how
@poolwaiter
3 жыл бұрын
@@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
3 жыл бұрын
@@poolwaiter I got the my.ini but where exactly to paste I am confused can you please guide
@poolwaiter
3 жыл бұрын
@@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.
@akshdeepkumar5225
3 жыл бұрын
I want to keep the date in the string format what will be the syntax then???
@jumpingnieh2378
5 жыл бұрын
This video is so helpful
@saikannan665
3 жыл бұрын
can tell what is the syntax for time instead of the date
@akshaysav5547
4 жыл бұрын
How to solve error Loading local data is disabled This must be enabled both on client and server side
@gandikotadharani3947
3 жыл бұрын
I TOO GOT THE SAME ERROR...CAN U PLEASE SUGGEST HOW U RESOLVE..IF U HAVE RESOLVED
@vikram-ud5df
5 жыл бұрын
Thank you very much............
@ramilijaonampoina3862
3 жыл бұрын
Thank you Sir
@karankainth1363
3 жыл бұрын
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
4 жыл бұрын
Can these files be called to execute under PHP code?
@vitorsilva-or1dj
3 жыл бұрын
thankssssssssss
@JitendraDas-pe3ve
Жыл бұрын
How to append files using this query
@BellTollsForThee
2 жыл бұрын
You are the fucking man! Thank you sir!
@johnp8875
6 жыл бұрын
Nice topic , can you save this a php script and then call it in a cron job
@ЮрийНиколаенко-я7с
4 жыл бұрын
thank 's bro
@gaichrinmalangmei692
2 жыл бұрын
i cannot able to import 30000 rows how to do pls help...
@onson
4 жыл бұрын
I got an error ERROR: Loading local data is disabled - this must be enabled on both the client and server sides
@gurdeepsaluja2746
4 жыл бұрын
Getting similar error and no solution found on google search ..did you get through this ?
@lacineberthe7599
3 жыл бұрын
@@gurdeepsaluja2746 SET GLOBAL local_infile = true; copy it on mysql it will be ok
@gandikotadharani3947
3 жыл бұрын
@@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>
@aymanmoutaouakil6070
5 жыл бұрын
can you tall me please the right forma for the time (dd/mm/yyyy hh:mm) like in the video thank you
@lacineberthe7599
3 жыл бұрын
I have this error : LOAD DATA LOCAL INFILE file request rejected due to restrictions on access. someone can help me
@cenkcamkiran
6 жыл бұрын
Your csv file is small. I have csv file with 270k data (row). This is too slow for me. Can you help me
@RulliR
5 жыл бұрын
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
@rishabhchou
4 жыл бұрын
showing and error invalid utf8mb4 character string: konftel 250
@rishavsengupta1059
4 жыл бұрын
how to handle null values?
@SinghSikarwar12100
4 жыл бұрын
With me it's show permission denied. What can I do with this
@poolwaiter
4 жыл бұрын
See my comment.
@nancybergen5998
5 жыл бұрын
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.
Пікірлер: 54