我有一个HTML表单，我需要获取相应MySQL数据库中每个字段的最大设置长度 为我的文本字段的maxlength属性设置适当的值。 有一个MySQL查询会给我那些设置的最大字段长度吗？
我的最佳解决方案是查询 SHOW COLUMNS FROM {database name} ，但是 将返回括号中具有最大字段长度的字段类型（例如int（6），varchar（20），decimal（5,1）等），那么我将使用PHP或其他东西来过滤掉只有 最大长度，似乎必须有更好的方法。
I have an HTML form that I need to get the maximum set length of each of my fields in the corresponding MySQL database to set a proper value for the maxlength attribute of my text fields. Is there a MySQL query that will give me those set maximum field lengths?
The best solution I have is to query SHOW COLUMNS FROM {database name}, but that will return the field type with the maximum field length in parentheses (e.g. int(6), varchar(20), decimal(5,1), etc.), so then I would to use PHP or something to filter out only the maximum lengths, and there just seems like there's got to be a better way.
微信扫一扫
