hmm, hard to escape the @ char. Version two:-
/bin/rm -rf /tmp/results.txt&&/usr/bin/mysql -uroot -yourusername -D asteriskcdrdb -e “SELECT * INTO OUTFILE ‘/tmp/results.txt’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY '”’ LINES TERMINATED BY ‘\n’ FROM cdr WHERE calldate BETWEEN ‘$(date -d “$(date +%Y-%m-%d) -1 month” +%Y-%m-%d)’ AND ‘$(date +%Y-%m-%d)’"&& cat /tmp/results.txt |sed ‘s/\"//g’ > /your/wanted/file.csv;chown whatever:whatever /your/wanted/file.csv
(run the cron job as root or someone who has access to all these bits)