Click here to Skip to main content
15,921,250 members

Comments by ITSRavik (Top 1 by date)

ITSRavik 10-Dec-12 8:13am View    
Empty field goes in table due to use same query syntax, Suppose I have a query like
Insert into MyTable (MyName, MyAddress, MyPhone)values ('ABC', 'xyz', '1234567890')
it's stored all data, but I have partial data (Name and Address)now I enter this data using same query like-
Empty field goes in table due to use same query syntax, Suppose I have a query like
Insert into MyTable (MyName, MyAddress, MyPhone)values ('ABC', 'xyz', '')
now what happen, Phone no. is saved as a Empty.
So My Question is that-
This empty field occupied any space or make any Impact in database performace.
Please help me.

Thanks
Ravik