How to use the update command in MySQL

Update command-  

  • To update the department & mobile no of suneel

Query-
update employee set Department= ‘IT’, salary= ‘15000’ where Emp_ID= 5775

Update Table

update user_leave_balance set cl_balance= ’20’ where Emp_id=’005969′; 

Advertisements