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.

googleplus Reviewed by googleplus on 9th Feb 2012. SQL query help Hi, I made a table dist_obj . http://i39.tinypic.com/n37n6w.png 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. Rating: 5

[Gavo]

This site is using a hacked database of W junction

[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;

[sww]

is it mysql or msaccess