drop schema if exists employees;
create schema employees;
use employees;

CREATE TABLE `employee` (
  `id` int(11) NOT NULL,
  `age` int(11) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `gender` varchar(45) DEFAULT NULL,
  `role` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `employee` (`id`,`age`,`name`,`gender`,`role`) VALUES (1,29,'Pankaj','Male','Java Developer');
INSERT INTO `employee` (`id`,`age`,`name`,`gender`,`role`) VALUES (2,35,'Lisa','Female','CEO');
INSERT INTO `employee` (`id`,`age`,`name`,`gender`,`role`) VALUES (3,40,'Tom','Male','Manager');
INSERT INTO `employee` (`id`,`age`,`name`,`gender`,`role`) VALUES (4,25,'Meghna','Female','Manager');

