Guardando salida de un query en HTML

mysql  -H -e  " select * from asterisk.cdr limit 0,1" -p1234 > /var/www/cdr.html

Luego podemos acceder desde la web

http://75.11.118.23/cdr.html

id_call	calldate	clid	src	dst	dcontext	channel	dstchannel	lastapp	lastdata	duration	billsec	disposition	amaflags	accountcode	uniqueid	userfield	unixtime
138594	2015-04-11 02:10:52	"919859582174" <919859582174>	919859582174	s	contest	SIP/con1-0000122a		Playback	/var/lib/asterisk/sounds/contest/main	1	1	ANSWERED	3		1428732652.13950		0