Update information in a mysql column 1

Update information in a mysql column

UPDATE employees 
SET 
    email = 'mary.patterson@classicmodelcars.com'
WHERE
    employeeNumber = 1056;Code language: SQL (Structured Query Language) (sql)

Here is what the above code is Doing:
1. We’re updating the email column in the employees table.
2. We’re setting the email column to mary.patterson@classicmodelcars.com.
3. We’re updating the row where the employeeNumber is 1056.

Similar Posts