BEGIN ä¸ã« BEGIN ã‚’ã™ã‚‹ã¨ COMMIT ã•ã‚Œã‚‹ã“ã®è¨˜äº‹ã¯ MySQL Advent Calendar 2023 2日目ã®è¨˜äº‹ã§ã™ã€‚ (ã¡ã‚‡ã£ã¨ãƒ•ãƒ©ã‚¤ãƒ³ã‚°ã€‚。) 今回ã¯åƒ•ãŒãƒžã‚¸ã‹ã€ã¨æ€ã£ã¦ã—ã¾ã£ãŸ MySQL ã®æŒ™å‹•ã«ã¤ã„ã¦å…±æœ‰ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ BEGIN ä¸ã« BEGIN ã‚’ã™ã‚‹ã¨ COMMIT ã•ã‚Œã‚‹ çµè«–ã‹ã‚‰è¨€ã†ã¨ã“ã‚Œã ã‘ã§ã™ ^^;; アプリエンジニアã®æ–¹ã‹ã‚‰ãŠå•ã„åˆã‚ã›ã‚’ã„ãŸã ã„ãŸæ™‚ã«ã¯ã“ã®ã“ã¨ã‚’æ„è˜ã—ãŸã“ã¨ã™ã‚‰ãªã‹ã£ãŸã®ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®çµ‚了㯠COMMIT or ROLLBACK ã«ã¦ã•ã‚Œã‚‹ã®ã ã¨ã„ã†å…ˆå…¥è¦³ã§å‹•ã„ã¦ã„ã¾ã—ãŸã€‚ ã–ã£ãã‚Šã¨è¨€ã†ã¨ã“ã‚“ãªæ„Ÿã˜ BEGIN; INSERT INTO testtable VALUES (1); BEGIN; ã“ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§åˆ¥ã®ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚’ç«‹ã¡ä¸Šã’ã¦ä¸èº«ã‚’確èªã™ã‚‹ã¨ãªã‚“㨠testtable ã«ã¯ 1 ã¨ã„ã†å€¤ãŒå…¥ã£ã¦ã„ã¾ã™ã€‚ 個人的ã«ã¯ã¾ã˜ã‹ãƒ¼ãƒ¼ã€ãªæŒ™å‹•ã ã£ãŸã®ã§ã‚‚ã—ã‹ã—ãŸã‚‰
{{#tags}}- {{label}}
{{/tags}}