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, 4616👍, 0💬
Popular Posts:
I have 5 questions please give me the answer ,explanation,suggestions if any?? what is PMP(project m...
How To Control Horizontal Alignment? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells By...
What is the output of printf("%d")? 1. When we write printf("%d",x); this means compiler will print ...
Can you explain in brief how the ASP.NET authentication process works? ASP.NET does not run by itsel...
What are the different storage classes in C? C has three types of storage: automatic, static and all...