Create Employee_info Table
CREATE TABLE `employee_info` (
`id` int(11) NOT NULL,
`name` varchar(265) NOT NULL,
`email` varchar(265) NOT NULL,
`department` varchar(265) NOT NULL,
`salary` int(11),
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Insert data into Employee_info Table
INSERT INTO `employee_info` (`Id`, `name`, `email`, `department`, `salary`) VALUES
('1', 'Karan Mehta', 'Karan@gmail.com','HR', '300000'),
('2', 'Rohit Sharma', 'Rohit@gmail.com','Admin', '75000'),
('3', 'Ankush Rajput', 'Ankush@gmail.com','Accounts',NULL),
('4', 'Priyanshi Sharma', 'Priyanshi@gmail.com','HR', '500000'),
('5', 'Sanket Gupta', 'Sanket@gmail.com','Developer', '100000'),
('6', 'Shruti Kapoor', 'Shruti@gmailcom','Admin', '80000'),
('7', 'Raj Kumar', 'Raj@gmail.com‘,NULL, '62000'),
('8', 'Suraj Roy','Suraj@gmail.com', NULL, '25000'),
('9', 'Geet Gour','Geet@gmail.com', 'Tester', '17000');
Create Student Table
CREATE TABLE `student` (
`id` int(11) NOT NULL,
`subject` varchar(265) NOT NULL,
`semester` int(11) NOT NULL,
`name` varchar(265) NOT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Insert data into Student Table
insert into student values
('1','ITB001',1,'Robert'),
('2','ITB001',1,'Bob'),
('3','ITB001',1,'Lisa'),
('4','ITB001',2,'Sam'),
('5','ITB001',2,'Maria'),
('6','ECB130',1,'John'),
('7','ECB130',1,'Robert'),
('8','ECB130',2,'Mickey');
Subscribe CodeEra-
https://www.youtube.com/channel/UCtY8p96hHhCsKqMMKGDMp7w
Join Our Telegram Channel-
https://t.me/joingroupCodeEra
