For the most part, we have used the SELECT statement for extracting data from the database. The SELECT statement, with its various clauses, is often referred to as the DQL—the Data Query Language.
SQL does much more than allow you to select data. Among other things, it allows you to manipulate the data.
There are three main operations in SQL which manipulate data:
INSERT statements are how you add new data to a table.
UPDATE statements allow you to change existing data in a table.
DELETE is used to delete ...
