| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Krishna Chandra Prajapati | Date: | August 29 2007 12:11pm |
| Subject: | INSERT QUERY | ||
| View as plain text | |||
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
| Thread | ||
|---|---|---|
| • INSERT QUERY | Krishna Chandra Prajapati | 29 Aug |
| • Re: INSERT QUERY | Ananda Kumar | 29 Aug |
| • Re: INSERT QUERY | Krishna Chandra Prajapati | 29 Aug |
| • Re: INSERT QUERY | Ananda Kumar | 29 Aug |
