MySQL Basic Go Back Update query, like & where clauses views 08:24 Where do we use UPDATE Query? When you want to update data in some column for some reason, you use UPDATE Query. Update statement general syntax is UPDATE table_name SET field1 = new value1, field2 = new value2 [WHERE Clause]; It is UPDATE followed by table_name tells MySQL to update data in the table. Introduction of RDBMS (Relative Database Management System) Installation and Administration of MYSQL MySQL Connection & Database queries Data types Table queries Inserting data and retrieving data Update query, like & where clauses Queries for sorting data