List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:August 29 2007 10:11am
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 QUERYKrishna Chandra Prajapati29 Aug
  • Re: INSERT QUERYAnanda Kumar29 Aug
    • Re: INSERT QUERYKrishna Chandra Prajapati29 Aug
      • Re: INSERT QUERYAnanda Kumar29 Aug