Chapter 5, Problem 6HOA

Explanation of Solution

Creating a script file:

Creating a script file is nothing but writing a SQL statement(s) and saving in a file(some name) with extension .sql.

To create a script using substitution variables that allows a user to set a new cost amount for a book based on the ISBN users can UPDATE command.

UPDATE command:

User must use UPDATE command to change the existing data in a table. UPDATE command belongs to DML (Data Manipulation Language) statement.

Syntax: UPDATE tablename SET columnname=new data value,....;

• UPDATE keyword in a statement identifies the table containing records to be changed...