How to Update same table on deletion in MYSQL
In my database I have a table Employee that has recursive association (an employee can be boss of other employee): [php]create table if not exists `employee` ( `SSN` varchar(64) not null, `name` varchar(64) default null, `designation` varchar(128) not null, `MSSN` varchar(64) default null, primary key (`ssn`), constraint `fk_manager_employee` foreign key (`mssn`) references employee(ssn) ) engine=innodb default charset=latin1;[/php] … Read more
