mysql 到出到csv 带列表明
来源:互联网 发布:学日语 知乎 编辑:程序博客网 时间:2024/06/01 16:55
select * from (select 'city_id' as city_id, 'company_id' as company_id, 'contract_no' as contract_no, 'biz_type' as biz_type, 'chargetype_id' as chargetype_id, 'charge_item_no' as charge_item_no, 'settlement_month' as settlement_month, 'role_type' as role_type, 'role_user_id' as role_user_id, 'assign_rate' as assign_rate, 'amount' as amount, 'shop_id' as shop_id, 'shop_mgr_id' as shop_mgr_id, 'area_id' as area_id, 'area_mgr_id' as area_mgr_id, 'remark' as remark, 'data_type' as data_type UNION ALLselect pd.city_id, pd.company_id, c.contract_no, pd.biz_type, pd.chargetype_id, pd.charge_item_no, pd.settlement_month, pd.role_type, pd.role_user_id, pd.assign_rate, pd.amount, pd.shop_id, pd.shop_mgr_id, pd.area_id, pd.area_mgr_id, pd.remark, pd.data_typefrom performance_detail pdLEFT JOIN contract con pd.contract_id=c.id ) d into outfile '...Desktop/detail.csv' fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n'; ;
阅读全文
0 0
- mysql 到出到csv 带列表明
- mysql导出含有字段列csv文件
- mysql 导出CSV文件 并带表头
- MySQL 表明区分大小写说明
- mysql 表明不区分大小写
- sql修改表明和列名
- 读取mysql文件,写入csv,带字段名
- mysql 导出CSV文件 并带表头or字段
- Linux设置mysql 表明区分大小写
- Oracle数据库如何改表明和列名?
- python csv写入多列
- mysql 导入csv 文件
- csv to mysql
- csv转入到mysql
- CSV 导入mysql 数据库
- mysql csv 使用实例
- mysql 导入导出 csv
- mysql导出csv文件
- 简要分析unity3d中 yield
- 通过#if和#endif灵活的为自己代码注释
- java程序员学习路线指南
- Spring MVC 中的基于注解的 Controller
- MapReduce程序理解
- mysql 到出到csv 带列表明
- jmeter之分布式控制
- 设计模式--策略模式
- 音频文件计算大小
- 练习1-12
- 百度AI开发者大会见闻
- 机器学习-学习笔记 绪论(一)
- 第一次运行带有除Java之外的其他语言的安卓项目
- Nginx 开启nginx服务后web无法访问解决方法