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, 4748👍, 0💬
Popular Posts:
What are the core functionalities in XML .NET framework? Can you explain in detail those functionali...
How do we access attributes using “XmlReader”? Below snippets shows the way to access attributes. Fi...
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, ...
Give me the example of SRS and FRS SRS :- Software Requirement Specification BRS :- Basic Requiremen...
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, ...