June 2018
Beginner to intermediate
210 pages
5h 12m
English
The DELETE statement is used to remove one or more rows from a table when a certain condition is met as follows:
> DELETE FROM employee_trans WHERE emp_id = 104;No rows affected (42.298 seconds)-- Verify the result, deleted> SELECT name FROM employee_trans WHERE emp_id = 104;+------+| name |+------++------+No rows selected (0.33 seconds)
Read now
Unlock full access