点击(此处)折叠或打开sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf 增加两行:secure_file_priv="/"innodb_flush_log_at_trx_commit = 0load data infile '2017-8-14-10000-2.txt' into table migu_phone_num fields terminated by '----';...【阅读全文】
my.ini内容[mysqld]character-set-server=utf8 [client]default-character-set=utf8[mysql]default-character-set=utf8检验配置结果如果更改My.ini配置文件,请重启MySQL服务。通过 show variables like 'character%' 和 show variables like 'collation_%'&n...【阅读全文】