Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Return Query Output in HTML Format
How To Return Query Output in HTML Format? - MySQL FAQs - Command-Line End User Interface mysql
✍: FYIcenter.com
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)
2007-05-10, 4676👍, 0💬
Popular Posts:
How Large Can a Single Cookie Be? - PHP Script Tips - Understanding and Managing Cookies How large c...
How can we implement singleton pattern in .NET? Singleton pattern mainly focuses on having one and o...
When should the register modifier be used? Does it really help? The register modifier hints to the c...
How To Control Vertical Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By d...
What is continuous and staged representation? CMMI contains 25 key process areas which organization ...