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

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 <prajapatikc@gmail.com> 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
>

Hi Anand,

Is there any other way it effects the queries.

Regards,
Krishna

On 8/29/07, Ananda Kumar <anandkl@gmail.com> 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 <prajapatikc@gmail.com> 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

No, i dont see any other effect.

On 8/29/07, Krishna Chandra Prajapati <prajapatikc@gmail.com> wrote:
>
> Hi Anand,
>
> Is there any other way it effects the queries.
>
> Regards,
> Krishna
>
> On 8/29/07, Ananda Kumar < anandkl@gmail.com> 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 <prajapatikc@gmail.com > 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