테이블을 전부 지우는 경우..

DROP TABLE customer.customer;

 

테이블을 다시 만듭니다.  mssql에서는 identity(1,1)

 

create table Customer.Customer
( 
   Id int AUTO_INCREMENT PRIMARY KEY,
   FirstName varchar(50),
   LastName varchar(50),
   Age int,
   City varchar(50)
);

 

새로 Custom 데이타도 입력하고

 

insert into customer.customer (FirstName, LastName, Age, City) values  ('Joey', 'Blue', 40, 'Goddard');
insert into customer.customer (FirstName, LastName, Age, City) values  ('Barry', 'Bonds', 50, 'San Francisco');
insert into customer.customer (FirstName, LastName, Age, City) values  ('Mike', 'Schmidt', 60, 'KC');

 

Product 데이타도 입력하고

 

create table Customer.Products
( 
   Id int AUTO_INCREMENT PRIMARY KEY,
   ProductName varchar(50)
);

 

alter table Customer.Products
add Price float;

 

insert into Customer.Products (ProductName, Price) values ('Baseball', 5.95);
insert into Customer.Products (ProductName, Price) values ('Bat', 195.99);

 

select * from Customer.Products;

 

Order 데이타도 만들고

 

create table Customer.Orders
(
    OrderID int auto_increment primary Key,
    OrderDate Datetime,
    CustomerID int,
    ProductID int
);

select * from customer.orders;
select * from customer.Products;
select * from customer.Customer;

 

지금 (GetDate대신에 now로.) Barry Bonds가 Bat를 샀다고 하면

insert into customer.Orders (OrderDate, CustomerID, ProductID) values (now(), 2, 2);

 

https://youtu.be/9Pzj7Aj25lw?list=PLD20298E653A970F8&t=1954