MySQL获取表格信息_MySQL
- WBOY原创
- 2016-05-30 17:11:111040浏览
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>
声明：
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn