MySQL 㧠You can’t specify target table ～ for update in FROM clause エラーMySQL 㧠Update æ–‡ã®ä¸ã§ã‚µãƒ–クエリを使ã†ã¨ã€You can’t specify target table ～ for update in FROM clause ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒå‡ºã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚サブクエリã®ä¸ã§æ›´æ–°ã™ã‚‹ãƒ†ãƒ¼ãƒ–ルをèªã‚“ã§ã„るよã†ãªå ´åˆã«ç™ºç”Ÿã—ã¾ã™ã€‚ãŸã¨ãˆã° update temp_table set num = (select max(num) +1 from temp_table) where num=1; ERROR 1093 (HY000): You can't specify target table 'temp_table' for update in FROM clause PostgreSQL ã‚„ Oracle ã§ã¯ã“ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ã¯èµ·ããšã«æ›´æ–°ãŒå®Œäº†ã—ã¾ã™ã€‚対処方法ã¨ã—ã¦ã¯ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ†ãƒ¼ãƒ–ルを使ã†ã‹ MySQL ã‚’ã‚„ã‚ã‚‹ã“ã¨ã€‚テンãƒãƒ©
about:blank
æ»æ»…病棟: 窓使ã„ã®æ†‚鬱㧠Alt + Space ã«ã‚ˆã‚‹ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚’強引ã«è¡¨ç¤ºã™ã‚‹
{{#tags}}- {{label}}
{{/tags}}