weixin_45281949的博客

LOAD DATA INFILE '/var/lib/mysql-files/jjdb_fkdb_all_dropdup_20w.csv'into table `jjdb_fkdb_all_dropdup_20w` character set utf8fields terminated by ',' optionally enclosed by '"' escaped by '"'lines terminated by '\r\n';

1，用VMware打开服务器上的虚拟机，进入linux命令界面2，查看网卡名，如ens160ip addr3，修改网卡配置文件：cd etc/sysconfig/network-scriptsvi ifcfg-ens160此时出现以下界面，按“i”键，进入编辑，增加最后四行，BOOTPROTO更改为“static”，ONBOOT更改为“yes”，按“esc”退出编辑，并输入“:wq”保存：4，重启网络键入：service network restart5，查看Ipip addr