MySQL SHOW TABLE STATUS

1 개요[ | ]

MySQL SHOW TABLE STATUS
Console
Copy
mysql> SHOW TABLE STATUS;
+---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------------------------------------------------+
| Name                      | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length    | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time          | Collation         | Checksum | Create_options | Comment                                           |
+---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------------------------------------------------+
| columns_priv              | MyISAM |      10 | Fixed      |    0 |              0 |           0 | 227994731135631359 |         4096 |         0 |           NULL | 2012-08-30 14:30:23 | 2014-09-09 07:36:56 | 2014-09-09 07:36:56 | utf8_bin          |     NULL |                | Column privileges                                 |
| db                        | MyISAM |      10 | Fixed      |    3 |            440 |        1320 | 123848989752688639 |         5120 |         0 |           NULL | 2012-08-30 14:30:23 | 2015-11-26 15:08:34 | 2014-09-09 07:36:56 | utf8_bin          |     NULL |                | Database privileges                               |
| event                     | MyISAM |      10 | Dynamic    |    0 |              0 |           0 |    281474976710655 |         2048 |         0 |           NULL | 2012-08-30 14:30:24 | 2014-09-09 07:36:56 | 2014-09-09 07:36:56 | utf8_general_ci   |     NULL |                | Events                                            |
... (생략)
| user                      | MyISAM |      10 | Dynamic    |   13 |             85 |        1112 |    281474976710655 |         2048 |         0 |           NULL | 2012-08-30 14:30:23 | 2015-11-26 15:08:34 | 2014-09-09 07:36:56 | utf8_bin          |     NULL |                | Users and global privileges                       |
+---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------------------------------------------------+
23 rows in set (0.00 sec)
2 같이 보기[ | ]
