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>
版权声明：本文为博主原创文章，未经博主允许不得转载。