|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
29/08/2007, 12h11
|
#1 |
Messages: n/a
Hébergeur: |
INSERT QUERY
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 |
|
|
29/08/2007, 12h20
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: INSERT QUERY
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 > |
|
|
|
29/08/2007, 12h28
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: INSERT QUERY
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 |
|
|
|
29/08/2007, 12h59
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: INSERT QUERY
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 |
|
|
 |
| Outils de la discussion | |
|
|
