MySQL擷取表格資訊

標籤：mysql   擷取表格資訊   

MySQL擷取表格資訊

mysql> use test;Database changedmysql> 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 |+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+| emp           | InnoDB |      10 | Compact    |    0 |              0 |16384 |               0 |            0 |         0 |           NULL | 2015-09-16 16:18:06 | NULL        | NULL       | utf8_general_ci |     NULL |   |         || stu_view      | NULL   |    NULL | NULL       | NULL |           NULL | NULL |            NULL |         NULL |      NULL |           NULL | NULL          | NULL        | NULL       | NULL            |     NULL | NULL   | VIEW    || t_depart_info | InnoDB |      10 | Compact    |    0 |              0 |16384 |               0 |            0 |         0 |           NULL | 2015-08-23 22:12:02 | NULL        | NULL       | utf8_general_ci |     NULL |   |         || t_stu_info    | InnoDB |      10 | Compact    |    6 |           2730 |16384 |               0 |            0 |         0 |              9 | 2015-08-23 21:36:02 | NULL        | NULL       | utf8_general_ci |     NULL |   |         || t_tea_info    | InnoDB |      10 | Compact    |    0 |              0 |16384 |               0 |        16384 |         0 |              1 | 2015-08-23 21:39:53 | NULL        | NULL       | utf8_general_ci |     NULL |   |         |+---------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+5 rows in set (0.00 sec)mysql>

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。

MySQL擷取表格資訊