"MySQL information schema"의 두 판 사이의 차이

2016년 3월 29일 (화) 10:44 기준 최신판

1 개요[ | ]

MySQL information_schema

mysql> SHOW TABLES FROM information_schema;
+---------------------------------------+
| Tables_in_information_schema          |
+---------------------------------------+
| CHARACTER_SETS                        |
| COLLATIONS                            |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS                               |
| COLUMN_PRIVILEGES                     |
| ENGINES                               |
| EVENTS                                |
| FILES                                 |
| GLOBAL_STATUS                         |
| GLOBAL_VARIABLES                      |
| KEY_COLUMN_USAGE                      |
| PARTITIONS                            |
| PLUGINS                               |
| PROCESSLIST                           |
| PROFILING                             |
| REFERENTIAL_CONSTRAINTS               |
| ROUTINES                              |
| SCHEMATA                              |
| SCHEMA_PRIVILEGES                     |
| SESSION_STATUS                        |
| SESSION_VARIABLES                     |
| STATISTICS                            |
| TABLES                                |
| TABLE_CONSTRAINTS                     |
| TABLE_PRIVILEGES                      |
| TRIGGERS                              |
| USER_PRIVILEGES                       |
| VIEWS                                 |
+---------------------------------------+
28 rows in set (0.00 sec)

2 같이 보기[ | ]

@@ 2번째 줄: / 2번째 줄: @@
 ;MySQL information_schema
-<source lang='cli'>
+<source lang='console'>
 mysql> SHOW TABLES FROM information_schema;
 +---------------------------------------+
@@ 43번째 줄: / 43번째 줄: @@
 *[[MySQL information_schema.COLUMNS]]
-[[분류: MySQL]]
+[[분류: MySQL information_schema]]