- MariaDB Cookbook
- Daniel Bartholomew
- 438字
- 2021-07-16 12:19:25
Producing HTML output
The mysql command-line client has several different output options. One of these is HTML.
Getting ready
Import the ISFDB database as described in the Importing the data exported by mysqldump recipe in this chapter. Create a file called isfdb-001.sql using the following command line:
SELECT * FROM authors LIMIT 100;
We could put whatever commands we want in this file, or give it a different name, but this works for the purposes of this recipe.
How to do it...
- Open a terminal and navigate to where we saved the
isfdb-001.sqlfile. - Issue the following command on the command line (not from within the
mysqlcommand-line client, but by calling the client with some special options):mysql --html isfdb < isfdb-001.sql > isfdb-001.html - Execute either a
dirorlscommand and we'll see that now there is a file namedisfdb-001.htmlin the directory. - We can now either open the newly created
isfdb-001.htmlfile in our favorite text editor, or view it in a web browser, such as Firefox, Chrome, or Opera.
How it works...
When the --html flag is passed on the command line, the mysql command-line client will spit out an HTML table instead of a regular output; no headers, footers, or DOCTYPE, just a table with the results as one long string.
On the command line, we use the < and > redirectors to read in the isfdb-001.sql file and then to direct the output to the isfdb-001.html file, respectively.
There's more...
The HTML output that the mysql command-line client produces is not pretty. What's more, it's not a completely valid HTML file as there's no DOCTYPE, no <head> section, no <body> section, no <title>, and so on. The file we created begins with a <TABLE> tag and ends with a closing </TABLE> tag. And yes, all the tags use the old uppercase style of writing HTML code.
In Linux, there is an easy way to remedy this using the Tidy program. If it is not already installed, it is easy to do so using our package manager. To clean up our HTML, add spaces and indentation, change the case of the tags to lowercase, and add a DOCTYPE and all the necessary sections. We will simply modify our recipe to the following command line:
mysql --html isfdb < isfdb-001.sql | tidy -q -i -o isfdb-001.html
Tidy will detect the appropriate DOCTYPE, change the case of the tags, indent the code, and add in the missing sections.
Of course, even tidied up, HTML output is of limited use. It is, however, something the mysql command-line client can do.
- Linux網絡程序設計：基于龍芯平臺
- Apache Karaf Cookbook
- ASP.NET 3.5程序設計與項目實踐
- Scala謎題
- Unity Game Development Scripting
- SQL Server 2016數據庫應用與開發
- Learning FuelPHP for Effective PHP Development
- Visual Basic程序設計
- Spring核心技術和案例實戰
- Android傳感器開發與智能設備案例實戰
- 現代C：概念剖析和編程實踐
- Python Digital Forensics Cookbook
- Visual C++程序設計與項目實踐
- Implementing Microsoft Dynamics NAV（Third Edition）
- 基于JavaScript的WebGIS開發