PBD_Q2_3_100162

MySQL

CREATE TABLE KONTAK(ID Int NOT NULL Primary key,Nama varchar(20),Alamat varchar(30),Phone   varchar(15),Email varchar(30);

INSERT  into  mhs(Nim, Nama, Jenjang, Prodi) values (‘1055201095’,’Konain’,’S1’,’Tehnik Informatika’);

DELETE FROM mhs WHERE Nim =’ 1055201090 ’;

Update mhs set nama ‘Rahmat’ where nim = ‘ 1055201091 ‘;