MySql Update Table

To update records in a table we use update quey


First select the table data

by this query we get a table ‘student’ which we have created in our database as shown above.

To update the above table, we use the query:

we can see the updated table

If you don’t use where clause in query then it will update all the record of fields with given value
We can update multiple column value in single query.

The updated table is

Leave a Comment