Aplikasi Basis Data - Pertemuan 12

===========================================

Pertemuan 12: Data Manipulation Language

===========================================

*ini bagian awalnya

- d:

- cd/xampp/mysql/bin

- mysql -u root

*1: buka database db_mysql

- show databases;

- use db_mysql;

*2: isi tabel biodata

- insert into biodata (nim,nama,telepon,alamat) values ("12140001","Dila Arlyla","081212345678","Dewi Sartika");

- insert into biodata (nim,nama,telepon,alamat) values ("12140002","Verlita Kayla Putri","081312345678","Jatiwaringin");

- insert into biodata (nim,nama,telepon,alamat) values ("12140003","Dika Arya","085612345678","Pemuda");

- insert into biodata (nim,nama,telepon,alamat) values ("12140004","Erlika Dwitami","085712345678","Ciledug");

- insert into biodata (nim,nama,telepon,alamat) values ("12140001","Eza Wahid","088512345678","Pondok Aren");

*3: tampilkan tabel biodata

- select *from biodata;

*4: isi tabel nilai

- insert into biodata (nim,nil_abs,nil_tgs,nil_uts,nil_uas) values ("100","95","89","90");

- insert into biodata (nim,nil_abs,nil_tgs,nil_uts,nil_uas) values ("78","75","72","70");

- insert into biodata (nim,nil_abs,nil_tgs,nil_uts,nil_uas) values ("80","87","85","80");

- insert into biodata (nim,nil_abs,nil_tgs,nil_uts,nil_uas) values ("87","89","90","85");

- insert into biodata (nim,nil_abs,nil_tgs,nil_uts,nil_uas) values ("95","94","92","100");

*5: tampilkan nilai uas tertinggi dan terendah

- select max(nil_uas) from nilai;

- select min(nil_uas) from nilai;

*6: update nilai absen menjadi 98 untuk 12140005

- update nilai set nil_abs="98" where nim="12140005";

*7: tampilkan hasil penjumlahan, rata-rata, banyak data dari nilai uts

- select sum(nil_uts) from nilai;

- select avg(nil_uts) from nilai;

- select count(nil_uts) from nilai;

*8: hapus record 12140003 untuk table nilai

- delete from nilai where nim="12140003";

*9: tampilkan tabel nilai keseluruhan

- select *from nilai;

*10: hapus record 12140002 untuk table biodata

- delete from biodata where nim="12140002";

===========================================

Name: Harsan Febrian

NIM: 12140650

Class 12.2C.11

===========================================