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]