Category Archives: MySQL

MySQL – importing data

I needed to bulk load data into a MySQL instance a bit ago and here’s the way to do it: You should login to mysql and select the correct database/schema prior to running that command. mysql -uusername -p use <schema>; load data local infile ‘data.csv’ into table <tableName> fields terminated by ‘,’ enclosed by ‘”‘ [...]