basictutorial.sql

create database employee_management;
use employee_management;
create table employee(
worked_ID int(9) primary key auto_increment,
First_name char(20),
Last_name char(20),
Salary int(9),
joining_date datetime,
department char(20)
);
insert employee values ('001', 'Monika', 'Arora', 100000, '2014-02-20 09:00:00', 'HR');
insert employee values ('002', 'Niharika', 'Verma', 80000, '2014-06-11 09:00:00', 'ADMIN');
insert employee values ('003', 'Vishal', 'Singhal', 300000, '2014-02-20 09:00:00', 'HR');	
insert employee values ('004', 'Amitabh', 'Singh', 500000, '2014-02-20 09:00:00', 'ADMIN');
insert employee values ('005', 'Vivek', 'Bhati', 500000, '2014-06-11 09:00:00', 'ADMIN');
insert employee values ('006', 'Vipul', 'Diwan', 200000, '2014-06-11 09:00:00', 'ACCOUNT');
insert employee values ('007', 'Satish', 'Kumar', 75000, '2014-01-20 09:00:00', 'ACCOUNT');
insert employee values ('008', 'Geetika', 'Chauhan', 90000, '2014-04-11 09:00:00', 'ADMIN');
insert employee values ('102', 'Trishna', 'Bhattarai', 100000, '2014-06-20 09:00:00', 'HR');
select First_name, Last_name, salary from employee;
select * from employee where worked_ID= 102;