Getting Started with SQL and Databases: Managing and Manipulating Data with SQL

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

M. SimonGetting Started with SQL and Databaseshttps://doi.org/10.1007/978-1-4842-9493-2_8

8. Working with Tables

Mark Simon¹  

(1)

Ivanhoe VIC, VIC, Australia

 

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 ...