课程: Level Up: SQL

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Create a table to store information

Create a table to store information - SQL教程

课程: Level Up: SQL

开始一个月试用 购买团队方案

Create a table to store information

“

(upbeat video game music) - Once the invitations have been sent out, we'll start hearing back from customers who want to attend our restaurant's anniversary celebration. We want to know whom to expect, and that'll tell us how many people we need to plan for. As our customers call and email us back, showing their interest in attending, we'll need a way to store that information. To do that, we'll create a table to record customer information and how many people they'll have in their party. In order to maintain the integrity of the data in our database, we'll need to use a customer's ID from the Customers table to represent them in this new table, so we're not entering the customer's name and email information in another table. We already have a record of customer information, and we need to use that, rather than create duplicate entries. Your challenge is to create a basic table where we can record a customer's ID and…

内容