General MySQL Oracle SQL Server

Returning Query Output in HTML Format in MySQL

Q

How To Return Query Output in HTML Format in MySQL?

✍: FYIcenter.com

A

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\bin
>mysql -u root -H test

mysql> SELECT * FROM links;
<TABLE BORDER=1><TR><TH>id</TH><TH>name</TH></TR>
<TR><TD>1</TD><TD>dba.fyicenter.com</TD></TR>
<TR><TD>10</TD><TD>dba.fyicenter.com</TD></TR></TABLE>
2 rows in set (0.00 sec)

 

⇒ Returning Query Output in XML Format in MySQL

⇐ Running "mysql" Commands from a Batch File in MySQL

⇑ Command-Line End User Interface 'mysql'

⇑⇑ MySQL Database Tutorials

2018-02-08, 3727🔥, 0💬

General MySQL Oracle SQL Server