mysql导出任意字段为csv

0 阅读1分钟
mysql -u 用户名 -p -e "USE 数据库名; select md.id,',',md.address,',',md.name,',',cd.imsi,',',md.domain from device md left join attr_dtu cd on md.id = cd.device_id order by md.id asc limit 6;" > /home/output-03.csv