如何在select into outfile 的文件中显示column name
来源:互联网 发布:服装cad软件 编辑:程序博客网 时间:2024/06/14 16:20
正常情况先select into outfile 生产的文件是不包含column name,比如如下sql
(root@localhost) [test]>SELECT EVENT_NAME ,COUNT_STAR from events_stages_summary_global_by_event_name;+---------------------------------------------------------------------------------------+------------+| EVENT_NAME | COUNT_STAR |+---------------------------------------------------------------------------------------+------------+| stage/sql/After create | 0 || stage/sql/allocating local table | 0 || stage/sql/preparing for alter table | 0 || stage/sql/altering table | 0 || stage/sql/committing alter table to storage engine | 0 || stage/sql/Changing master | 0 || stage/sql/Checking master version | 0 || stage/sql/checking permissions | 0 || stage/sql/checking privileges on cached query | 0 || stage/sql/checking query cache for query | 0 || stage/sql/cleaning up | 0 || stage/sql/closing tables | 0 || stage/sql/Connecting to master | 0 || stage/sql/converting HEAP to MyISAM | 0 || stage/sql/Copying to group table | 0 || stage/sql/Copying to tmp table | 0 || stage/sql/copy to tmp table | 0 || stage/sql/Creating delayed handler | 0 || stage/sql/waiting for delay_list | 0 || stage/sql/waiting for handler insert | 0 || stage/sql/waiting for handler lock | 0 || stage/sql/waiting for handler open | 0 || stage/sql/Waiting for INSERT | 0 || stage/sql/Waiting for master to send event | 0 || stage/sql/Waiting for master update | 0 || stage/sql/Waiting for slave mutex on exit | 0 || stage/sql/Waiting for slave thread to start | 0 || stage/sql/Waiting for table flush | 0 || stage/sql/Waiting for query cache lock | 0 || stage/sql/Waiting for the next event in relay log | 0 || stage/sql/Waiting for the slave SQL thread to advance position | 0 || stage/sql/Waiting to finalize termination | 0 || stage/sql/Waiting to get readlock | 0 || stage/mysys/Waiting for table level lock | 0 || stage/sql/Waiting on empty queue | 0 || stage/sql/Waiting for next activation | 0 || stage/sql/Waiting for the scheduler to stop | 0 || stage/sql/Waiting for global read lock | 0 || stage/sql/Waiting for schema metadata lock | 0 || stage/sql/Waiting for table metadata lock | 0 || stage/sql/Waiting for stored function metadata lock | 0 || stage/sql/Waiting for stored procedure metadata lock | 0 || stage/sql/Waiting for trigger metadata lock | 0 || stage/sql/Waiting for event metadata lock | 0 || stage/sql/Waiting for commit lock | 0 |+---------------------------------------------------------------------------------------+------------+108 rows in set (0.00 sec)
使用select 列出所有的字段,比如select "Col1","Col2".... union all
(root@localhost) [test]>select "EVENT_NAME","COUNT_STAR" -> union all -> SELECT EVENT_NAME ,COUNT_STAR from events_stages_summary_global_by_event_name;+---------------------------------------------------------------------------------------+------------+| EVENT_NAME | COUNT_STAR |+---------------------------------------------------------------------------------------+------------+| EVENT_NAME | COUNT_STAR || stage/sql/After create | 0 || stage/sql/allocating local table | 0 || stage/sql/preparing for alter table | 0 || stage/sql/altering table | 0 || stage/sql/committing alter table to storage engine | 0 || stage/sql/Changing master | 0 || stage/sql/Checking master version | 0 || stage/sql/checking permissions | 0 || stage/sql/checking privileges on cached query | 0 || stage/sql/checking query cache for query | 0 || stage/sql/cleaning up | 0 || stage/sql/closing tables | 0 || stage/sql/Connecting to master | 0 || stage/sql/Waiting for table metadata lock | 0 || stage/sql/Waiting for stored function metadata lock | 0 || stage/sql/Waiting for stored procedure metadata lock | 0 || stage/sql/Waiting for trigger metadata lock | 0 || stage/sql/Waiting for event metadata lock | 0 || stage/sql/Waiting for commit lock | 0 |+---------------------------------------------------------------------------------------+------------+109 rows in set (0.00 sec)
或者直接使用mysql -e > a.log 的方式来实现
mysql -u gf -p test -e "SELECT EVENT_NAME ,COUNT_STAR from events_stages_summary_global_by_event_name" > /home/mysql/event2.dat
0 0
- 如何在select into outfile 的文件中显示column name
- select into outfile的用法
- mysql的select into outfile
- 关于Mysql中select into outfile权限的探讨
- select..into outfile
- mysql select into outfile
- 解决select ... into outfile '..' mysql写文件权限问题
- MYSQL解决select ... into outfile '..' mysql写文件权限问题
- mysql 中关于select into outfile 提示权限不足的问题
- MySQL select into outfile 语法
- mysql语句-select...into outfile
- mysql语句-select...into outfile
- SELECT ... INTO OUTFILE 指定字符集
- select into outfile和load data infile的问题
- select into outfile 需要file on *.* 的权限
- MySQL通过自增一列在Select ... into outfile...里面实现CSV导出带字段的效果
- MySQL通过自增一列在Select ... into outfile...里面实现CSV导出带字段的效果
- select into outfile和load data infile
- 库
- TimesTen临时(内存)空间使用和调整临时(内存)空间
- 连接Oracle11g数据库时遇到无监听,网络适配器无法建立等问题的一些解决办法
- C&C++ 程序内存分配
- 使用 Rational Application Developer V7.0 开发 JAX-WS Web 服务
- 如何在select into outfile 的文件中显示column name
- 趋势科技笔试结束
- 100个高质量Java开发者博客
- uva 624 CD(01背包问题)输出最小字典序是个问题虽然题目不要求
- js 弹出窗口
- LCA的介绍
- oracle sql 学习记录
- 第十四周项目3-立体类族共有的抽象类
- Java开发牛人十大必备网站