목록Foreign Keys (1)

Developer Cafe

MySQL Foreign Keys Setting

1. 테스트용으로 두 테이블을 생성한다. CREATE TABLE parent ( pid INT AUTO_INCREMENT NOT NULL, name varchar(5), PRIMARY KEY(pid) ) ENGINE = InnoDB; CREATE TABLE child ( pid INT AUTO_INCREMENT PRIMARY KEY, parent_pid INT NOT NULL, title varchar(100), INDEX(parent_pid), FOREIGN KEY(parent_pid) REFERENCES parent(pid) ) ENGINE = InnoDB; 2. 제대로 들어가는지 테스트한다 INSERT INTO parent(name) VALUES('test'); INSERT INTO child(pa..
SQL 2021. 5. 31. 10:19
이전 Prev 1 Next 다음