Praktikum 3

LAPORAN PRAKTIKUM 3

create database perpustakaan

use perpustakaan

create table buku(

          kd_buku char(4),

          judul varchar(30),

          penerbit varchar(20),

          pengarang varchar(15),

          stok int)

select*from buku

insert into buku values('B001','BORLAND DELPHI','andi','jogianto','5')

insert into buku values('B002','VISUAL BASIC 6.0','ANEKA ILMU','M.HARIS','6')

insert into buku values('B003','MICROSOFT SQL SERVER 2000','GRANA ILMU','ABDULLAH','4')

select*from buku

update buku set judul='BORLAND C++'

select*from buku

update buku set judul='MICROSOFT ACCESS'Where kd_buku='B001'

select*from buku