Bulk load CSV data set into mysql using csvkit
This video shows how we can load whole CSV data set into mySQL in one single statement by using csvkit.
CODE:-
import MySQLdb
import csvkit
!csvsql --db mysql://root:[email protected]:3306/fit --insert FitBitdata.csv
referenced URL
https://github.com/wireservice/csvkit...
https://stackoverflow.com/questions/4...
#csv #csvkit #sql #mysql #jupyternotebook #single #statement
#bulkload #bulk #load