mysql的output输出格式

默认是-t输出
1、表格输出 -t
[ ~]# mysql -u root -pXXXX -e ‘show databases‘ -t
Warning: Using a password on the command line interface can be insecure.
+--------------------+
| Database |
+--------------------+
| information_schema |
| alarms |
| falcon_portal |
| mysql |
| performance_schema |
| test |
+--------------------+
2、批处理输出--batch 或-B
[ ~]# mysql -u root -pXXXX -e ‘show databases‘ -B
Warning: Using a password on the command line interface can be insecure.
Database
information_schema
alarms
falcon_portal
mysql
performance_schema
test
3、垂直输出 --vertical
[ ~]# mysql -u root -pDtDream0209 -e ‘show databases‘ --vertical
Warning: Using a password on the command line interface can be insecure.
1. row
Database: information_schema
2. row
Database: alarms
3. row
Database: datariver
4. row
Database: datariver_new
5. row
Database: dop_monitor
6. row
Database: dop_users
7. row
Database: falcon_portal
8. row
Database: mysql
9. row
Database: performance_schema
10. row
Database: test

4、html格式输出 --html
[ ~]# mysql -u root -pXXXX -e ‘show databases‘ --html
Warning: Using a password on the command line interface can be insecure.
<TABLE BORDER=1><TR><TH>Database</TH></TR><TR><TD>information_schema</TD></TR><TR><TD>alarms</TD></TR><TR><TD>datariver</TD></TR><TR><TD>datariver_new</TD></TR><TR><TD>dop_monitor</TD></TR><TR><TD>dop_users</TD></TR><TR><TD>falcon_portal</TD></TR><TR><TD>mysql</TD></TR><TR><TD>performance_schema</TD></TR><TR><TD>test</TD></TR></TABLE>[ ~]#

5、xml格式输出 --xml
[ ~]# mysql -u root -pXXXX -e ‘show databases‘ --xml
Warning: Using a password on the command line interface can be insecure.
<?xml version="1.0"?>

<resultset statement="show databases
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;
<row>
<field name="Database">information_schema</field>
</row>

<row>
<field name="Database">alarms</field>
</row>

<row>
<field name="Database">datariver</field>
</row>

<row>
<field name="Database">datariver_new</field>
</row>

<row>
<field name="Database">dop_monitor</field>
</row>

<row>
<field name="Database">dop_users</field>
</row>

<row>
<field name="Database">falcon_portal</field>
</row>

<row>
<field name="Database">mysql</field>
</row>

<row>
<field name="Database">performance_schema</field>
</row>

<row>
<field name="Database">test</field>
</row>
</resultset>