MySQL Programming Examples

-- Update employee salary
UPDATE employees 
SET salary = salary * 1.10 
WHERE employee_id = 1;

-- Delete specific record
DELETE FROM employees 
WHERE email = 'bob.j@example.com';

-- Verify remaining records
SELECT employee_id, first_name, salary FROM employees;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1

Query OK, 1 row affected (0.01 sec)

+-------------+------------+----------+
| employee_id | first_name | salary   |
+-------------+------------+----------+
|           1 | John       | 60500.00 |
|           2 | Alice      | 62000.00 |
|           4 | Carol      | 75000.00 |
+-------------+------------+----------+