读取mysql文件，写入csv，带字段名

最新推荐文章于 2024-09-16 19:45:23 发布

Yan456jie

最新推荐文章于 2024-09-16 19:45:23 发布

阅读量2k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/Yan456jie/article/details/72123174

版权

数据库专栏收录该内容

22 篇文章 0 订阅

订阅专栏

SELECT * FROM (
SELECT 'creativeID' AS creativeID,'userID' AS userID,'positionID' AS positionID,'clickTime' AS clickTime,'conversionTime' AS conversionTime,'connectionType' AS connectionType,'telecomsOperator' AS telecomsOperator,'appPlatform' AS appPlatform,'sitesetID' AS sitesetID,'positionType' AS positionType,'age' AS age,'gender' AS gender,'education' AS education,'marriageStatus' AS marriageStatus,'haveBaby' AS haveBaby,'hometown' AS hometown,'residence' AS residence,'appID' AS appID,'appCategory' AS appCategory,'label' AS label
UNION ALL
SELECT
creativeID,userID,positionID,clickTime,conversionTime,connectionType,telecomsOperator,appPlatform,sitesetID,positionType,age,gender,education,marriageStatus,haveBaby,hometown,residence,appID,appCategory,label
from t_uniondata
limit 0,1000000
) as a into outfile '/var/lib/mysql-files/data1.csv' FIELDS TERMINATED BY ',' lines terminated by '\n';