SQL Data Import & Export - EXPLAINED!!

It is not working bro. Giving an error while pasting the command you wrote on a notepad

Please how do I get the code you wrote in the notepad?

Thank you for the explaining

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 :)

Sir if ihave multiple tables how i can import all together

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?

thankyou so much you just saved me

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

Nice !

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

well explain sir

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!

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. 🙏🏼

Can you please make one video of cleaning data in sql before connecting to visualization tool..... Real time example