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
