1、linux服务器上登录mysql
mysql -h192.168.1.110 -uroot -p123456
2、选择数据库
use test;
3、执行导入命令:
文件的insert.txt的内容格式:
"耳塞","3332","埃及"#
"县衙","4442","开封"#
命令:
load data local infile "/usr/insert.txt" into table Customer FIELDS TERMINATED BY "," enclosed by "\"" LINES TERMINATED BY "#" (name,phone,address);