게시판 합치는 방법 채택완료

아래의 내용을 한번 참고해 보세요.

실제 진행전에 테이블을 백업하고 진행을 하시는게 좋을거 같습니다.

1. 

INSERT INTO g5_write_d (wr_num, wr_reply, wr_parent, wr_is_comment, wr_comment, wr_comment_reply, wr_subject, wr_content, mb_id, wr_password, wr_name, wr_email, wr_homepage, wr_datetime, wr_last, wr_ip, wr_1, wr_2, wr_3, wr_4, wr_5, wr_6, wr_7, wr_8, wr_9, wr_10)
SELECT wr_num, wr_reply, wr_parent, wr_is_comment, wr_comment, wr_comment_reply, wr_subject, wr_content, mb_id, wr_password, wr_name, wr_email, wr_homepage, wr_datetime, wr_last, wr_ip, wr_1, wr_2, wr_3, wr_4, wr_5, wr_6, wr_7, wr_8, wr_9, wr_10
FROM (
    SELECT * FROM g5_write_a
    UNION ALL
    SELECT * FROM g5_write_b
    UNION ALL
    SELECT * FROM g5_write_c
) AS combined_posts
ORDER BY wr_datetime ASC;

2. wr_parent wr_num 재정렬

SET @num := 0; UPDATE g5_write_d SET wr_num = @num := @num + 1 ORDER BY wr_datetime ASC; UPDATE g5_write_d SET wr_parent = wr_id WHERE wr_is_comment = 0;

3. d 게시판의 게시물 수 업데이트

UPDATE g5_board SET bo_count_write = (SELECT COUNT(*) FROM g5_write_d WHERE wr_is_comment = 0)
WHERE bo_table = 'd';