mysql view 출력 그리고 내용확인

mysql client로 콘솔에서 접속해서 보니..

걍.. table로 나온다.

mysql> show tables; +-------------------+ | Tables_in_archlog | +-------------------+ | account_bank      | | account_periodic  | | account_withdraw  | | arch_article      | | arch_blobs        | | arch_refer        | | arch_rel          | | arch_reply        | | arch_user         | | org_detail        | | org_rel           | | organization      | | people_detail     | | people_rel        | +-------------------+ 14 rows in set (0.00 sec)

mysql> desc organization; +---------------+-----------+------+-----+---------+-------+ | Field         | Type      | Null | Key | Default | Extra | +---------------+-----------+------+-----+---------+-------+ | idx           | int(11)   | NO   |     | 0       |       | | name_kr       | char(50)  | YES  |     | NULL    |       | | name_en       | char(30)  | YES  |     | NULL    |       | | address       | char(200) | YES  |     | NULL    |       | | call_1        | char(30)  | YES  |     | NULL    |       | | fax           | char(30)  | YES  |     | NULL    |       | | web           | char(50)  | YES  |     | NULL    |       | | certification | char(20)  | YES  |     | NULL    |       | | time_create   | datetime  | YES  |     | NULL    |       | +---------------+-----------+------+-----+---------+-------+ 9 rows in set (0.01 sec)

그나저나 저 \G의 차이가 크게 나오네..

mysql> show create view organization\G;

얘는 걍.. +--- 이런거 도배 됨

mysql> show create view organization;

[링크 : https://dev.mysql.com/doc/refman/5.7/en/show-create-view.html]

\g는 vertical output 인가?

--auto-vertical-output Cause result sets to be displayed vertically if they are too wide for the current window, and using normal tabular format otherwise. (This applies to statements terminated by ; or \G.)

[링크 : https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html]

+

full 하나 넣어주니 깔끔하게 구분이 되는군!

mysql> show full tables; +-------------------+------------+ | Tables_in_archlog | Table_type | +-------------------+------------+ | account_bank      | BASE TABLE | | account_periodic  | BASE TABLE | | account_withdraw  | BASE TABLE | | arch_article      | BASE TABLE | | arch_blobs        | BASE TABLE | | arch_refer        | BASE TABLE | | arch_rel          | BASE TABLE | | arch_reply        | BASE TABLE | | arch_user         | BASE TABLE | | org_detail        | BASE TABLE | | org_rel           | BASE TABLE | | organization      | VIEW       | | people_detail     | BASE TABLE | | people_rel        | BASE TABLE | +-------------------+------------+ 14 rows in set (0.01 sec)

[링크 : https://dev.mysql.com/doc/refman/5.7/en/show-tables.html]