How To Return Query Output In HTML Format

How To Return Query Output In HTML Format


  • 8 Mar, 2012

    By default, "mysql" returns query output in text table format. If you want to receive query output in HTML format, you need to use the "-H" command option. Here is a good tutorial exercise:>cd mysql in>mysql -u root -H testmysql> SELECT * FROM links;<TABLE BORDER=1><TR><TH>id</TH><TH>name</TH></TR><TR><TD>1</TD><TD>www.GlobalGuideLine.com</TD></TR><TR><TD>10</TD><TD>www.GlobalGuideLine.com</TD></TR></TABLE>2 rows in set (0.00 sec)

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.