- 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';