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博客 ” ,链接:http://blog.itpub.net/29911917/viewspace-1281918/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29911917/viewspace-1281918/