Sample data
DROP TABLE IF EXISTS adj_table;
CREATE TABLE adj_table (
emp_id int(11) NOT NULL AUTO_INCREMENT,
name varchar(30) NOT NULL,
salary decimal(10,2) DEFAULT ‘0.00’,
boss_id int(11) DEFAULT NULL,
PRIMARY KEY (emp_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
INSERT INTO adj_table (emp_id, name, salary, boss_id) VALUES
(10, ‘Albert’, 1000.00, NULL),
(11, ‘Bert’, 900.00, 10),
(12, ‘Chuck’, 900.00, 10),
(13, ‘Donna’, 800.00, 12),
(14, ‘Eddie’, 700.00, 12),
(15, ‘Fred’, 600.00, 12);