MySQL: How to UPDATE and DELETE data from a TABLE

#MySQL #SQL #database

00:00:00 UPDATE
00:01:14 UPDATE multiple fields
00:01:55 UPDATE a field as NULL
00:02:16 UPDATE an entire row
00:02:45 DELETE a row

UPDATE employees
SET hourly_pay = 10.25
WHERE employee_id = 6;
SELECT * FROM employees;

DELETE FROM employees
WHERE employee_id = 6;
SELECT * FROM employees;