1 / 7

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

DML – Data Manipulation Language. Salim Mail : salim.sucipto@gmail.com Phone : 0815-188-2384 YM : talim_bansal Blog : http://salimsribasuki.wordpress.com. Overview. INSERT : Inserting records into table UDPATE : Updating certain column of the record

Download Presentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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’;

More Related