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.
To update the existing record in table, use the following syntax:
Parameters:
tablename: The table name from which you want to update.
Conditions: To add specific condition. The conditions parameter is optional.
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:
You can use MySQL Command Line Client to show updated record from table. It will look like this: