Results 1 to 9 of 9
Hybrid View
-
9th Feb 2012, 03:30 PM #1Respected DeveloperWebsite's:
wrzc.orgINSERT 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 helpsMr 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: 5Tutorial How to SEO your Warez Site a guide to help you increase your organic traffic
Huge list of Warez Sites and free Multiposter Templates
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
PHP - CSV query
By ElitePirate in forum Web Development AreaReplies: 3Last Post: 14th Sep 2012, 02:35 PM -
OVH Query?
By BJ@008 in forum Hosting DiscussionReplies: 11Last Post: 17th Feb 2012, 03:33 PM -
FTP Upload Query
By Ryan in forum File Host DiscussionReplies: 1Last Post: 16th Jan 2012, 03:03 PM -
ddl submission query
By avRo in forum Forum and DDL DiscussionReplies: 4Last Post: 19th Nov 2011, 05:39 PM -
php mod query
By Ryan in forum phpBBReplies: 3Last Post: 28th Mar 2009, 10:49 PM
themaCreator - create posts from...
Version 3.52 released. Open older version (or...