设为首页收藏本站
查看: 56|回复: 0

[PHP] MySQL获取表格信息_MySQL

[复制链接]

论坛元老

Rank: 6Rank: 6

积分
34274
主题
17031
UID
1347
M币
67
贡献
17176

  • 发表于 2015-9-16 16:18:06 | 显示全部楼层 |阅读模式
    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>
    回复

    使用道具 举报

    您需要登录后才可以回帖 登录 | 立即注册

    本版积分规则

    在我站开通SVIP可同时获得17个站点VIP资源 立即登录 立即注册
    快速回复 返回顶部 返回列表