CST 1204 Chapter Notes - Chapter 6: Item Number, Database, Data Definition Language

• School: CUNY-New York City College of Technology
• Department: Computer Systems Technology
• Course: CST 1204

Document Summary

Create a new table named level1_customer that contains the following columns from the customer table: customer_num, customer_name, balance, credit_limit and rep_num. The columns in the new level1_customer table should have the same characteristics as the corresponding columns in the. Insert into new table using insert command (with condition) Insert into level1_customer table the customer number, customer name, balance, credit limit, and rep number for customers with credit limits of ,500. Add customer number 907 to the level1_customer table. The name is glenn"s british toys, the balance is zero, the credit limit is ,500, and the rep number is 45. Values ("907", "glenn""s british toys", 0, 7500, "45"); //just one single quote will close the initial quote --> need two single quotes. Change the name of customer 796 in the level1_customer table to "unique gifts and toys". Where customer_num = "796"; // without this, it changes all the customers.