If you didn't define zerofill int is equal to int(11) if the actual variable is 59,then all display 59.
On Thu, May 22, 2008 at 4:53 PM, Glyn Astill <[EMAIL PROTECTED]> wrote: > int(10) will pad with zeros on return, i.e. if value = 59 > > int(10) 0000000059 > int 59 > > ----- Original Message ---- > > From: Krishna Chandra Prajapati <[EMAIL PROTECTED]> > > To: MYSQL General List <mysql@lists.mysql.com> > > Sent: Thursday, 22 May, 2008 9:34:55 AM > > Subject: integer > > > > Hi, > > > > I would to know the difference between the two > > > > int(10) and int (Used in create table ) Which one is better and why. > > > > Regards, > > -- > > Krishna Chandra Prajapati > > MySQL DBA, > > > > __________________________________________________________ > Sent from Yahoo! Mail. > A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn