• We are available for any Development work:
  • Email us at: programmer_heart@yahoo.com

Trigger in MySQL

Let’s start creating the first trigger in MySQL by following a simple scenario. In the sample database, we have employees table as follows: CREATE TABLE `employees` ( `employeeNumber` int(11) NOT NULL, `lastName` varchar(50) NOT NULL, `firstName` varchar(50) NOT NULL, `extension` varchar(10) NOT NULL, `email` varchar(100) NOT NULL, `officeCode` varchar(10) NOT NULL, `reportsTo` int(11) default NULL, [...]

Continue reading
Press Enter to Search