SQL Basics - Primary Key
테이블을 전부 지우는 경우..
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);