Mysql客户端远程Load

mysql -h $host -u $user -p$password  $USED_DB --local-infile=1 -e "LOAD DATA LOCAL INFILE '"$FILENAME"' INTO TABLE TBL FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n';


参考:http://blog.csdn.net/china_skag/article/details/8064429

你可能感兴趣的