I've been loading CSV files by converting them to an insert query using the CSV Lint plugin for Notepad++ and then cutting and pasting into MySQL Workbench, but that doesn't seem to work with files over a certain size. I will try your method next time, thank you for showing this.
Helpful video but i have question: what if i have a big csv file with also a LOT of columns? I have to define manually each of that columns by myself in the CREATE TABLE query or there is a faster way?
Bor what If I have dataset for example covid_deaths and it contain columns like new_cases, total_deaths which contain some missing values. Then how we should load this dataset by doing the same method you have explained. I am doing project in which I am facing the issue while loading the file. Please guide me👏
Error Code: 1366. Incorrect integer value: '"1"' for column 'id' at row 1. I have checked the csv data didn't have ''1''. How should I solve this. Please guide me
I am getting error : “mysql server is running with the secure priv option , so it cannot execute this statement “ . Could you tell me how to resolve this error ??
@@aniketmishra1386 did any one got the resolution for above error, i am also trying to upload the huge data file with thi8s method but i am getting the same error as you were getting. plz help
I've been loading CSV files by converting them to an insert query using the CSV Lint plugin for Notepad++ and then cutting and pasting into MySQL Workbench, but that doesn't seem to work with files over a certain size. I will try your method next time, thank you for showing this.
It was too helpful for me bro....I loved your work......❤️❤️❤️❤️❤️
Glad it helped
perfect, Brazil thank you for your class
After passing the query show variable "secure-file-priv". I'm getting 0 rows returned
GREAT
WELL DONE
I am getting error " the mysql server is running with the secure file priv option so it cannot execute this statement"
Helpful video but i have question: what if i have a big csv file with also a LOT of columns? I have to define manually each of that columns by myself in the CREATE TABLE query or there is a faster way?
You can do by using python or any other programming language. For SQL I don't think there exists such solution.
Thanks a lot buddy ❤❤❤
Bor what If I have dataset for example covid_deaths and it contain columns like new_cases, total_deaths which contain some missing values. Then how we should load this dataset by doing the same method you have explained. I am doing project in which I am facing the issue while loading the file. Please guide me👏
As I am understanding you need to do data cleaning step first. If any further doubts mail me: nitishkumar03382@gmail.com
Superb❤❤❤
♥️
Error code 29 after executing that query.please help me @data query
Error Code: 1366. Incorrect integer value: '"1"' for column 'id' at row 1. I have checked the csv data didn't have ''1''. How should I solve this. Please guide me
Check column 'id' in your csv file and confirm if it has any string value or not. If any string value then convert it into integer type
@@dataquery03382 ok thanks alot brother
I am getting error : “mysql server is running with the secure priv option , so it cannot execute this statement “ . Could you tell me how to resolve this error ??
Put your file inside this folder "C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\". Then run the load command. This might work
@@dataquery03382 I have copied the file to the required folder but still same error is appearing
@@Vivek.S.RajputHi i am also getting the same error have you resolved it ?
@@dataquery03382it's still showing error please help us to resolve
@@aniketmishra1386 did any one got the resolution for above error, i am also trying to upload the huge data file with thi8s method but i am getting the same error as you were getting. plz help