MySQL CLI 출력 형식 지정하기

MySQL CLI 출력 형식 지정하기

1 출력형태

표(--table, -t, 기본값)

[root@jmnote ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;'
+--------+------+-----------+------+---------+------+-------+------------------+
| Id     | User | Host      | db   | Command | Time | State | Info             |
+--------+------+-----------+------+---------+------+-------+------------------+
| 345227 | root | localhost | NULL | Query   |    0 | NULL  | SHOW PROCESSLIST | 
+--------+------+-----------+------+---------+------+-------+------------------+

배치(--batch, -B)

[root@jmnote ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;' -B
Id	User	Host	db	Command	Time	State	Info
345224	root	localhost	NULL	Query	0	NULL	SHOW PROCESSLIST

html(--html, -H)

[root@jmnote ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;' -H
<TABLE BORDER=1><TR><TH>Id</TH><TH>User</TH><TH>Host</TH><TH>db</TH><TH>Command</TH><TH>Time</TH><TH>State</TH><TH>Info</TH></TR><TR><TD>345240</TD><TD>root</TD><TD>localhost</TD><TD>NULL</TD><TD>Query</TD><TD>0</TD><TD>NULL</TD><TD>SHOW PROCESSLIST</TD></TR></TABLE>

XML(--xml, -X)

[root@jmnote ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;' -X
<?xml version="1.0"?>

<resultset statement="SHOW PROCESSLIST" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <row>
	<field name="Id">345242</field>
	<field name="User">root</field>
	<field name="Host">localhost</field>
	<field name="db" xsi:nil="true" />
	<field name="Command">Query</field>
	<field name="Time">0</field>
	<field name="State" xsi:nil="true" />
	<field name="Info">SHOW PROCESSLIST</field>
  </row>
</resultset>

2 같이 보기

• bash에서 MySQL 사용

3 참고 자료

• http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html