SQL Primer: An Accelerated Introduction to SQL Basics

©  Rahul Batra 2018

Rahul BatraSQL Primerhttps://doi.org/10.1007/978-1-4842-3576-8_6

6. Manipulating Data

Rahul Batra¹ 

(1)

Gurgaon, Haryana, India

 

In this chapter we study the Data Manipulation Language (DML) part of SQL that is used to make changes to the data inside a relational database. The three basic commands of DML are as follows.

• INSERT Populates tables with new data

• UPDATE Updates existing data

• DELETE Deletes data from tables

We have already seen a few examples on the INSERT statement including simple inserts, selective field insertions, and null value inserts. Thus we will concentrate on other ways to use this statement.

Inserting Data into a Table from Another Table

You can insert new records into a table from another one by using a combination ...