[#9] "MYSQL Update Statement Explained with Examples" | MySQL Tutorial | #ITTECH
"Learn how to use the MySQL UPDATE statement to modify data in your database efficiently. This tutorial covers the syntax, examples, and tips for updating single or multiple rows using WHERE conditions. Perfect for beginners and professionals looking to enhance their SQL skills!"
=========================================================================
The `UPDATE` statement in MySQL is used to modify existing records in a table. It allows you to update specific columns based on conditions provided in the `WHERE` clause.
### Syntax:
```sql
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
```
- **`table_name`**: The name of the table you want to update.
- **`SET`**: Specifies the columns and their new values.
- **`WHERE`**: Filters the rows to be updated (optional). If omitted, all rows in the table will be updated.
### Example 1: Update a Single Row
Suppose you have a table `employees`:
```sql
+----+----------+-----------+
| id | name | salary |
+----+----------+-----------+
| 1 | Alice | 5000 |
| 2 | Bob | 4000 |
| 3 | Charlie | 4500 |
+----+----------+-----------+
```
To update Bob’s salary to 4500:
```sql
UPDATE employees
SET salary = 4500
WHERE name = 'Bob';
```
**Result:**
```sql
+----+----------+-----------+
| id | name | salary |
+----+----------+-----------+
| 1 | Alice | 5000 |
| 2 | Bob | 4500 |
| 3 | Charlie | 4500 |
+----+----------+-----------+
```