查看MYSQL Tips的源代码
←
MYSQL Tips
跳转到:
导航
,
搜索
因为以下原因,你没有权限编辑本页:
您刚才请求的操作只有这个用户组中的用户才能使用:
用户
您可以查看并复制此页面的源代码:
== 查看数据表属性 == <source lang=bash> mysql> desc users; +------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+----------------+ | id | int(11) | NO | UNI | NULL | auto_increment | | user_id | varchar(64) | NO | PRI | NULL | | | passwd | varchar(64) | YES | | NULL | | | user_alias | varchar(64) | YES | | NULL | | | email | varchar(64) | YES | | NULL | | | cellphone | varchar(16) | YES | | NULL | | | producer | tinyint(1) | NO | | 0 | | | app_id | varchar(64) | YES | | NULL | | | app_sec | varchar(64) | YES | | NULL | | +------------+-------------+------+-----+---------+----------------+ 9 rows in set (0.00 sec) mysql> show table status from YOUR_DB_NAME like 'TABLE_NAME'; +------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+ | 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 | +------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+ | datapoints | MyISAM | 10 | Dynamic | 136 | 54 | 7404 | 281474976710655 | 28672 | 0 | 167 | 2015-01-09 00:36:01 | 2015-01-15 12:42:26 | 2015-01-09 00:36:01 | utf8_general_ci | NULL | | | +------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+ 1 row in set (0.00 sec) </source> <br><br>
返回到
MYSQL Tips
。
个人工具
登录
名字空间
页面
讨论
变换
查看
阅读
查看源代码
查看历史
操作
搜索
导航
首页
社区专页
新闻动态
最近更改
随机页面
帮助
工具箱
链入页面
相关更改
特殊页面