How to use the update command in MySQL Posted on October 6, 2015 by Zahid Iqbal Reply Update command- To update the department & mobile no of suneel Query- update employee set Department= ‘IT’, salary= ‘15000’ where Emp_ID= 5775 update user_leave_balance set cl_balance= ’20’ where Emp_id=’005969′; Advertisement