[B! SQL] karumadoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

karumado id:karumado

SQLã«é–¢ã™ã‚‹karumadoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

NULLIF é–¢æ•°ã®å®Ÿç”¨çš„ãªä½¿ã„æ–¹ - ãã‚‹ãã‚‹ï½ž
NULLIF é–¢æ•°ã£ã¦å‹•ä½œã®èª¬æ˜Žã¯å¤šã„ã‘ã©ã€ãã‚Œã‚’ä½•ã«ä½¿ãˆã°ã„ã„ã®ã‹ã£ã¦ã‚ã‚“ã¾ã‚Šç†è§£ã•ã‚Œã¦ãªã„ã‚“ã˜ã‚ƒãªã„ã‹ã¨æ€ã†ã€‚ ã£ã¦ã“ã¨ã§ã€NULLIF é–¢æ•°ã®å®Ÿç”¨çš„ãªä½¿ã„æ–¹ã‚’ã„ãã¤ã‹ç´¹ä»‹ã™ã‚‹ã€‚ NULLIF é–¢æ•°ã®å‹•ä½œ ã¾ãšã¯ã€NULLIF é–¢æ•°ã®å‹•ä½œã‹ã‚‰ã€‚ NULLIF é–¢æ•°ã¯å¼•æ•°ã‚’ 2 ã¤ã¨ã£ã¦ã€å¼•æ•°ãŒç‰ã—ã„å ´åˆã« NULL ã‚’è¿”ã—ã€ç•°ãªã‚‹å ´åˆã«ç¬¬ä¸€å¼•æ•°ã‚’è¿”ã™ã ã‘ã®ã€å‹•ä½œè‡ªä½“ã¯ã‹ãªã‚Šç°¡å˜ãªé–¢æ•°ã€‚ ä¾‹ãˆã°ã€ SELECT col_a, col_b, NULLIF(col_a, col_b) FROM SomeTable; ã“ã‚Œã‚’å®Ÿè¡Œã™ã‚‹ã¨ã€æ¬¡ã®ã‚ˆã†ãªçµæžœãŒå¾—ã‚‰ã‚Œã‚‹ã€‚ col_a col_b NULLIF(col_a, col_b) 10 10 NULL 10 0 10 0 10 0 NULL NULL NULL ã¾ãŸã€ãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬2ç‰ˆã§ã¯ã€CASE å¼ã‚’ç”¨ã„ã¦ã€ NULLIF(V1
karumado 2018/12/20
SQL
ãƒªãƒ³ã‚¯
TeamSQL - Cross-platform SQL Client Built for Collaboration
Looking for an Amazon Redshift client? TeamSQL has retired and is not available for download anymore. You can The world's first and the only query and management tool built for Amazon Redshift. Get DataRow for Amazon Redshift Hello, TeamSQL has been a great platform to experiment with modern UI and powerful features to help you manage your popular databases with collaborative features. Over two ye
karumado 2018/10/01
SQL

GUI
ãƒªãƒ³ã‚¯
RDBã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ // Speaker Deck
PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2016ã®è³‡æ–™ã§ã™ http://phpcon.php.gr.jp/2016/
karumado 2016/11/04
mysql

ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³

SQL
ãƒªãƒ³ã‚¯
é–‹ç™ºè€…ã®ãŸã‚ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å…¨ã¦
å‰æ›¸ã - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ãªãœé–‹ç™ºè€…ã®ã‚¿ã‚¹ã‚¯ãªã®ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä½•ã«ä¼¼ã¦ã„ã‚‹ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ - äºŒé‡é€£çµãƒªã‚¹ãƒˆ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) - ãƒãƒ©ãƒ³ã‚¹æœ¨ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é…ãã™ã‚‹2ã¤ã®åŽŸå› where å¥ - æ¤œç´¢ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãŸã‚ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆ ç‰ä¾¡ æ¼”ç®—å - ä¸€è‡´ã™ã‚‹ã‚ãƒ¼ã®æ¤œç´¢ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã„æ–¹ã‚’ç¢ºèª è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - è¤‡æ•°åˆ—ã«å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII - å‰ã®å•é¡Œç‚¹ãŒå†ã³ é–¢æ•° - whereå¥ã® ä¸ã§ã®é–¢æ•° å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ - UPPERã¨ LOWER ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° - é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åˆ¶é™ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ - å†—é•·æ€§ã®æŽ’é™¤æ³• ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª - ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãŸã‚ã« ç¯„å›² æ¤œ
karumado 2014/10/20
SQL

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
1