mysql导入固定格式的数据 -- load data
例句:
./bin/mysql -uroot -p LOAD DATA INFILE '/home/sdb/mysql/seed/web_sales/web_sales1-2.dat'
INTO TABLE test.web_sales
FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
说明:
导入 '/home/sdb/my
原创
2015-12-31 13:40:53 ·
1280 阅读 ·
0 评论