Problem 3: Create & execute after update trigger Update_record on table Employee, if you want to update any record in the employee table, these changes will also be reflected in the Log_Details table. This means you will update only the employee table & L

Ashamed Ant answered on October 20, 2023 Popularity 1/10 Helpfulness 1/10

answer Problem 3: Create & execute after update trigger Update_record on table Employee, if you want to update any record in the employee table, these changes will also be reflected in the Log_Details table. This means you will update only the employee table & L

Problem 3: Create & execute after update trigger Update_record on table Employee, if you want to update any record in the employee table, these changes will also be reflected in the Log_Details table. This means you will update only the employee table & L

Comment

DELIMITER //
CREATE TRIGGER Update_record
AFTER UPDATE ON Employee
FOR EACH ROW
BEGIN
    UPDATE Log_Details
    SET Name = NEW.Name
    WHERE Emp_ID = NEW.Emp_ID;
END;
//
DELIMITER ;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: chat.openai.com

Tags: any execute record sql this

Link to this answer
Share Copy Link

Contributed on Oct 20 2023

Ashamed Ant

0 Answers Avg Quality 2/10

Problem 3: Create & execute after update trigger Update_record on table Employee, if you want to update any record in the employee table, these changes will also be reflected in the Log_Details table. This means you will update only the employee table & L

Contents

More Related Answers

Problem 3: Create & execute after update trigger Update_record on table Employee, if you want to update any record in the employee table, these changes will also be reflected in the Log_Details table. This means you will update only the employee table & L

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.