Friday, 14 November 2014

Create Trigger in MySql Database

Create Two Table First Table : employees  CREATE TABLE employees ( employeeNumber INT(11) , lastName VARCHAR(200), firstName VARCHAR(200), extension VARCHAR(200), email VARCHAR(100), officeCode VARCHAR(100), reportsTo INT(11), jobTitel VARCHAR(100)  ) Insert value in the 1st table employees insert  into `employees`(`employeeNumber`,`lastName`,`firstName`,`extension`,`email`,`officeCode`,`reportsTo`,`jobTitel`)...