mysql select into outfile 语法 乱码问题
来源:互联网 发布:2017网络营销发展数据 编辑:程序博客网 时间:2024/05/23 14:26
一个常见的问题,mysql 导出csv格式的语法,已经乱码问题:
由于数据库一般默认的是UTF-8 格式的字符集,而execl默认的是gbk格式的字符集,这里有两种方法解决乱码:
方法一: 先转出.txt格式的文件,然后选择用excel打开时,提示选择哪种编码打开,选择gbk即可
select * from mobile_order_region where school_id=6921 into outfile '/tmp/6921.txt'
方法二:导出时直接设置字符集格式:
mysql> select * from mobile_order_region where school_id=6921 into outfile '/tmp/6921.csv'
CHARACTER SET gbk
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';
Query OK, 6888 rows affected (0.11 sec)
mysql> \q
0 0
- mysql select into outfile 语法 乱码问题
- MySQL select into outfile 语法
- mysql select into outfile
- mysql的select into outfile
- mysql语句-select...into outfile
- mysql语句-select...into outfile
- MYSQL解决select ... into outfile '..' mysql写文件权限问题
- 解决select ... into outfile '..' mysql写文件权限问题
- select * into outfile导出到excel乱码
- mysql select * into OUTFILE 不会锁表
- MySQL使用SELECT...INTO OUTFILE导出文本文件
- MySQL使用SELECT INTO OUTFILE导出文本文件
- MySQL 导出数据select into outfile用法
- select into outfile access deny问题
- select..into outfile
- mysql 中关于select into outfile 提示权限不足的问题
- mysql select into outfile 意表备份还原方式
- mysql select into outfile报无权限,访问被拒绝
- CentOS 6.5下yum安装 MySQL-5.5全过程图文教程
- Spring Boot 官方文档学习(一)入门及使用
- Spring客户端对Redis 缓存的使用(Java客户端等Redis3.X RedisCluster模式的支持)
- 字符串 String
- Z-Stack Developer's Guide - Binding & Routing
- mysql select into outfile 语法 乱码问题
- rabbitmq client 自编译
- spring框架学习(八)—静态代理、JDK与CGLIB动态代理、AOP+IoC
- 常用机器学习算法总结
- Spring Security3 - MVC 整合教程 (初识Spring Security3)
- HTML5
- 华为35
- ajaxForm和ajaxSubmit 粘贴就可用
- IOS10上崩溃错误“View has lost track of its superview, most likely through unsupported use of CALayer”解决方案