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.