mysql查询结果导出/输出/写入到文件
直接执行命令:
select count(1) from table into outfile '/tmp/test.xls';
建立索引
CREATE INDEX mytable_categoryid_userid ON mytable (category_id,user_id);
查询结果输出到新表
INSERT INTO ip_helper1(client_no,server_name)
SELECT DISTINCT client_no,server_name FROM ip_record