편집을 취소할 수 있습니다. 이 편집을 되돌리려면 아래의 바뀐 내용을 확인한 후 게시해주세요.
최신판 | 당신의 편집 | ||
3번째 줄: | 3번째 줄: | ||
==표 (기본값)== | ==표 (기본값)== | ||
;--table, -t | ;--table, -t | ||
< | <source lang='console'> | ||
[root@zetawiki ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;' | [root@zetawiki ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;' | ||
+--------+------+-----------+------+---------+------+-------+------------------+ | +--------+------+-----------+------+---------+------+-------+------------------+ | ||
10번째 줄: | 10번째 줄: | ||
| 345227 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST | | | 345227 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST | | ||
+--------+------+-----------+------+---------+------+-------+------------------+ | +--------+------+-----------+------+---------+------+-------+------------------+ | ||
</ | </source> | ||
== 배치 == | == 배치 == | ||
;--batch, -B | ;--batch, -B | ||
< | <source lang='console'> | ||
[root@zetawiki ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;' -B | [root@zetawiki ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;' -B | ||
Id User Host db Command Time State Info | Id User Host db Command Time State Info | ||
345224 root localhost NULL Query 0 NULL SHOW PROCESSLIST | 345224 root localhost NULL Query 0 NULL SHOW PROCESSLIST | ||
</ | </source> | ||
== HTML == | == HTML == | ||
;--html, -H | ;--html, -H | ||
< | <source lang='console'> | ||
[root@zetawiki ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;' -H | [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> | <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> | ||
</ | </source> | ||
==XML== | ==XML== | ||
;--xml, -X | ;--xml, -X | ||
< | <source lang='console'> | ||
[root@zetawiki ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;' -X | [root@zetawiki ~]# mysql -uroot -pP@ssw0rd -e 'SHOW PROCESSLIST;' -X | ||
<?xml version="1.0"?> | <?xml version="1.0"?> | ||
45번째 줄: | 45번째 줄: | ||
</row> | </row> | ||
</resultset> | </resultset> | ||
</ | </source> | ||
==같이 보기== | ==같이 보기== |