December 2019
Beginner
288 pages
4h 48m
English
Overview
This chapter teaches you to implement the INSERT, UPDATE, and DELETE statements which help you keep the content present in a table up-to-date. We will also cover how we can use default values while updating the tables.
In Chapter 1, SQL Basics, we learned the concepts that help set up a database. Although we did insert some data into the tables, we didn't quite get into the specifics of managing the data within the database. However, there might be circumstances where we might need to change the data inserted or present in the database. For example, an employee working for a company might want to change their official number from what was updated earlier. A product that is no longer manufactured ...