Praktikum 1

LAPORAN PRAKTIKUM 1

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