DB 3일차 2(트리거?)

트리거

insert trigger

BEGIN
	INSERT into
		user_dtl
		(id, create_date, update_date)
	values
		(NEW.id, NOW(), NOW());
END

쿼리

INSERT INTO
	user_mst
	
VALUES
	(0, 'aaa', '1234', '김준일', 'aaa@gmail.com',NOW(),NOW());

 

 

delete triger

 

쿼리

삭제 쿼리

DELETE
from
	user_mst
WHERE
	id = 1;

 

결과

 

example

생성하기

INSERT INTO
	user_mst
	
VALUES
	(0, 'aaa', '1234', '김준일', 'aaa@gmail.com',NOW(),NOW()),
	(0, 'bbb', '1234', '김준일', 'aaa@gmail.com',NOW(),NOW()),
	(0, 'ccc', '1234', '김준일', 'aaa@gmail.com',NOW(),NOW()),
	(0, 'ddd', '1234', '김준일', 'aaa@gmail.com',NOW(),NOW());

DELETE
from
	user_mst
WHERE
	id = 1;

mst

 

dtl