Discussion: INSERT QUERY
Afficher un message
Vieux 29/08/2007, 11h11   #1
Krishna Chandra Prajapati
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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

  Réponse avec citation
 
Page generated in 0,05379 seconds with 9 queries