Anonymous Anonymous - 1 month ago
145 0

import tsv to mysql

MySQL

import tsv file to mysql

use dbname;
LOAD DATA LOCAL INFILE '/var/lib/mysql-files/filename.tsv'
INTO TABLE tablename
FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';