MySQL is an open-source relational database management system,actually the name MySQL come from the combinations of words “My“(name of co-founder Michael Widenius’s daughter) and “SQL“(Structured Query Language).Since MySQL is free and open-source it is the most popular and huge used RDBMS. In this section we are going to check out how to write a update query in MySQL.Let me explain the syntax for update query in mysql with example
Syntax
"UPDATE `TABLE_NAME` SET `COLUMN_NAME` = `VALUE' WHERE [condition];
Example
"UPDATE student SET mobile ='9999999999' WHERE id='9'";
