Jumat, 21 September 2012

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 ‘;