Deleting Data
Finally, let’s look at how we can delete data from a table. To do that, we use the syntax below:
DELETE FROM table_name
WHERE condition;
For instance, to delete 'Li Xiao Ting' (id = 5) from the employees table, we use the following code:
DELETE FROM employees
WHERE id = 5;
Try it yourself. You should get a green tick with the message
1 row(s) affected
in your output window.