mysql导出到txt

mysql -uxxxx -p -hxxx -e "show databases;use xxx;select user_award_id,user_id,consumer_id,create_time,FROM_UNIXTIME(create_time,'%Y-%m-%d %H:%i:%s') from xxx where xxx = '' and xxx = '' ;" > user.txt