drop table if exists t; create table t ( id int not null primary key, no int not null, str text ); time seq 10000000 | mysql test -e " load data local infile '/dev/stdin' into table t (@seq) set id = @seq, no = floor(rand() * 3), str = repeat('x', 100) "