Re: integer
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 <glynastill@xxxxxxxxxxx> 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 <prajapatikc@xxxxxxxxx>
> > To: MYSQL General List <mysql@xxxxxxxxxxxxxxx>
> > 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/mysql?unsub=yueliangdao0608@xxxxxxxxx
>
>
--
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn