DML : DATA MANIPULATION LANGUAGE

DML : DATA MANIPULATION LANGUAGE ( DATA LEVEL OPERATIONS PERFORMED)

INSERT 
UPDATE 
DELETE 
MERGE

INSERT 

Its used to insert the values in the tables.

Syntax: 

INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)  
VALUES (value1, value2, value3,...valueN);

INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);

INSERT ALL
  INTO mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
  INTO mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
  INTO mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
SELECT * FROM dual;

-- if using INSERT ALL statement means its ends with DUAL; 

UPDATE 

--old records is replced by new records 

UPDATE TABLE_NAME SET COLUMN_NAME = 'NEW DATA' WHERE COLUMN_NAME = 'OLD DATA'; syntax

UPDATE course SET Cname= 'Parthi' WHERE Cname = 'Karthi'; -- 'karthi' is replaced  with 'parthi'

UPDATE course SET Cid=100,Cname='Arthi' WHERE Cname= 'karthi'; - karthi cname is replaced with arthi and cid is also change into 100

UPDATE course SET Cid=10; if without mentioning WHERE Clause it will update all the column.

DELETE

DELETE FROM table_name; -- Syntax Its DELETE all records in the table. 

-- if mentioning without where condition in DELETE statement all records will be deleted.

DELETE FROM course WHERE Cname='parthi' -- the cname contains parthi column is deleted from the table .