Answers for "mysql insert trigger"

SQL

0

mysql insert trigger

DELIMITER //

CREATE TRIGGER contacts_after_insert
AFTER INSERT
   ON contacts FOR EACH ROW
BEGIN
   -- Insert record into audit table
   INSERT INTO contacts_audit
   ( contact_id,
     created_date,
     created_by)
   VALUES
   ( NEW.contact_id,
     SYSDATE(),
     "Admin" );
END; //

DELIMITER ;

Posted by: Guest on July-30-2021

Source

Code answers related to "mysql insert trigger"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#