No, i dont see any other effect.
On 8/29/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi Anand,
>
> Is there any other way it effects the queries.
>
> Regards,
> Krishna
>
> On 8/29/07, Ananda Kumar < [EMAIL PROTECTED]> wrote:
> >
> > Its all ways better to use integers without quotes. It would effect
> > execution plan of the sql.
> >
> > regards
> > anandkl
> >
> >
> > On 8/29/07, Krishna Chandra Prajapati <[EMAIL PROTECTED] > wrote:
> > >
> > > hi all,
> > >
> > > create table stu (name varchar(20), roll int(2), id decimal(2));
> > >
> > > insert into stu values ('krishna', '25', '25');
> > > insert into stu values ('krishna', 25, 25);
> > >
> > > The above two queries are working properly.
> > > my question is whether it is going to impact in future.
> > > Integer and decimal values in quotes (') and without quotes makes any
> > > difference.
> > > Normally which format should be used.
> > >
> > > Regards,
> > > Krishna
> > >
> >
> >
>
>
> --
> Krishna Chandra Prajapati
> MySQL DBA,
>
> Ed Ventures e-Learning Pvt. Ltd,
> 201,202, Ashoka Bhoopal Chambers,
> S P Road, Secunderabad 500003.
> Ph. No. - 040-39188771
> Url: www.ed-ventures-online.com
