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>

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网

TAG标签：表格信息