Home » mysql » MySql Update Table

MySql Update Table

To update records in a table we use update quey

Syntax:

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

Your email address will not be published.

Managed by MochaHost - Fast & Easy WordPress Hosting