win10下 cmd 进入mysql目录
cd D:\phpStudy\PHPTutorial\MySQL\bin;
mysql -u root -p;
输入密码
选择数据库 use database;
SELECT name FROM ci_my GROUP BY name HAVING COUNT(name) > 1 into outfile 'D://myname/123.sql';
如果出错
show variables like '%secure%';
查看secure_file_priv的值,如果为NULL,则修改mysql目录下的my.ini,
在mysqld下增加secure_file_priv = ''
重启mysql