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;