1 / 5

EXERCISE DML Part I

EXERCISE DML Part I. Buatlah sebuah tabel baru nama = Dosen kolom = nik, nama,gelardpn,gelarblkg, jenkel,tgllahir,alamat,notelp. primary key  nik * type data Anda tentukan sendiri dan disesuaikan * jenis masukan data “not null / null” Anda tentukan sendiri. INSERT.

alaura
Download Presentation

EXERCISE DML Part I

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. EXERCISEDML Part I Buatlah sebuah tabel baru nama = Dosen kolom = nik, nama,gelardpn,gelarblkg, jenkel,tgllahir,alamat,notelp. primary key  nik * type data Anda tentukan sendiri dan disesuaikan * jenis masukan data “not null / null” Anda tentukan sendiri

  2. INSERT • Isikan data ke dalam tabel tersebut ( 5 record/baris ) * Data masing2 record diusahakan jangan sama, tetapi beraneka macam

  3. INSERT • Bandingkan syntak query berikut : 3. a insert into dosen (nik,nama,tgllahir,jenkel) values (‘190222,’mardhiya’,’1978/07/25’,’P’) DENGAN 3. b insert into dosen values (‘190333’,’Hayaty’,’Ir’,’M.Kom’,’P’,’2005/01/01’,’jl.kenari 20 yogyakarta’,’0274884201’) DENGAN 3. c  insert into dosen values (‘190444’,’Tedjo’,’jl. Mawar no 20 A’) Ambil kesimpulan dari latihan diatas

  4. UPDATE • Lakukan perubahan data terhadap data yang sudah anda entrikan di tabel dengan query berikut : 4.a  UPDATE dosen set nama=‘Mardhiya hayaty’ WHERE nama=‘mardhiya’  lihat perubahannya, menggunakan SELECT BANDINGKAN DENGAN 4.b UPDATE dosen set nama=‘Mardhiya Hayaty’  lihat perubahannya, menggunakan SELECT Ambil kesimpulan dari latihan di atas

  5. DELETE • Hapuslah data yang sudah ada 5. a  DELETE FROM dosen WHERE nama=[terserah anda]  lihat menggunakan SELECT, masih ada atau tidak ? 5.b  DELETE FROM dosen  lihat menggunakan SELECT, semua data terhapus? Ambil kesimpulan dari latihan di atas

More Related