- MySQL CLI 출력 형식 지정하기
1 표 (기본값)[ | ]
- --table, -t
Console
Copy
[root@zetawiki ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;'
+--------+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------+------+---------+------+-------+------------------+
| 345227 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST |
+--------+------+-----------+------+---------+------+-------+------------------+
2 배치[ | ]
- --batch, -B
Console
Copy
[root@zetawiki ~]# 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
3 HTML[ | ]
- --html, -H
Console
Copy
[root@zetawiki ~]# 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>
4 XML[ | ]
- --xml, -X
Console
Copy
[root@zetawiki ~]# 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>
5 같이 보기[ | ]
6 참고[ | ]
편집자 Jmnote Jmnote bot
로그인하시면 댓글을 쓸 수 있습니다.