If i am not using zerofill. Then is there any different between int(10) and
int

On Thu, May 22, 2008 at 2:23 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
>



-- 
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road, Secunderabad.
Pin Code: 500003
Office Number: 040-66489771
Mob: 9912924044
URL: ed-ventures-online.com
Email-id: [EMAIL PROTECTED]

Reply via email to