Sign in or 

satyanan |
Latest page update: made by satyanan
, Oct 30 2009, 3:49 AM EDT
(about this update
About This Update
Edited by satyanan
No content added or deleted. - complete history) |
|
Keyword tags:
rdbms
More Info: links to this page
|
| Started By | Thread Subject | Replies | Last Post | ||
|---|---|---|---|---|---|
| satyanan | ABOUT DML COMMANDS | 0 | Oct 30 2009, 3:59 AM EDT by satyanan | ||
|
Thread started: Oct 30 2009, 3:59 AM EDT
Watch
THE DML COMMADS ARE AS FOLLOWS
1.<INSERT> 2.<UPDATE> 3.<DELETE> SO WE CAN USE THE FOLLOWING COMMANDS ARE AS FOLLOES AND BELOW GIVEN THEIR SYNTAXES: 1.<INSERT>:THE COMMAND IS USED FOR INSERTING ROWS INTO TABLE SYNTAX:INSERT INTO <TABLENAME> VALUES (COLUMN1,---------------------COLUMNN); EXAMPLE:INSERT INTO RAJESH VALUES('RAJSH',093); 2.<DELETE>:THE COMMAND IS USED FOR DELETE ALL ROWS OF ATABLE. SYNTAX:DELETE FROM TABLENAME; EX:DELETE FROM RAJESH; 3.UPDATE:THIS COMMAND IS USED FOR UPDATE YOUR TABLE. SYNTAX:UPDATE <TABLENAME> SET COLUMNNAME= DATA; EX:UPDATE RAJESH SET NAME=RAJA;
1
out of
1 found this valuable.
Do you?
Keyword tags:
rdbms
|
|||||