Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

MySQL Add comments

Jan 162010

How to format MySQL output as HTML

Answer:

If you want MySQL to return query result as HTML format, you can use the -H option

# mysql -H -e 'select now()' -u root 
<TABLE BORDER=1><TR><TH>now()</TH></TR><TR><TD>2010-01-16 20:30:45
</TD></TR></TABLE>