Re: integer
- Date: Thu, 22 May 2008 15:13:46 +0530
- From: "Krishna Chandra Prajapati" <prajapatikc@xxxxxxxxx>
- Subject: Re: integer
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 <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
>
--
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: prajapatikc@xxxxxxxxx