Tuesday, October 09, 2007
MySQL for a start
TRUNCATE TABLE ;
remove all data and reset auto_increment field
load data local infile '/path/to/localfile.tsv'
into table
fields terminated by '\t'
lines terminated by '\n'
(field1, field2, field3)
import data into a table.
Exploring replication, the basic way to prevent database problem.
remove all data and reset auto_increment field
load data local infile '/path/to/localfile.tsv'
into table
fields terminated by '\t'
lines terminated by '\n'
(field1, field2, field3)
import data into a table.
Exploring replication, the basic way to prevent database problem.
