Salim Mail : salim.sucipto@gmail Phone : 0815-188-2384 YM : talim_bansal

1. DML – Data Manipulation Language Salim Mail : salim.sucipto@gmail.com Phone : 0815-188-2384 YM : talim_bansal Blog : http://salimsribasuki.wordpress.com

2. Overview • INSERT : Inserting records into table • UDPATE : Updating certain column of the record • DELETE : Delete or remove records from the table

3. DML - Insert • Insert record one by one: • insert into ti3k_item_master (item_code, item_name, item_uom, remark) • values ('BR001','Bearing 5mm','PCS','Bearing with size 5mm'); • Insert multiple records: • insert into ti3k_item_master (item_code, item_name, item_uom, remark) • values • ('FT001','Fitting Units','EACH','Unit for fitting'), • ('LB023','Lubricants','CAN',null), • ('CS031','Top Casing','EACH','Casing bottle');

4. Select / Query / Retreive Data • To retreive / show the data/record of the table, use: • Select * from table_name; • Example: • Select * from ti3k_item_master;

5. DML - Update • Update one column: • Update table_name • Set column_name = value • Where..... • Example: • Update ti3k_item_master • Set item_uom =‘UNIT’ • Where item_id = 2;

6. DML - Update • Update multiple column: • Update table_name • Set column_name1 = value1, column_name2 = value2 • Where..... • Example: • Update ti3k_item_master • Set creation_date = ‘2011-11-07’, created_by =‘Salim’;

7. DML - Delete Delete from table_name Where..... Example: Delete from ti3k_item_master Where item_code =‘LB023’;