"MySQL CLI 출력 형식 지정하기"의 두 판 사이의 차이

잔글 (로봇: 자동으로 텍스트 교체 (-[root@jmnote +[root@zetawiki))
잔글 (봇: 자동으로 텍스트 교체 (-source +syntaxhighlight))
 
(같은 사용자의 중간 판 2개는 보이지 않습니다)
3번째 줄: 3번째 줄:
==표 (기본값)==
==표 (기본값)==
;--table, -t
;--table, -t
<source lang='cli'>
<syntaxhighlight 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>
</syntaxhighlight>


== 배치 ==
== 배치 ==
;--batch, -B
;--batch, -B
<source lang='cli'>
<syntaxhighlight 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>
</syntaxhighlight>


== HTML ==
== HTML ==
;--html, -H
;--html, -H
<source lang='cli'>
<syntaxhighlight 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>
</syntaxhighlight>


==XML==
==XML==
;--xml, -X
;--xml, -X
<source lang='cli'>
<syntaxhighlight 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>
</syntaxhighlight>


==같이 보기==
==같이 보기==
*[[bash에서 MySQL 사용]]
*[[bash에서 MySQL 사용]]


==참고 자료==
==참고==
*http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html
*http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html


[[분류: MySQL]]
[[분류: MySQL]]
[[분류: Bash]]
[[분류: Bash]]

2020년 11월 2일 (월) 02:40 기준 최신판

MySQL CLI 출력 형식 지정하기

1 표 (기본값)[ | ]

--table, -t
[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
[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
[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
[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 참고[ | ]

문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}