Choose Category
UPDATE tablename SET column1=value
UPDATE tablename SET column1=value WHERE condition
UPDATE tablename SET column1=value1, column2=value2 ..... WHERE condition
UPDATE tbl_emp SET emp_no=12345
UPDATE tbl_emp SET emp_no=12345 WHERE emp_name='Forgetter';
UPDATE tbl_emp SET emp_no=12345, phone_no=9876543210 WHERE emp_name='Forgetter';