程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> MySQL綜合教程 >> MySQL獲取表格信息

MySQL獲取表格信息

編輯:MySQL綜合教程

MySQL獲取表格信息


MySQL獲取表格信息

mysql> use test;
Database changed
mysql> show table status;
+---------------+--------+---------+------------+------+----------------+-------
------+-----------------+--------------+-----------+----------------+-----------
----------+-------------+------------+-----------------+----------+-------------
---+---------+
| Name          | Engine | Version | Row_format | Rows | Avg_row_length | Data_l
ength | Max_data_length | Index_length | Data_free | Auto_increment | Create_tim
e         | Update_time | Check_time | Collation       | Checksum | Create_optio
ns | 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>

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved