Export Mysql query to CSV

select * from users into outfile '/mnt/sda7/ref_city.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';