MySQL ã®NULL ã§ã¯ã¾ã£ãŸã“ã¨ã‚ã‚Œã“ã‚Œ - LukeSilvia’s diaryMySQL ã«é™ã‚‰ãšã€SQL ã®NULL ã®ä»•æ§˜ã«ã¯ä½•å›žã‹ã€Œãˆã£ã€ã¨é©šãã“ã¨ãŒã‚ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚5.1 版ã®æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãŒãªã‹ã£ãŸã‚‚ã®ã«ã¤ã„ã¦ã¯ã€4.1 ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’å‚ç…§ã—ã¾ã—ãŸã€‚ ãã‚‚ãã‚‚NULL ã¯ä½•ã‚’æ„味ã™ã‚‹ã‹ NULL ã¯æœªå®šç¾©ã¾ãŸã¯ã€ä¸æ˜Žã‚’æ„味ã™ã‚‹ã€‚「電話番å·ã‚’æŒãŸãªã„ã€ã¨ã„ã†ã“ã¨ã‚’表ç¾ã™ã‚‹å ´åˆã¯ã€NULL ã§ã¯ãªãã€ç©ºã®æ–‡å—列を使ã†ã€‚ NULL 値ã¨ã„ã†ã‚‚ã®ã‚’ SQL åˆå¿ƒè€…ã¯ã‚ˆãæ··ä¹±ã—ã¾ã™ã€‚SQL åˆå¿ƒè€…ã¯ã€å¤šãã®å ´åˆã€NULL ãŒç©ºæ–‡å— "" ã¨åŒã˜ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã—ã¾ã„ã¾ã™ã€‚ã“ã‚Œã¯é•ã„ã¾ã™ã€‚ãŸã¨ãˆã°ã€ä»¥ä¸‹ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯å®Œå…¨ã«åˆ¥ã®ã‚‚ã®ã§ã™ã€‚ mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (""); ã©ã¡ã‚‰ã®ã‚¹
{{#tags}}- {{label}}
{{/tags}}