SQL query help

[googleplus]

Hi,

I made a table dist_obj .

I havent put the 1st row details as i have not made any constraints on any row.

so it got left blank. So can u tell me how to update and insert to 1st row ?
and also delete it.

waiting for reply.

 

[Tango]

http://www.w3schools.com/php/php_mysql_update.asp

 

[googleplus]

bro i know this.. but

i haven't entered any data in 1st row.. so how to i compare with where clause ?

please write a query.

 

[Mr Happy]

INSERT INTO dist_obj (Dno, Dname, Daddress) VALUES (1, 'Yahoo', 'Funeral Home');

As your setting the number as 1 it will appear before Google and Bing as they are 12 and 13. You can also enter the below as an example.

INSERT INTO dist_obj (Dno, Dname, Daddress) VALUES (4, 'Ask', 'forgotten about');


You can delete yahoo as follows

DELETE FROM dis_obj WHERE Dno = 1

or as

DELETE FROM dis_obj WHERE Dname = 'Yahoo'

Hope this helps

 

[googleplus]

but @Mr Happy : I havent entered any data on first row .. as no constraints are there.

so how can i compare with where clause ?

 

[Mr Happy]

I'm sorry I don't follow you. Can you give an example of what your trying to do.

Do you mean if something doesn't exist insert something? It that what you mean?

 

[Gaurav]

OP: Usually the ID field is NOT NULL. Can you confirm that same is the case here as well or not?

 

[Halcyon]

UPDATE dist_obj SET Dno = 11, Dname = 'test', Daddress = 'testing' WHERE Dno is null;

DELETE FROM dist_obj WHERE Dno is null;

:S

 

[sww]

is it mysql or msaccess