WHAT IS ANSWERN OF
MYSQL ASSINGNMENT 1 TASK 1 QESTION 13
THIS IS I THINK BUT ITS NOT WORKING
I USED INSERT INTO SELECT
DELIMITER //
CREATE TRIGGER MYTRIGER
AFTER INSERT ON employee
FOR EACH ROW
BEGIN
INSERT INTO name_salary(FirstName, LastName, SALARY)
SELECT employee.FirstName, employee.LastName,employee.SALARY FROM employee
END //