set global local_infile = 'ON'; LOAD DATA LOCAL INFILE "D:/tmdata/20181130/sbzcrxx.csv" INTO TABLE `trademarkregister` character set utf8 fields term
从csv导入数据,指定编码为utf8,忽略第一行标题。set global local_infile = 'ON'; LOAD DATA LOCAL INFILE "D:/tmdata/2017/sbzcrxx.csv" INTO TABLE `trademarkregister` character set utf8&
此处是在公司线上部署mysql双主时所记录的文档,为安全,IP都改为内网IP。版本信息:#mysql -Vmysql Ver 14.14 Distrib 5.5.37, fordebian-linux-gnu (x86_64) using readline 6.2 1、主库开启bin-log功能,配置server-id修改my.cf配置文件,开启bin-log功能,配置server-id。#cat /etc/mysql/my.cnf[myqld]server-id