TUGAS My SQL

My sql

Insert – insert

SOURCE CODE 

CREATE TABLE ii_brang_msk

( kode VARCHAR(10) NOT NULL,

nama VARCHAR(25),

tgl date,

PRIMARY KEY (kode))

CREATE TABLE ii_history

( kode VARCHAR(10) NOT NULL,

tgl date,

PRIMARY KEY (kode))

DELIMITER go

CREATE TRIGGER tr_ii

BEFORE INSERT ON ii_brang_msk

FOR EACH ROW BEGIN

INSERT INTO ii_history (kode,tgl)

VALUES (NEW.kode,NEW.tgl);

END;

go

DELIMITER ;

INSERT INTO II_BRANG_MSK VALUES ('AA001','RAM','2013-07-16')

INSERT INTO II_BRANG_MSK VALUES ('AA002','VGA','2013-07-18')

SELECT*FROM II_BRANG_MSK

SELECT*FROM II_HISTORY

Insert – update

TUGAS ORACLE

ORACLE

INSERT - INSERT 

CREATE TABLE  II_BARANG_MSK(      KD_BRG CHAR(5) NOT NULL PRIMARY KEY, NAMA_BRG VARCHAR2(25), TGL_MSK DATE ); CREATE TABLE  II_HISTORY(  KD_BRG CHAR(5),  TGL_MSK DATE ); create or replace trigger TR_II after INSERT on II_BARANG_MSK for each row begin insert into II_HISTORY values (:new.KD_BRG,:new.TGL_MSK); end; INSERT INTO II_BARANG_MSK VALUES ('AA001','RAM','1-mar-13') INSERT INTO II_BARANG_MSK VALUES ('AA002','VGA','3-mar-13') SELECT*FROM II_BARANG_MSK SELECT*FROM II_HISTORY

 INSERT – UPDATE