• 질문하는방법
• 모든질문
• 답변없는질문
• 미채택된질문
• 채택된질문
• 모든답변
• 그누보드5
• 영카트5
• 그누보드6
• 태그전체보기

• 질문하는방법
• 모든질문
• 답변없는질문
• 미채택된질문
• 채택된질문
• 모든답변
• 그누보드5
• 영카트5
• 그누보드6
• 태그전체보기

QA

$sql3 = "
        UPDATE
            database.data1 TB1 INNER JOIN database.data2 TB2
        ON
            TB1.number = TB2.number
        SET
            TB2.YN = 'A'
          , TB2.YN_DT = now()
        WHERE
            TB1.SAVE = 'Y'
        ";
$sql4 = "
        UPDATE
            database.data1 TB1 INNER JOIN database.data2 TB2
        ON
            TB1.number = TB2.number
        SET
            TB2.YN = 'B'
          , TB2.YN_DT = now()
        WHERE
            TB1.SAVE = 'N'
        ";

UPDATE
    database.data1 TB1 INNER JOIN database.data2 TB2
ON
    TB1.number = TB2.number
SET
     TB2.YN = (CASE TB1.SAVE WHEN 'Y' THEN 'A' WHEN 'N' THEN 'B' END)
    ,TB2.YN_DT = now()
WHERE
    TB1.SAVE = 'Y' OR TB1.SAVE = 'N'
;

CREATE TRIGGER data1_trigger
        BEFORE
        UPDATE ON database.data1
            FOR EACH ROW
        BEGIN

UPDATE
    database.data1 TB1 INNER JOIN database.data2 TB2
ON
    TB1.number = TB2.number
SET
    TB2.YN = (CASE TB1.SAVE WHEN 'Y' THEN 'A' WHEN 'N' THEN 'B' END)
    ,TB2.YN_DT = now()
WHERE
    TB1.SAVE = 'Y' OR TB1.SAVE = 'N'
END;