存储长度 范围
tinyint 0-255 (注意:没有负数)                                                                            8位/1个字节
int -32,768-32,767 (5位数)                                                                            16位/2个字节
smallint -2,147,483,648-2,147,483,647 (10位数) 32位/4个字节
bigint -9,223,327,036,854,775,808-9,223,327,036,854,775,807 (19位数) 64位/8个字节

年龄字段:用tinyint就够了吧。

posted on 2013-03-10 09:28  dianyitongxiao  阅读(178)  评论(0编辑  收藏  举报