Mysql database - basic operation of database and table (II)

For reference only ：

 

The first 1 Turn off ： insert data

USE Company;

# Please add the implementation code here 
########## Begin ##########

########## bundle insert the value ##########
insert into tb_emp(Id,Name,DeptId,Salary) 
values(1,'Nancy',301,2300)
,(2,'Tod',303,5600)
,(3,'Carly',301,3200);



########## End ##########
SELECT * FROM tb_emp;

The first 2 Turn off ： Update data

USE Company;

# Please add the implementation code here 
########## Begin ##########

########## update the value ##########
update tb_emp 
set Name="Nancy",DeptId=301,Salary =2300
where Id=1;
update tb_emp
set Name="Tracy",DeptId=302,Salary =4300
where Id=3;




########## End ##########

SELECT * FROM tb_emp;

The first 3 Turn off ： Delete data

USE Company;

# Please add the implementation code here 
########## Begin ##########

########## delete the value ##########

delete FROM tb_emp where Salary>3000;


########## End ##########

SELECT * FROM tb_emp;