how to include record deleted date into trigger?# Database - 数据库
h*r
1 楼
Professor's requirements: Create a database trigger that stores deleted
customer records in an archive table. The archive table should also include
the DATE the customer record was deleted from the customer table.
I know how to create the trigger,but don't know how to include the date the
customer record was deleted. Anyone can give me some hlep? Thanks
BEFORE DELETE ON borrower_t
FOR EACH ROW
BEGIN
INSERT INTO borrowerarchive
VALUES(:Old.borrower_ssn, :Old.Borrower_Firstname, :Old.Borrower_Last
customer records in an archive table. The archive table should also include
the DATE the customer record was deleted from the customer table.
I know how to create the trigger,but don't know how to include the date the
customer record was deleted. Anyone can give me some hlep? Thanks
BEFORE DELETE ON borrower_t
FOR EACH ROW
BEGIN
INSERT INTO borrowerarchive
VALUES(:Old.borrower_ssn, :Old.Borrower_Firstname, :Old.Borrower_Last