MySQL Update Statement

The UPDATE statement allows you to modify or update the existing records in a table. We can use the UPDATE statement to change column values of a single row, a group of rows, or all rows in a table.

MySQL UPDATE TABLE Syntax

To update the existing record in table, use the following syntax:

UPDATE tablename SET field1 = newvalue1, field2 = new-value2 [WHERE Condition]  

Parameters:

tablename: The table name from which you want to update.

Conditions: To add specific condition. The conditions parameter is optional.

MySQL UPDATE TABLE examples

UPDATE tblCustomerLoan SET firstName = 'Sunil', lastName = 'Shetty' WHERE cellNo = 2342323234;

Note:

In the above example, we have updated first name and last name for the record having cellNo '2342323234' in existing table "tblCustomerLoan".

You can use MySQL Command Line Client to update record with specific condition in table. It will look like this:

Show UPDATE TABLE

SELECT * FROM tblCustomerLoan;  

You can use MySQL Command Line Client to show updated record from table. It will look like this: