lesson1Title

lesson2Title

lesson3Title

lesson4Title

lesson5Title

lesson6Title

lesson7Title

lesson8Title

lesson9Title

lesson10Title

lesson11Title

sqlIntroBasicChapter2Title

sqlIntroBasicChapter1Title

sqlIntroBasicChapter3Title

-- View all current clients
SELECT * FROM clients;

-- Update the email of Jason Green (previously inserted)
UPDATE clients
SET email = 'j.green@newdomain.com'
WHERE name = 'Jason Green';

-- Update both email and signup_date for Laura Adams
UPDATE clients
SET email = 'laura.adams@newdomain.com', signup_date = '2023-04-10'
WHERE id = 4;

-- Confirm updates
SELECT * FROM clients;

# `UPDATE`

The `UPDATE` statement **modifies existing rows** in a table. It changes one or more column values for specific rows.

<br/>

## Basic Syntax

The example below shows how to update a record in a table using the `UPDATE` statement:

```sql title="UPDATE Syntax"
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
```

* `SET` defines the new values for one or more columns.
* `WHERE` specifies **which row(s)** should be updated.

> *Note*: Always use a `WHERE` clause unless you want to update **every row** in the table.

<br/>

## Update Statement Example

The query below updates the email for a client named Jason Green.

```sql title="Update email for a client"
UPDATE clients
SET email = 'j.green@newdomain.com'
WHERE name = 'Jason Green';
```

This updates the email for the client named Jason Green to `j.green@newdomain.com`.

| id | name        | email                 | signup_date |
|----|-------------|-----------------------|-------------|
| 5  | Jason Green | j.green@newdomain.com | 2023-12-14  |

<br/>

## Update Multiple Columns

The example below shows how to update multiple columns in a table using the `UPDATE` statement:

```sql title="Update multiple values at once"
UPDATE clients
SET email = 'laura.adams@newdomain.com', signup_date = '2023-04-10'
WHERE id = 4;
```

This changes both the email and signup date for the client with `id = 4`.

| id | name        | email                 | signup_date |
|----|-------------|-----------------------|-------------|
| 4  | Laura Adams | laura.adams@newdomain.com | 2023-04-10  |

The UPDATE command is used to modify existing values in a table.

UPDATE

Basic Syntax

Update Statement Example

Update Multiple Columns

What does the UPDATE statement do in SQL?

`UPDATE`

What does the `UPDATE` statement do in SQL?