CREATE DATABASE Akademik1643047;

USE Akademik1643047;

DROP TABLE mata_kuliah;

CREATE TABLE mata_kuliah(
Kd_mk VARCHAR(10) PRIMARY KEY,
Nm_mk VARCHAR(25),
Sks INT(1),
Smt INT(1));

SELECT * FROM mata_kuliah WHERE Smt="4";

SELECT * FROM mata_kuliah WHERE Nm_mk LIKE "%Praktikum%";

UPDATE mata_kuliah SET Nm_mk = REPLACE(Nm_mk, "Prak.", "Praktikum")
WHERE Nm_mk LIKE "%Prak.%";

INSERT INTO mata_kuliah VALUES
("MPK-5W4236","Ilmu Sosial Dasar","2","4"),
("MKK-5W4237","Jarkom 1","2","4"),
("MKK-5W4238","Prak. Jarkom 1","2","4"),
("MKK-5W4239","Basis Data 1","2","4"),
("MKK-5W4240","Prak. Basis Data 1","2","4"),
("MPK-5W2214","Pendidikan Pancasila","2","2"),
("MKK-5W2215","Sistem Informasi","2","2"),
("MKK-5W2216","Rangkaian Digital","2","2"),
("MKK-5W2217","Algoritma Pemrograman Lanjut","2","2"),
("MKK-5W2218","Prak. Algoritma Pemrograman Lanjut","2","2");

SELECT * FROM mata_kuliah;

ALTER TABLE mahasiswa ADD alamat TEXT AFTER nama_mhs;

DESC mahasiswa;

UPDATE mahasiswa SET alamat = "Jl.Gurame" WHERE nim = "1441009";
UPDATE mahasiswa SET alamat = "Jl.Biawan" WHERE nim = "1441010";
UPDATE mahasiswa SET alamat = "Jl.Lele" WHERE nim = "1441012";
UPDATE mahasiswa SET alamat = "Jl.Patin" WHERE nim = "1441014";
UPDATE mahasiswa SET alamat = "Jl.Arwana" WHERE nim = "1441020";
UPDATE mahasiswa SET alamat = "Jl.Nila" WHERE nim = "1441021";
UPDATE mahasiswa SET alamat = "Jl.Mas" WHERE nim = "1441023";
UPDATE mahasiswa SET alamat = "Jl.Hiu" WHERE nim = "1441026";