默认是-t输出1、表格输出 -t [root@UAA1 ~]# 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 [root@UAA1 ~]# 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 test3、垂直输出 --vertical [root@UAA1 ~]# mysql -u root -pDtDream0209 -e 'show databases' --vertical Warning: Using a password on the command line interface can be insecure.1. row Database: information_schema2. row Database: alarms3. row Database: datariver4. row Database: datariver_new5. row Database: dop_monitor6. row Database: dop_users7. row Database: falcon_portal8. row Database: mysql9. row Database: performance_schema10. row Database: test
4、html格式输出 --html [root@UAA1 ~]# 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>[root@UAA1 ~]#
5、xml格式输出 --xml [root@UAA1 ~]# 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">; <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>
