Computer scienceFundamentalsSQL and DatabasesDBMSMySQLDB objects

Triggers

Theory

Manual create new trigger

Report a typo

You have created the following table:

CREATE TABLE employee (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20), salary DECIMAL(15,2));

Create a new trigger for this table:

  • With any name
  • And any trigger body statement
  • Only in theemployee table
Write an SQL statement





___

Create a free account to access the full topic