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
Mr Happy Reviewed by Mr Happy on . 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