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]

'프로그램 사용 > mysql & mariaDB' 카테고리의 다른 글

Mariadb root access denied  (0) 2018.04.19
mysql sql문 변수 사용  (0) 2017.05.20
mysql view 출력 그리고 내용확인  (0) 2017.05.09
db varchar 와 char  (0) 2017.05.09
db에 mac / ip 저장하기(자료형)  (0) 2017.05.09
mysql innodb compress  (0) 2017.04.12
Posted by 구차니

댓글을 달아 주세요