remed

create table UKM(
KodeUKM varchar(8)NOT NULL,
NamaUKM varchar(8),
CONSTRAINT TUKM PRIMARY KEY (KodeUKM)
);

INSERT INTO UKM VALUES ('34555','Voli');
INSERT INTO UKM VALUES ('33555','S.Bola');
INSERT INTO UKM VALUES ('32555','Tennis');
INSERT INTO UKM VALUES ('31555','P.Alam');
INSERT INTO UKM VALUES ('30555','Musik');

SELECT * FROM UKM

SELECT NamaUKM FROM UKM

UPDATE UKM SET NamaUKM ='S.Takraw' WHERE NamaUKM='Voli';

DELETE FROM UKM WHERE KodeUKM='33555';

UPDATE UKM SET KodeUKM ='36555' WHERE KodeUKM='33555';

UPDATE UKM SET NamaUKM ='StartUP' WHERE KodeUKM='36555';

SELECT * FROM UKM order by KodeUKM asc;