mysql导入格式化txt数据(超快)

 

 mysql -u [youruser] -h [youraddress] -p [yourpassword] [yourdatabase] --local-infile=1 -e "[yourcmd]" 

example：

mysql -uroot -p123456 book --local-infile=1 -e "load data local infile '/home/hp/test.txt'into table test fields terminated by ' ';"