MySql Load
the load data command lets you import a CSV into a (remote) mysql databaseload data local
LOAD DATA LOCAL INFILE "mydata.csv"
INTO TABLE mytable
COLUMNS terminated BY "," OPTIONALLY ENCLOSED BY '"'
IGNORE 1 LINES
INTO TABLE mytable
COLUMNS terminated BY "," OPTIONALLY ENCLOSED BY '"'
IGNORE 1 LINES
REFERRERS
MySqlAdministration
