Great work you did here. I have a question please, I am completely new to SQL and the initial process you carried out on Workbench before importing via command line is not very clear to me.
Hi tried this approach thank you but i have one question here first we have to create a table mannually in my sql which is also a lenghty proces. Is there any way we can directly add a table in data base
please i couldn't go further when i was loading the data, it showed me an error saying mysql version does not correspond to the syntax..i am using mysql version 8.0
Hello sir, I have a question on SQL joins which is asked in almost all SQL related interviews. So, table A has 100 rows table B 50 rows 30 primary key in common. So total no. Of rows returned in left join right join and inner join. Also minimum and maximum number of rows using any join? Sir please help in solving such problem. 🙏🏼
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOCAL DATA LOCAL INFILE 'C:\\Users\ andi\\OneDrive\\Desktop\\pbi food\\wfp_food' at line 1 -- showing this error what to do
after following this process it gave an error called : ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access. please let me know how to resolve this error?
Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement?....my files saved on N :...but showing this error
Great video but it doesnt work for me. Just like you the import in the wizard is not working (takes forever no progress after 30 min). But when I follow your steps you do not explain how to create a table. In the video you already have a table but I DO NOT. Please explain :)
Please help!! In my case while trying to import after entering the code LOAD DATA LOCAL INFILE....... It reruns an ERROR 2005 (HY000) : Unknown MySQL server host 'IGNORE' (11001) Kindly please help me in solving this issue please!
Great work you did here. I have a question please, I am completely new to SQL and the initial process you carried out on Workbench before importing via command line is not very clear to me.
Pls follow my SQL playlist, your doubts will be cleared
Hi tried this approach thank you but i have one question here first we have to create a table mannually in my sql which is also a lenghty proces. Is there any way we can directly add a table in data base
Thank you for the tutorial.. If you have more time, would you please make tutorial as well for importing data via cmd to MS SQL server. Thank you.
thankyou so much you just saved me
@ 06:20 what should be the datatype for exporting a column having decimal values like 2.1?
Thank you for the explaining
Please how do I get the code you wrote in the notepad?
please i couldn't go further when i was loading the data, it showed me an error saying mysql version does not correspond to the syntax..i am using mysql version 8.0
Nice explanation
Can you please make one video of cleaning data in sql before connecting to visualization tool..... Real time example
See my Tableau project, that's an end to end project, just search "HR Tableau Dashboard Satyajit" you will get it
Sir if ihave multiple tables how i can import all together
well explain sir
Hello sir, I have a question on SQL joins which is asked in almost all SQL related interviews.
So, table A has 100 rows table B 50 rows 30 primary key in common. So total no. Of rows returned in left join right join and inner join.
Also minimum and maximum number of rows using any join?
Sir please help in solving such problem. 🙏🏼
ruclips.net/video/XC6pFocflCI/видео.html
Watch this.
Thank you sir. 🙂
i am getting an error at the end saying permission denied , what to do?
Join our SQL community and ask here: chat.whatsapp.com/InvktTwr0uZBOhczRFeEDq
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOCAL DATA LOCAL INFILE 'C:\\Users\
andi\\OneDrive\\Desktop\\pbi food\\wfp_food' at line 1 -- showing this error
what to do
thank sir
after following this process it gave an error called : ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access. please let me know how to resolve this error?
Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement?....my files saved on N :...but showing this error
i am not able to import an excel file
i saved that file as .csv but also unable to import
Great video but it doesnt work for me. Just like you the import in the wizard is not working (takes forever no progress after 30 min). But when I follow your steps you do not explain how to create a table. In the video you already have a table but I DO NOT. Please explain :)
Nice !
Please help!!
In my case while trying to import after entering the code
LOAD DATA LOCAL INFILE.......
It reruns an ERROR 2005 (HY000) : Unknown MySQL server host 'IGNORE' (11001)
Kindly please help me in solving this issue please!
I have tested the code quite well, make sure you do it properly
❤
It is not working bro. Giving an error while pasting the command you wrote on a notepad
The code works perfectly fine, i still use it in my classes, the last time i used it was yesterday, so see if u did something wrong
@@SatyajitPattnaik okay i will try again
Thanks bro