Gnuboard Many to Many 에서 ON Delete Cascade, On Update Cascade 페이지 정보 작성자 Docker 댓글 0건 조회 5,108회 작성일 21-05-26 09:21 목록 본문 ``` CREATE TABLE Posts ( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), Title VARCHAR(255)); CREATE TABLE Tags ( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), Name VARCHAR(255)); CREATE TABLE Posts_Tags ( post_id INT NOT NULL, tag_id INT NOT NULL, PRIMARY KEY (post_id,tag_id), FOREIGN KEY (post_id) REFERENCES Posts(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (tag_id) REFERENCES Tags(id) ON UPDATE CASCADE ON DELETE CASCADE); INSERT INTO Posts (Title) VALUES ('Title1'); SET @post_id = LAST_INSERT_ID(); INSERT INTO Tags (Name) VALUES ('Tag1'); SET @tag_id = LAST_INSERT_ID(); INSERT INTO Posts_Tags (post_id, tag_id) VALUES(@post_id, @tag_id); INSERT INTO Tags (Name) VALUES ('Tag2'), ('Tag3'), ('Tag4'); INSERT INTO Posts (Title) VALUES ('Title2'); SET @post_id = LAST_INSERT_ID(); INSERT INTO Posts_Tags (post_id, tag_id) SELECT @post_id, id FROM Tags WHERE id IN (2, 3, 4); INSERT INTO Posts (Title) VALUES ('Title3'); SET @post_id = LAST_INSERT_ID(); INSERT INTO Posts_Tags (post_id, tag_id) SELECT @post_id, id FROM Tags WHERE Name IN ('Tag2', 'Tag4'); ``` Update는 Delete는 Read는 이전글monolog를 이용해서 그누보드 디버깅하기 21.05.31 다음글그누보드 글과 댓글 분리 21.05.25 댓글 0 댓글목록 등록된 댓글이 없습니다.
