# PERTEMUAN 05

## DATA MANIPULATION LANGUAGE (Bagian-1)

### Live Preview

- [Click Me](https://hackmd.io/@novaardiansyah/Hk9IBD5x6)

### Tugas Praktikum - Soal A.

  create database universitas;

  use universitas;

  create table mahasiswa(nim int(10), nama char(20), alamat varchar(30), email char(20), no_tlp char(10), primary key(nim));
  
  show tables;

  desc mahasiswa;

### Tugas Praktikum - Soal B.

  INSERT INTO mahasiswa (nim, nama, alamat, email, no_tlp) VALUES ('080911002', 'Sari', 'Pamulang', '[e-mail]', '08561009999');

  INSERT INTO mahasiswa (nim, nama, alamat, email, no_tlp) VALUES ('080911001', 'lala', 'jakarta', '[e-mail]', '08561009124');

  INSERT INTO mahasiswa (nim, nama, alamat, email, no_tlp) VALUES ('080911003', 'Tono', 'Parung', '[e-mail]', '08561009888');

  INSERT INTO mahasiswa (nim, nama, alamat, email, no_tlp) VALUES ('080911006', 'Toti', 'ciputat', '[e-mail]', '08561009555');
  
  INSERT INTO mahasiswa (nim, nama, alamat, email, no_tlp) VALUES ('080911014', 'Ida', 'Serpong', '[e-mail]', '08561009777');

  INSERT INTO mahasiswa (nim, nama, alamat, email, no_tlp) VALUES ('080911004', 'Iya', 'Semarang', '[e-mail]', '08561009999');

  SELECT * FROM mahasiswa;

### Tugas Praktikum - Soal C.

  UPDATE mahasiswa SET alamat = 'ciputat' WHERE NIM = '80911002';

  UPDATE mahasiswa SET email = '[e-mail]' WHERE NIM = '80911002';

  UPDATE mahasiswa SET nama = 'Bambang' WHERE NIM = '80911003';

  UPDATE mahasiswa SET alamat = 'ciputat' WHERE NIM = '80911003';

  UPDATE mahasiswa SET email = '[e-mail]' WHERE NIM = '80911004';

  UPDATE mahasiswa SET email = '[e-mail]' WHERE NIM = '80911004';

  SELECT * FROM mahasiswa;

### Tugas Praktikum - Soal D.

  DELETE FROM mahasiswa WHERE nim = '80911004';

  DELETE FROM mahasiswa WHERE nim = '80911014';

  SELECT * FROM mahasiswa;

### Tugas Praktikum - Soal E.

  CREATE DATABASE perusahaan;

  USE perusahaan;

  CREATE TABLE karyawan (NIK CHAR(9), Nama VARCHAR(120), Alamat VARCHAR(120), Email VARCHAR(120), No_Telepon CHAR(10));

  INSERT INTO karyawan (NIK, Nama, Alamat, Email, No_Telepon) VALUES ('080911001', 'Susi', 'Serpong', '[e-mail]', '0856777777');

  INSERT INTO karyawan (NIK, Nama, Alamat, Email, No_Telepon) VALUES ('080911002', 'Nuri', 'Jakarta', '[e-mail]', '0856888888');

  INSERT INTO karyawan (NIK, Nama, Alamat, Email, No_Telepon) VALUES ('080911003', 'Santi', 'Ciputat', '[e-mail]', '0812455555');

  INSERT INTO karyawan (NIK, Nama, Alamat, Email, No_Telepon) VALUES ('080911004', 'Nunu', 'Kebayoran', '[e-mail]', '0817677776');

  SELECT * FROM karyawan;

### Tugas Praktikum - Soal F.

  UPDATE karyawan SET Alamat = 'Muncul', No_Telepon = '0851236789' WHERE NIK = '080911001';

  UPDATE karyawan SET Nama = 'Sari', Email = 'sari@ymail' WHERE NIK = '080911002';

  UPDATE karyawan SET Nama = 'Sindy', Alamat = 'Cinere', Email = '[e-mail]', No_Telepon = '0812454564' WHERE NIK = '080911003';

  UPDATE karyawan SET Nama = 'Sandra', Alamat = 'Kebayoran', Email = '[e-mail]' WHERE NIK = '080911004';

  SELECT * FROM karyawan;