In this video we will prepare a txt file with data and then load that data into MySQL table. We will understand how to write file correctly so as to be readable by …
source
MySQL Tutorials: Load data from a file into MySQL table
In this video we will prepare a txt file with data and then load that data into MySQL table. We will understand how to write file correctly so as to be readable by …
source
13 responses to “MySQL Tutorials: Load data from a file into MySQL table”
how do I insert table??? import database.sql with console???
thanks… I dont speak english but I understand you
shell command how to import csv file to multiple mysql table in linux.
thnu soo mch fr helpin out..xm saviour really..awsm ??
how automate csv import in mysql db..please post a video on this
load data infile make a row has a whitespace. can you tell me how to rtrim it before the data inserted to the table?
cheers Ranjit…legend!
Thanks Ranjit. This is massively helpful to me, you just saved my black ass!
helpful..
LOAD DATA LOCAL INFILE '/USERS/USERNAM/DESKTOP/MOVIE LIBRARY.TXT' into TABLE POPCORN;
data in a csv file is separated by comma ',' how do you address this kind of situation in LOAD DATA INFILE?
Good video thank you… How does it know what database its going into?
Are you using some kind of special software or just a text editer for this? And also, are you on your computer or do you have to be logged into a special server? Thanks