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>
