1 / 9

Data Manipulation Language (DML)

Data Manipulation Language (DML). Pertemuan 3. Data Manipulation Language (DML). INSERT insert berfungsi untuk menambah niali pada suatu tabel. Contoh sintak insert into namatabel values (‘value1’, ‘value2’,’ ...’). Data Manipulation Language (DML). UPDATE

alika
Download Presentation

Data Manipulation Language (DML)

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. Data Manipulation Language (DML) Pertemuan 3

  2. Data Manipulation Language (DML) INSERT insert berfungsi untuk menambah niali pada suatu tabel. Contoh sintak • insert into namatabel values (‘value1’, ‘value2’,’ ...’)

  3. Data Manipulation Language (DML) • UPDATE Berfungsi untuk merubah record atau nilai didalam suatu kolom Contoh sintak Update namatabel SET namakolom = recordbaru where kondisi

  4. Data Manipulation Language (DML) DELETE Menghapus record atau nilai didalam suatu kolom pada tabel tertentu Contoh sintak DELETE namakolom from namatabel where kondisi

  5. Data Manipulation Language (DML) • SELECT select adalah perintah yang di gunakan untuk menampilkan nilai atau recor yang di pilih. Contoh sintak select namakolom from namatabel

  6. Data Manipulation Language (DML)

  7. Data Manipulation Language (DML)

  8. Data Control Language (DCL) • GRANT grant berfungsiuntukmemberikanizinakseskepadapengguna Contohsintak Grant privilages on namatabel to namapengguna artinyamemberikanizinakseskepadanamapengguna

  9. Data Control Language (DCL) • REVOKE yaitu untuk mencabut izin akses kepada pengguna yang telah di beri izin akses Contoh sintak REVOKE privileges ON namatabel from namapengguna

More Related