5 - DML commands used in MySQL WorkBench

DML(Data Manipulation Language) 

CREATING A TABLE

create table employees(

emp_id int not null,

first_name varchar(20) not null,

last_name varchar(10),

salary int,

primary key(emp_id)

);

INSERTING DATA IN TABLE

insert into employees(emp_id,first_name,last_name,salary) values (1,'Zeeshan','Khan',50000);

insert into employees(emp_id,first_name,last_name,salary) values (2,'Ross','Geller',60000);

insert into employees(emp_id,first_name,last_name,salary) values (3,'Rachel','Green',8000);

insert into employees(emp_id,first_name,last_name,salary) values (4,'Joey','Tribbiani',99000);

select*from employees;

UPDATING OR CHANGING DATA

update employees set last_name='Geller' where emp_id=3;

select*from employees;

DELETING DATA 

delete from employees where emp_id=4;

select*from employees;

OUTPUT GENERATED