Chapter 16.4, Problem 16.21CP

Explanation of Solution

INSERT:

• The “INSERT” statement would add rows into table.
• The order of added values should be maintained as same as table columns.
• The two ways to use “INSERT” statement would include:
  • The first method used for stating only data value inserted without column names.
  • The second method is used for stating both columns needed to fill as well as their corresponding values.

Example:

The example for “INSERT” statement is shown below:

INSERT INTO Book

(Title, PageNum, Price)

VALUES

(‘Java Programming’, ‘200’, 8.65)

Here, “Book” denotes the name of table...