Oracle/MySQL/PostgreSQLã«ãŠã‘るサブクエリをå«ã‚€DMLã®éžäº’æ›æ€§ - SH2ã®æ—¥è¨˜JPOUG Advent Calendar 2013ã®23日目ã§ã™ã€‚比較的簡å˜ãªDMLã§ã‚‚RDBMSé–“ã®éžäº’æ›æ€§ãŒå‡ºã¦ã—ã¾ã†ã¨ã„ã†æ€–ã„話をã—ã¾ã™ã€‚ +----+------+ | id | data | +----+------+ | 1 | a | | 2 | b | | 3 | c | +----+------+BEGIN; -- IDãŒæœ€ã‚‚å°ã•ã„レコードをãƒãƒƒã‚¯ã™ã‚‹ SELECT id, data FROM q WHERE id = (SELECT MIN(id) FROM q) FOR UPDATE; (何らã‹ã®å‡¦ç†) -- 処ç†ãŒçµ‚ã‚ã£ãŸã®ã§å‰Šé™¤ã™ã‚‹ DELETE FROM q WHERE id = (1ã¤ç›®ã®SQLã§å–å¾—ã—ãŸID); COMMIT;IDãŒæœ€ã‚‚å°ã•ã„レコードをãƒãƒƒã‚¯ã—ã€ä½•ã‚‰ã‹ã®å‡¦ç†ã‚’è¡Œã£ã¦ã€æœ€å¾Œã«ãã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’削除ã—ã¾ã™ã€‚IDãŒæœ€ã‚‚å°ã•ã„レコードをå–å¾—ã™ã‚‹ã¨ã„ã†ã®
{{#tags}}- {{label}}
{{/tags}}