Producing XML output_MariaDB Cookbook-QQ阅读男生都市网

上QQ阅读APP看书，第一时间看更新

Producing XML output

The mysql command-line client has several different output options. One of these is XML.

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. This file has the same name and contents as the file used in the previous recipe. If we've already completed that recipe, we can just reuse the same file.

How to do it...

Open a terminal and navigate to where we saved the isfdb-001.sql file.
Issue the following command on the command line (not from within the mysql command-line client, but by calling the client with some special options):
```
mysql --xml isfdb < isfdb-001.sql > isfdb-001.xml
```
Execute either a dir or ls command and we'll see that there is now a file named isfdb-001.xml in the directory.
To see the contents of the file, open it with our favorite text editor or an XML viewer.

How it works...

When the --xml flag is passed on the command line, the mysql command-line client will output a well-formed XML file, instead of a regular output.

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.xml file, respectively.