2013年8月1日
MySql 显示表结构信息.
摘要： SELECT column_name AS `列名`, data_type AS `数据类型`, character_maximum_length AS `字符长度`, numeric_precision AS `数字长度`, numeric_scale AS `小数位数`, is_nullable AS `是否允许非空`, CASE WHEN extra = 'auto_increment' THEN 1 ELSE 0 END AS `是否自增`,column_default AS `默认值`, column_comment AS `备注` FROM Information_ 阅读全文
posted @ 2013-08-01 00:33 bert.zeng 阅读(185) 评论(0) 推荐(0)