Anonymous Anonymous - 7 months ago
299 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';
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download