获取Mysql表的信息 show tables可以直接获取所有表有sql可以直接输入表的信息,如记录条数,类别,字符集等信息吗 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SHOW FULL FIELDS FROM 表名 show table status from `数据库名`; mysql> show table status like 't1';+------+--------+---------+------------+--------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+| 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 |+------+--------+---------+------------+--------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+| t1 | MyISAM | 10 | Fixed | 100000 | 9 | 900000 | 2533274790395903 | 1021952 | 0 | NULL | 2009-06-05 15:13:57 | 2009-06-17 12:06:40 | 2009-06-17 12:06:40 | latin1_swedish_ci | NULL | | |+------+--------+---------+------------+--------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+1 row in set (0.11 sec)mysql> windows 2008服务器下PHP环境配置,PHP版本选择 PHP显示空白的问题 诚聘网站PHP工程师 date时间函数的问题 能否用程序修改php.ini? 请问有没有开发PHP的平台? 请问本机下调试php出现以下错误是怎么回事 求问利用php curl批量下载文件的方法 送分题! 为什么用opendir打开目录用户require_once 加载文件会报错 请教,关于session_start() 后导至iis死掉的问题! php+mysql 查询速度慢
+------+--------+---------+------------+--------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
| 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 |
+------+--------+---------+------------+--------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
| t1 | MyISAM | 10 | Fixed | 100000 | 9 | 900000 | 2533274790395903 | 1021952 | 0 | NULL | 2009-06-05 15:13:57 | 2009-06-17 12:06:40 | 2009-06-17 12:06:40 | latin1_swedish_ci | NULL | | |
+------+--------+---------+------------+--------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
1 row in set (0.11 sec)mysql>