mysql从客户端载入数据文件到表的方法
D:/laojiang/load_laojiang.bat:
mysql -ulaojiang -ppassword -Dlaojiang -h10.10.10.212 -P3307 -f < laojiang/laojiang.sql 2> laojiang.log
D:/laojiang/laojiang/laojiang.sql:
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
load data local infile 'D:/laojiang/laojiang/user_info1.txt' into table user_info CHARACTER SET utf8 FIELDS TERMINATED BY X'1E' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
mysql -ulaojiang -ppassword -Dlaojiang -h10.10.10.212 -P3307 -f < laojiang/laojiang.sql 2> laojiang.log
D:/laojiang/laojiang/laojiang.sql:
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
load data local infile 'D:/laojiang/laojiang/user_info1.txt' into table user_info CHARACTER SET utf8 FIELDS TERMINATED BY X'1E' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29911917/viewspace-1281918/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
mysql用户本机登录方式对应的用户
请登录后发表评论
登录
全部评论
