6/29

DB

삭제

리스너 포트 설정

데이터베이스 선택

---

튜플(행) - 중복되지 않는 리스트

---

DDL - 테이블 관리

char vs varchar
-> varchar 사용

---

---

---

---

---

---

DDL

---

CREATE TABLE

---

ALTER TABLE

---

DROP TABLE

---

TRUNCATE TABLE

---

테이블 제약조건

---

---

기본키, 외래키 설정하는 법

1:n 관계
n에 외래키 설정
1에 기본키 설정

프로젝션- 데이터 뽑아내는 것

---

테이블 제약조건 실습예제

---

CREATE TABLE team_tb (
tno int primary key auto_increment,
tname varchar(10) not null unique,
tyear int not null,
tloc varchar(10) not null
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE player_tb (
pno varchar(20),
pname varchar(20),
pnumber int CHECK (pnumber BETWEEN 1 AND 100),
prole varchar(20) default '타자',
tno int,
FOREIGN KEY (tno) REFERENCES team_tb(tno)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


-- auto_increment 테스트
insert into team_tb(tname, tyear, tloc) 
values('롯데', 2000, '부산');
insert into team_tb(tname, tyear, tloc) 
values('삼성', 2005, '대구');
insert into team_tb(tno, tname, tyear, tloc) 
values(3,'엔씨', 2010, '제주');
insert into team_tb(tname, tyear,tloc)
values('SK', 2022, '서울');

insert into player_tb(pname, pnumber, tno) 
values('이대호', 99, 1);
insert into player_tb(pname, pnumber, tno) 
values('전준우', 100, 4);
insert into player_tb(pname, pnumber, tno) 
values('박지성', 8, 1);

select * from team_tb;
select * from player_tb;

delete from player_tb where pnumber=99;
delete from team_tb where tno = 8;

insert into player_tb(pname) values('박지성');
delete from player_tb where pname = '박지성';

insert into player_tb(tno) values(3);

ALTER TABLE team_tb AUTO_INCREMENT = 4;

insert into team_tb(tname, tyear)
values('LG', 2023);