Yurttas/PL/DBL/mysql-f-2010/01/BankTwo/u08.sql

 1/*
 2REM
 3REM u08.sql
 4REM
 5REM Suppose that we want to provide all loan customers in the
 6REM Caldwell branch with a $200 savings account.
 7REM (Let the loannumber serve as the accountnumber
 8REM  for the new savings account.)
 9REM
10*/
11
12\. set-db.sql
13
14INSERT INTO Depositor
15  SELECT branchname, loannumber, customername, 200
16  FROM Borrower
17  WHERE branchname = 'Caldwell';