格式

SELECT [字段] FROM [表名] PROCEDURE ANALYSE()

实例

SELECT * FROM `dkp_itemcache` PROCEDURE ANALYSE()

返回结果

Field_nameMin_valueMax_valueMin_lengthMax_lengthEmpties_or_zerosNullsAvg_value_or_avg_lengthStd建议字段类型
字段名最小值最大值最小长度最大长度空或零(暂时还不懂意思)空值?平均值或平均长度192044.5288INT(8) UNSIGNED NOT NULL
iedkpsql.dkp_itemcache.id47929289881380014645180.0000192044.5288INT(8) UNSIGNED NOT NULL
iedkpsql.dkp_itemcache.itemid00112928940300.00000.0000ENUM('0') NOT NULL
iedkpsql.dkp_itemcache.name法术能量之戒T2头1115580015.4163nullTINYTEXT NOT NULL
iedkpsql.dkp_itemcache.link 002928940300.0000nullCHAR(0) NOT NULL
iedkpsql.dkp_itemcache.quality 002928940300.0000nullCHAR(0) NOT NULL
iedkpsql.dkp_itemcache.icon 002928940300.0000nullCHAR(0) NOT NULL

标签: none

添加新评论