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

yaoki_dokidoki id:yaoki_dokidoki

sqlã¨SQLã«é–¢ã™ã‚‹yaoki_dokidokiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (23)

${{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}}

ã€SQLã€‘ORDER BY ã§ NULL ã‚’æœ€å¾Œã«ã™ã‚‹å ´åˆã®æ³¨æ„ç‚¹ | é›ªã®å¤©ç§¤
SQLã§NULLå€¤ã‚’å«ã‚€ã‚«ãƒ©ãƒ ã§ã‚½ãƒ¼ãƒˆã‚’å®Ÿæ–½ã™ã‚‹å ´åˆã€ä½•ã‚‚æ„è˜ã—ãªã„ã¨æœ€å°ã®å€¤ã¨ã—ã¦å‡¦ç†ã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ ä¾‹ãˆã°æ¬¡ã®ã‚ˆã†ãªãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå˜åœ¨ã™ã‚‹å ´åˆ test_tab num1null32 select * from test_tab order by num asc; ã“ã‚“ãªæ›¸ãæ–¹ã‚’ã™ã‚‹ã¨æ¬¡ã®ã‚ˆã†ãªé †ã§å‡ºåŠ›ã•ã‚Œã¾ã™ã€‚ test_tab numnull123 nullå€¤ãŒæœ€å°ã¨ã—ã¦æ‰±ã‚ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ nullå€¤ã‚’æœ€å¾Œï¼ˆã“ã®å ´åˆã¯æœ€å¤§ï¼‰ã¨æ‰±ã„ãŸã„å ´åˆã¯ä¸‹è¨˜ã®ã‚ˆã†ã«æ›¸ãã¾ã™ã€‚ select * from test_tab order by num is null asc; test_tab num132null ãŠæ°—ä»˜ãã¨ã¯æ€ã„ã¾ã™ãŒã€ã“ã®æ›¸ãæ–¹ã ã‘ã§ã¯ã€nullå€¤ãŒæœ€å¤§ã¨ã—ã¦æ‰±ã‚ã‚ŒãŸã ã‘ã§ã‚ã£ã¦ã€é€šå¸¸ã®ã‚½ãƒ¼ãƒˆã¯è¡Œã‚ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ ãã®ãŸã‚ã€ä¸‹è¨˜ã®ã‚ˆã†ã«æ›¸ãç›´ã—ã¾ã™ã€‚ select * fro
yaoki_dokidoki 2016/04/08
sql
ãƒªãƒ³ã‚¯
SQLæ¼”ç®—å
2 SQLæ¼”ç®—å ã“ã®ç« ã§ã¯ã€Oracle Database Liteã®SQLæ¼”ç®—åã‚’èª¬æ˜Žã—ã¾ã™ã€‚ã“ã®ç« ã®å†…å®¹ã¯æ¬¡ã®ã¨ãŠã‚Šã§ã™ã€‚ 2.1ã€ŒSQLæ¼”ç®—åã®æ¦‚è¦ã€ 2.2ã€Œç®—è¡“æ¼”ç®—åã€ 2.3ã€Œæ–‡å—æ¼”ç®—åã€ 2.4ã€Œæ¯”è¼ƒæ¼”ç®—åã€ 2.5ã€Œè«–ç†æ¼”ç®—åã€ 2.6ã€Œé›†åˆæ¼”ç®—åã€ 2.7ã€Œãã®ä»–ã®æ¼”ç®—åã€ 2.1 SQLæ¼”ç®—åã®æ¦‚è¦ æ¼”ç®—åã¯ã€å€‹ã€…ã®ãƒ‡ãƒ¼ã‚¿é …ç›®ã‚’æ“ä½œã—ã¦ã€çµæžœã‚’è¿”ã—ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿é …ç›®ã¯ã€ã€Œã‚ªãƒšãƒ©ãƒ³ãƒ‰ã€ã¾ãŸã¯ã€Œå¼•æ•°ã€ã¨å‘¼ã°ã‚Œã¾ã™ã€‚æ¼”ç®—åã¯ã€ç‰¹æ®Šæ–‡å—ã¾ãŸã¯ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã§è¡¨ã•ã‚Œã¾ã™ã€‚ãŸã¨ãˆã°ã€ä¹—ç®—æ¼”ç®—åã¯ã€ã‚¢ã‚¹ã‚¿ãƒªã‚¹ã‚¯ï¼ˆ*ï¼‰ã§è¡¨ã•ã‚Œã€NULLã‹ã©ã†ã‹ã‚’ãƒ†ã‚¹ãƒˆã™ã‚‹æ¼”ç®—åã¯ã€ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰IS NULLã§è¡¨ã•ã‚Œã¾ã™ã€‚æ¼”ç®—åã«ã¯ã€å˜é …æ¼”ç®—åã¨ãƒã‚¤ãƒŠãƒªæ¼”ç®—åã®2ã¤ã®ä¸€èˆ¬ã‚¯ãƒ©ã‚¹ãŒã‚ã‚Šã¾ã™ã€‚Oracle Database Lite SQLã¯ã€é›†åˆæ¼”ç®—åã‚‚ã‚µãƒãƒ¼ãƒˆã—ã¾ã™ã€‚
yaoki_dokidoki 2015/06/30
ã€ŒNULLã®æ¤œæŸ»ã«ä½¿ç”¨ã§ãã‚‹å”¯ä¸€ã®æ¼”ç®—åã§ã™ã€‚ã€NULLã¯IS NULLã‹IS NOT NULLã—ã‹ä½¿ãˆãªã„ã®ã‹ã€‚

sql
ãƒªãƒ³ã‚¯
How can I format a MySQL TIMEDIFF without seconds?
yaoki_dokidoki 2015/04/03
TIME_FORMAT()ã‚’ä½¿ã†

sql
ãƒªãƒ³ã‚¯
CASEå¼ã®ã‚¹ã‚¹ãƒ¡ / ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
yaoki_dokidoki 2015/03/31
å‹‰å¼·ã«ãªã‚‹

sql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
yaoki_dokidoki 2015/03/30
sql
ãƒªãƒ³ã‚¯
æ—¥ä»˜ã¨æ™‚åˆ»é–¢æ•° - ç¬¬4ç« é–¢æ•° - [SMART]
æ—¥ä»˜ã¨æ™‚åˆ»é–¢æ•°ã«ã¯ã€ä½¿ã„å‹æ‰‹ã®è‰¯ã„é–¢æ•°ãŒå¤šæ•°ã‚ã‚Šã¾ã™ã€‚ç¾åœ¨ã®æ—¥ä»˜ã‚„æ™‚åˆ»ã€2ã¤ã®æœŸé–“ã®å·®ã‚’å•ã„åˆã‚ã›ãŸã‚Šã€æ—¥ä»˜ã®æ¼”ç®—ã‚„æ—¥ä»˜ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚’å‡¦ç†ã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ã¾ãŸã€WHEREå¥ã§åˆ©ç”¨ã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã®ã§ã€æ¤œç´¢æ¡ä»¶ã§åˆ©ç”¨ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã¨ã¯ ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã¨ã¯ã€ãŸã¨ãˆã°æ•°å€¤ãŒæ±‚ã‚ã‚‰ã‚Œã¦ã„ã‚‹å ´åˆã¯æ•°å€¤ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã€è¤‡æ•°ã®å€¤ãŒæ±‚ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã¨ãã¯ãƒªã‚¹ãƒˆã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã¨ã„ã†ã‚ˆã†ã«ã€æ§˜ã€…ãªå€¤ã‚’æ‰±ã†ã¨ãã®æ¦‚å¿µã®ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ CURDATE() / CURRENT_DATE() ç¾åœ¨ã®æ—¥ä»˜ã‚’è¿”ã™ CURRENT_DATE()ã¯ã€ç¾åœ¨ã®æ—¥ä»˜ã‚’è¿”ã—ã¾ã™ã€‚CURRENT_DATE()ã¯ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã«ã‚ˆã£ã¦è¿”å´å€¤ãŒå¤‰ã‚ã‚‹é–¢æ•°ã§ã€æ•°å€¤ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã®å ´åˆã¯YYYYMMDDå½¢å¼ã€ãã‚Œä»¥å¤–ã¯YYYY-MM-DDå½¢å¼ã§è¿”ã—ã¾ã™ã€‚CURDATE()ã¯ã€CURRENT_DATE()ã®åˆ¥åã§ã™ã€‚ ç¾åœ¨
yaoki_dokidoki 2015/03/11
sql
ãƒªãƒ³ã‚¯
Thematic WordPress Theme Toolbox: 10 extremely useful hooks
After years of usage, your WordPress database can contain weird characters, be filled with data you donâ€™t need anymore, and so on. In this article, you will learn about SQL queries to clean up your WordPress database. Two things to note: First, any of these queries should be preceded by a backup of your whole database. Secondly, donâ€™t forget to replace the wp_ table prefix by the prefix used on yo
yaoki_dokidoki 2015/03/03
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åŠ é€Ÿã™ã‚‹ãŸã‚ã®10ã®SQLãƒ†ã‚£ãƒƒãƒ—ã‚¹

sql
ãƒªãƒ³ã‚¯
è¤‡æ•°ã‚«ãƒ©ãƒ ã§ãƒ¦ãƒ‹ãƒ¼ã‚¯ã‚ãƒ¼ã‚’ä½œã‚‹ - æ®ç™ºæ€§ã®ãƒ¡ãƒ¢ï¼’
è¤‡æ•°ã‚«ãƒ©ãƒ ã§ãƒ¦ãƒ‹ãƒ¼ã‚¯ã‚ãƒ¼ã‚’ä½œã‚ŠãŸã„ã¨ãã€é‡è¤‡ãŒã‚ã‚‹ã¨ã‚¨ãƒ©ãƒ¼ã«ãªã‚‹ mysql> ALTER TABLE hoge ADD UNIQUE (a,b,c); ERROR 1062 (23000): Duplicate entry 'aiueokakikukekoaaaaa' for key 2 IGNOREã‚’ã¤ã‘ã‚‹ã¨ã€é‡è¤‡ã—ãŸã‚«ãƒ©ãƒ ã¯æœ€åˆã®åˆ†ã ã‘æŽ¡ç”¨ã•ã‚Œã¦æ£å¸¸çµ‚äº†ã™ã‚‹ mysql> ALTER IGNORE TABLE hoge ADD UNIQUE (a,b,c); Query OK, 225165 rows affected (52.52 sec) Records: 225165 Duplicates: 1385 Warnings: 0 ã²ã¨ã¤ã®ã‚«ãƒ©ãƒ ã«ãƒ¦ãƒ‹ãƒ¼ã‚¯ã‚ãƒ¼ã‚’ä½œã‚ŠãŸã„ã ã‘ãªã‚‰ã€é‡è¤‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å‰Šé™¤ã—ã¦ã—ã¾ãˆã°å¤§ä½“å•é¡Œãªã„ DELETE FROM hoge WHERE a in (SE
yaoki_dokidoki 2015/03/03
ALTER ã¨ ADD ã§ãƒ¦ãƒ‹ãƒ¼ã‚¯åˆ¶ç´„ã‚’è¿½åŠ

sql

mysql
ãƒªãƒ³ã‚¯
SQLServer(T-SQL)ã§1è¡Œã®INSERTæ–‡ã§è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚’æŒ¿å…¥ã™ã‚‹æ–¹æ³•
SQLServer(T-SQL)ã§1è¡Œã®Insertæ–‡ã§è¤‡æ•°ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¸€æ°—ã«æŒ¿å…¥ã™ã‚‹ã“ã¨ã¯ã§ããªã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ å®Ÿã¯SQLServer(T-SQL)ã§1è¡Œã®INSERTæ–‡ã§è¤‡æ•°ä»¶æŒ¿å…¥ã™ã‚‹ã«ã¯ã€ŒVALUESä»¥é™ã‚’ã‚«ãƒ³ãƒžã§åŒºåˆ‡ã£ã¦ã€æ¸¡ã›ã°æŒ¿å…¥ã§ãã¾ã™ã€‚ ãŸã ã—æŒ¿å…¥ã§ãã‚‹ã®ã¯æœ€å¤§1000è¡Œã¾ã§ã§ã™ã€‚ ãã‚Œä»¥ä¸Šã®å ´åˆã¯INSERTæ–‡ã‚’åˆ†ã‘ã¦å®Ÿè¡Œã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ å…·ä½“çš„ã«ã¯é€šå¸¸ã®Insertæ–‡ã®VALUESä»¥é™ã‚’ã€Œ,ï¼ˆã‚«ãƒ³ãƒžï¼‰ã€ã§ç¶šã‘ã¦æ›¸ã„ã¦ã„ãã“ã¨ã§å¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ INSERT INTO test_table VALUES ( 1, 'NAME1', 10 ) ,( 2, 'NAME2', 20 ) ,... æ³¨æ„ã¨ã—ã¦ã¯ï¼‘ã¤ã§ã‚‚ã‚¨ãƒ©ãƒ¼ã®ç™ºç”Ÿã™ã‚‹VALUESãŒå˜åœ¨ã™ã‚‹ã¨ã€ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ãŒæŒ¿å…¥ãŒCommitï¼ˆã‚³ãƒŸãƒƒãƒˆï¼‰ã•ã‚ŒãšRollBackï¼ˆãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ï¼‰ã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ï¼ˆ1ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚‚
yaoki_dokidoki 2014/09/17
sql
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ã‚¯ãƒžã‚„blogç‰ã§æœ€è¿‘ã‚ˆãè¦‹ã‹ã‘ã‚‹ã€Œã‚¿ã‚°ã€ã‚·ã‚¹ãƒ†ãƒ ã«ã¤ã„ã¦ã€‚â€¦
ã¯ã¦ãªãƒ–ã‚¯ãƒžã‚„blogç‰ã§æœ€è¿‘ã‚ˆãè¦‹ã‹ã‘ã‚‹ã€Œã‚¿ã‚°ã€ã‚·ã‚¹ãƒ†ãƒ ã«ã¤ã„ã¦ã€‚ è‡ªåˆ†ã®ã‚µã‚¤ãƒˆã®å•†å“ã«ã€ ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒè‡ªåˆ†ã§ã€Œã‚¿ã‚°ã€ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã«ã¯ã€ ã©ã†ã„ã†è¨è¨ˆã‚’ã™ã‚Œã°ã„ã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ mysql/phpã§æ§‹ç¯‰ã—ã¦ã„ã¾ã™ã€‚ ï¼¡å•†å“ã«ã€ ãƒ¦ãƒ¼ã‚¶ï¼¸ãŒã€Œã‚ã€ã€Œã„ã€ã€Œã† ãˆã€ã¨ã„ã†ã‚¿ã‚°ã‚’ã¤ã‘ã€ ãƒ¦ãƒ¼ã‚¶ï¼¹ãŒã€Œã‚ã€ã€ŒãŠã€ã¨ã‚¿ã‚°ã‚’ã¤ã‘ãŸå ´åˆã€ ï¼¡å•†å“ãƒšãƒ¼ã‚¸ã« ã€Œã‚ã€ã€Œã„ã€ã€Œã† ãˆã€ã€ŒãŠã€ã®ã‚¿ã‚°ä¸€è¦§ãŒè¡¨ç¤ºã•ã‚Œã€ã€Œã‚ã€ã¯ï¼’å€‹ã¤ã„ã¦ã‚‹ã®ã§æ–‡å—ã‚’å¤§ããã™ã‚‹ã€ã¨ã„ã†ã‚ˆã†ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã™ã€‚ ã‚¿ã‚°ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã£ã¦ã€ å•†å“åï¼šãƒ¦ãƒ¼ã‚¶ï¼©ï¼¤ï¼šã‚¿ã‚°ã€€ãªã©ã®ã‚«ãƒ©ãƒ ä¸€è¦§ã§ã€ ã‚¿ã‚°ã‚«ãƒ©ãƒ ã«ã‚¿ã‚°ã‚’ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šãªã©ã§å…¥ã‚Œã¦ã„ã£ã¦ã‚‹ã®ã‹ãªãã€ãªã‚“ã¦æƒ³åƒã—ã¦ã¾ã™ã€‚ ã‚¢ãƒ‰ãƒã‚¤ã‚¹ã‚„ã€å‚è€ƒã«ãªã‚Šãã†ãªã‚µã‚¤ãƒˆã‚’æ•™ãˆã¦é ‚ã‘ã¾ã™ã¨ã†ã‚Œã—ã„ã§ã™ã€‚
yaoki_dokidoki 2014/08/20
sql

taxonomy
ãƒªãƒ³ã‚¯
CTOAæ—¥è¨˜:MySQL selectçµæžœã§updateã™ã‚‹ - livedoor Blogï¼ˆãƒ–ãƒã‚°ï¼‰
yaoki_dokidoki 2014/02/21
ã§ããŸã€œ

sql
ãƒªãƒ³ã‚¯
DBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºç¤Žï¼šã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å…¥é–€
2. è‡ªå·±ç´¹ä»‹ ä¸‹ä½ç²‰ æ˜ ( ã—ã‚‚ã•ã“ ã‚ãã‚‰ ) å’ŒæŒå±±çœŒç”Ÿã¾ã‚Œ 2001å¹´ IBMã«ä¸é€”å…¥ç¤¾ ä»¥æ¥ã€DB2é–¢é€£ã®ä»•äº‹å¤šã— ç¾åœ¨ã¯ãƒ“ã‚¸ãƒã‚¹ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼æ§˜å‘ã‘æŠ€è¡“æ”¯æ´ â– æ›¸ç± ã€Œå³æˆ¦åŠ›ã®DB2ç®¡ç†è¡“ã€ â€“ http://db2.jugem.cc/?eid=2341 ï¼ˆæ›¸ç±ç´¹ä»‹ï¼‰ ã€ŒXML-DBé–‹ç™º å®ŸæŠ€ã‚³ãƒ¼ã‚¹ã€ï¼ˆå…±è‘—ï¼‰ ã€ŒDB2 é€†å¼•ããƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ï¼ˆå…±è‘—) â– ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ Twitter - @simosako å…¨å†…å®¹ã‚’WEBã§å…¬é–‹ã—ã¦ã„ã¾ã™ â€“ http://twitter.com/simosako http://db2watch.com/ Unofficial DB2 Blog â€“ http://db2.jugem.cc/ 2 3. ä»Šæ—¥ã®ãƒ†ãƒ¼ãƒž RDBã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã£ã¦ï¼Ÿ â€“ã‚¤ãƒ³ãƒ‡ã‚¯ã‚¹ã‚’ä½œæˆã™ã‚‹ã¨ã€é€Ÿåº¦ãŒä¸ŠãŒã‚‹ï¼ â€“ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä½œæˆã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ã‚ãƒ¢ï¼ ...ã§ã‚‚ã€ãª
yaoki_dokidoki 2014/02/04
sql

database
ãƒªãƒ³ã‚¯
ç‰å· - Wikipedia
ã€Œ=ã€ã¯ã“ã®é …ç›®ã¸è»¢é€ã•ã‚Œã¦ã„ã¾ã™ã€‚ã‚¨ãƒ‰ãƒ»ã‚·ãƒ¼ãƒ©ãƒ³ã®ã‚¢ãƒ«ãƒãƒ ã«ã¤ã„ã¦ã¯ã€Œ%3D (ã‚¨ãƒ‰ãƒ»ã‚·ãƒ¼ãƒ©ãƒ³ã®ã‚¢ãƒ«ãƒãƒ )ã€ã‚’ã”è¦§ãã ã•ã„ã€‚ ã€Œâ‰’ã€ã¯ã“ã®é …ç›®ã¸è»¢é€ã•ã‚Œã¦ã„ã¾ã™ã€‚ è¿‘ä¼¼çš„ã«ç‰ã—ã„ã“ã¨ã«ã¤ã„ã¦ã¯ã€Œè¿‘ä¼¼ã€ã‚’ã”è¦§ãã ã•ã„ã€‚ BLUE ENCOUNTã®ã‚¢ãƒ«ãƒãƒ ã«ã¤ã„ã¦ã¯ã€Œâ‰’ (ã‚¢ãƒ«ãƒãƒ )ã€ã‚’ã”è¦§ãã ã•ã„ã€‚ ã‚€ã‚‰ãŸãŸã„ã¡ã®4ã‚³ãƒžæ¼«ç”»ä½œå“ã«ã¤ã„ã¦ã¯ã€Œâ‰’-ãƒ‹ã‚¢ãƒ»ã‚¤ã‚³ãƒ¼ãƒ«-ã€ã‚’ã”è¦§ãã ã•ã„ã€‚
yaoki_dokidoki 2014/01/09
ã€Œä»£å…¥æ¼”ç®—åã¯Pascalã‚„PL/SQLãªã©ã§ã¯ã€Œ:=ã€ï¼ˆã‚³ãƒãƒ³ã‚¤ã‚³ãƒ¼ãƒ«ï¼‰ã€ãªã‚‹ã»ã©ã€‚

sql

mathematics
ãƒªãƒ³ã‚¯
MySQLã§Oracleã®rownumã®ã‚ˆã†ãªè¡Œç•ªå·ã‚’ä»˜åŠ ã™ã‚‹ - ã‚¨ãƒžãƒŽãƒ³ã®é›‘è¨˜å¸³
MySQLã§Oracleã®rownumã®ã‚ˆã†ãªè¡Œç•ªå·ã‚’ä»˜åŠ ã™ã‚‹æ–¹æ³•ã¨ã—ã¦ã€Webä¸Šã§ã‚ˆãè¦‹ã‹ã‘ã‚‹ã®ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ¦ãƒ¼ã‚¶ãƒ¼å¤‰æ•°ã‚’ä½¿ã£ãŸSQLæ–‡ã§ã€2ã¤ã®SQLæ–‡ã‚’ç™ºè¡Œã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ set @i:=0; select @i:=@i+1 as rownum,user_id from user; ã—ã‹ã—ã€kotori::logã§ç´¹ä»‹ã•ã‚Œã¦ã„ãŸæ–¹æ³•ã‚’ç”¨ã„ã‚Œã°ã€ï¼‘å›žã®SQLæ–‡ã§ä»˜åŠ ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ãƒ¡ãƒ¢ãƒ¡ãƒ¢ã€‚ select @i:=@i+1 as rownum,user_id from (select @i:=0) as dummy,user; ãªã‚‹ã»ã©ã€‚ã‚µãƒ–ã‚¯ã‚¨ãƒªã§ãƒ¦ãƒ¼ã‚¶ãƒ¼å¤‰æ•°ã‚’åˆæœŸåŒ–ã—ã¦ã„ã‚‹ã®ãã€‚ ã§ã€ãµã¨order byç¯€ã§ä¸¦ã³æ›¿ãˆãŸæ™‚ã®æŒ™å‹•ãŒæ°—ã«ãªã£ãŸã®ã§ã€æ—©é€Ÿè©¦ã—ã¦ã¿ãŸã€‚ å…¨éƒ¨ã§ï¼”ã¤è©¦ã—ã¦ã„ã¦ã€å§‹ã‚ã®ï¼’ã¤ãŒãƒ†ãƒ¼ãƒ–ãƒ«ã®idã‚«ãƒ©ãƒ ã§ä¸¦ã³æ›¿ãˆ(æ˜‡é †ã€é™é †)ã€æ®‹ã‚Šã®ï¼’ã¤(ï¼“ã¤ç›®ã¨ï¼”ã¤ç›®)ãŒç”Ÿ
yaoki_dokidoki 2014/01/09
ã¸ãƒ¼ã€‚@i:=@i+1ã¿ãŸã„ãªæ¼”ç®—åãŒã‚ˆãåˆ†ã‹ã‚‰ãªã„ã‘ã©ã€ã“ã‚Œã§ã§ããŸã€‚

sql
ãƒªãƒ³ã‚¯
ã‚¨ãƒã‚²ãƒ¼ãƒžãƒ¼ã®ãŸã‚ã®SQL -ã‚¨ãƒã‚²ãƒ¼ãƒžãƒ¼ã®ãŸã‚ã®SQL-
SQLã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã—ãŸã‚Šã™ã‚‹ãŸã‚ã®è¨€èªžã§ã™ã€‚ ã“ã®æ–‡æ›¸ã¯ã€ErogameScapeã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰SELECTã‚’ä½¿ã£ã¦è‡ªç”±è‡ªåœ¨ã«ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã“ã¨ã‚’ç›®æ¨™ã«ã—ã¾ã™ã€‚ ã‚¨ãƒã‚²ãƒ¼ã‚’ã‚„ã‚Šã¯ã˜ã‚ã‚‹å¤§å¦ç”Ÿãã‚‰ã„ã®ã¨ãã«ã€å¤§å¦ã®è¬›ç¾©ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã‚“ã§ã€é€€å±ˆã ãªãƒ¼ã¨æ€ã£ãŸæ™‚ã«ã€ErogameScapeã§SQLã‚’å¦ã¶ã“ã¨ã§ã€å°‘ã—ã§ã‚‚SQLã«èˆˆå‘³ã‚’æŒã£ã¦ã€è‡ªèº«ã§ãƒ‡ãƒ¼ã‚¿ã‚’åŠ å·¥ã™ã‚‹ã“ã¨ã‚’å¦ç¿’ã—ã¦é ‚ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚ â€»ç§ã®å¤§å¦ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æŽˆæ¥ã§ã¯ã€è‡ªåˆ†ã®èº«ã®å›žã‚Šã®ä½•ã‹ã‚’ERå›³ã«è½ã¨ã—è¾¼ã‚“ã§ã€DBã‚’è¨è¨ˆã—ã€PostgreSQLã«å®Ÿè£…ã—ã€å®Ÿéš›ã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ›ã—ã¦SELECTã—ã¦ã¿ã‚‹ã¨ã“ã‚ã¾ã§ã‚’ã‚„ã‚Šã¾ã—ãŸã€‚ ERå›³ã¨ã„ã†æ¦‚å¿µã‚’å¦ã‚“ã ã¨ãã€Œã‚ã‚ã€ã“ã‚Œã¯é¢ç™½ã„ã€ã¨æ€ã„ã¾ã—ãŸã€‚ å…ˆç”Ÿã¯ã“ã†è¨€ã£ãŸã®ã§ã™ã€‚ ã€ŒERå›³ã«è½ã¨ã—è¾¼ã‚€ã¨ã€æ€ã„ã‚‚ã‚ˆã‚‰ãªã‹ã£ãŸã“ã¨ãŒåˆ†ã‹ã‚‹ã€‚ã€ã¨ã€‚ å½“æ™‚ã€
yaoki_dokidoki 2014/01/09
sql
ãƒªãƒ³ã‚¯
æ—¥ä»˜ã®è¨ˆç®— - SQL(MySQL,ORACLE)
MySQLã‚„ORACLEã§ æ—¥ä»˜ã®è¶³ã—ç®—ã€å¼•ãç®—ã‚’ã™ã‚‹ä¾‹ã§ã™ã€‚ MySQLæ—¥ä»˜ã®è¨ˆç®— ï¼“æ—¥å¾Œã®æ—¥ä»˜ã‚’å–å¾—ã™ã‚‹ 3æ—¥å¾Œã®æ—¥ä»˜ã‚’å–å¾—ã™ã‚‹ä¾‹ã§ã™ã€‚ ä½¿ç”¨ä¾‹ mysql> SELECT date_add(current_date, interval 3 day); +----------------------------------------+ | date_add(current_date, interval 3 day) | +----------------------------------------+ | 2006-11-26 | +----------------------------------------+ ï¼“æ—¥å‰ã®æ—¥ä»˜ã‚’å–å¾—ã™ã‚‹ 3æ—¥å‰ã®æ—¥ä»˜ã‚’å–å¾—ã™ã‚‹ä¾‹ã§ã™ã€‚ ä½¿ç”¨ä¾‹ mysql> SELECT date_add(current_date, interval -3 day
yaoki_dokidoki 2013/12/05
æš—è¨˜ã—ãŸã„ã‘ã©ã™ãã‚ã™ã‚Œã‚‹

sql
ãƒªãƒ³ã‚¯
SELECTæ–‡ã®å‡¦ç†ã®ä»•çµ„ã¿ã‚’èª¬æ˜Žã—ã¦ã¿ãŸã€‚ - ã„ã‚ã„ã‚è§£æžæ—¥è¨˜
SQLã®SELECTæ–‡ã¯éžå¸¸ã«å¼·åŠ›ã§ã™ã€‚SQLã‚’ä½¿ã†ã¨è¤‡é›‘ãªå‡¦ç†ã‚‚çŸã„å‘½ä»¤ã§è¡Œãˆã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã§ã™ãŒã€è¤‡é›‘ãªå‡¦ç†ã‚’è¡Œã†SELECTæ–‡ã‚’æ›¸ããŸã‚ã«ã¯ã€SELECTæ–‡ã®å‡¦ç†ã®ä»•çµ„ã¿ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ãã“ã§ã€ä»Šå›žã¯SELECTæ–‡ã®å‡¦ç†ã®ä»•çµ„ã¿ã‚’ã€å†…éƒ¨çš„ãªå‡¦ç†æ‰‹é †ã‚’ä»®å®šã—ã¦èª¬æ˜Žã—ã¦ã¿ã¾ã™ã€‚*1 ãªãŠã€ä»Šå›žã¯ä¸€ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹å‡¦ç†ã®ã¿ã‚’èª¬æ˜Žã—ã¾ã™ã€‚è¤‡æ•°ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµåˆã¯èª¬æ˜Žã—ã¾ã›ã‚“ã€‚ ç›®æ¬¡ SELECTæ–‡ã®å‡¦ç†ã®åŸºæœ¬ã€‚ SELECTæ–‡ã®å‡¦ç†ã¯äºŒã¤ã«åˆ†ã‘ã‚‰ã‚Œã‚‹ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä¸€è¡Œãšã¤å‡¦ç†ã™ã‚‹ã€‚ æ¡ä»¶ã«å½“ã¦ã¯ã¾ã‚‹è¡Œã‚’å‡ºåŠ›ã™ã‚‹ã€‚ å‡ºåŠ›é …ç›®ã‚’ç·¨é›†ã™ã‚‹ è¤‡é›‘ãªæ¡ä»¶ã‚’æŒ‡å®šã™ã‚‹ å‡ºåŠ›çµæžœã‚’ä¸¦ã¹æ›¿ãˆã‚‹ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«å†…ã®è¤‡æ•°ã®è¡Œã‚’é›†ç´„ã™ã‚‹ã€‚ ã™ã¹ã¦ã®è¡Œã‚’é›†ç´„ã™ã‚‹ã€‚ ã‚°ãƒ«ãƒ¼ãƒ—æ¯Žã«é›†ç´„ã™ã‚‹ã€‚ SELECTæ–‡ã®å‡¦ç†ã®åŸºæœ¬ã€‚ SELECTæ–‡ã®å†…éƒ¨çš„ãªå‡¦ç†ã®åŸºæœ¬ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®å„è¡Œã«å¯¾ã™ã‚‹ç¹°ã‚Šè¿”ã—å‡¦ç†ã§
yaoki_dokidoki 2013/12/05
ã„ã„ãª

sql
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
yaoki_dokidoki 2013/11/15
ã„ã„ã€‚

sql
ãƒªãƒ³ã‚¯
ã€ŽMySQLã®UNIONæ§‹æ–‡ã¨ã‹ã§è©¦è¡ŒéŒ¯èª¤ã—ãŸãƒ¡ãƒ¢ã€
æŽ²ç¤ºæ¿ï¼ˆã§ã‚‚ãªã‚“ã§ã‚‚ã„ã„ãŒï¼‰ã‚’ä½œã‚‹ã«ã‚ãŸã‚Šã€ãŸã¨ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãã£ã¤ã‘ã¦ã‹ã‚‰è¨˜äº‹ã‚’å–å¾—ã™ã‚‹ã€‚ mysql> (SELECT id, user, message, create_date FROM BBS_MESSAGE) -> UNION -> (SELECT id, user, message, create_date FROM BBS_REPLY) -> ORDER BY create_date DESC -> LIMIT 0, 5 -> ; ã“ã®å ´åˆã€ã€Œè¨˜äº‹æ•°ã€ã‚’å–å¾—ã™ã‚‹ã«ã¯ã©ã†ã™ã‚Œã°ã„ã„ã‹ï¼Ÿ æœ€åˆã«è©¦ã—ãŸã®ãŒä»¥ä¸‹ã®SQLã€‚ mysql> SELECT count(*) FROM ( -> (SELECT id FROM BBS_MESSAGE) -> UNION -> (SELECT id FROM BBS_REPLY) -> ); ã“ã‚Œã¯å¤±æ•—ã™ã‚‹ã€‚ ERROR 124
yaoki_dokidoki 2013/10/02
ã€ŒFROMã®ã‚ã¨ã®å‰¯å•ã„åˆã‚ã›ãŒUNIONæ§‹æ–‡ãªã¨ãã«ã¯ã€å›ºæœ‰ã®åå‰ã‚’ä»˜ã‘ã¦ã‚ã’ãªã„ã¨é§„ç›®ã€

sql
ãƒªãƒ³ã‚¯
Amazon.co.jp: SQL ã‚¼ãƒã‹ã‚‰ã¯ã˜ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œ: ãƒŸãƒƒã‚¯: Digital Ebook Purchas
yaoki_dokidoki 2013/10/02
çµ¶è³›ã•ã‚Œã¦ã‚‹ãªãƒ¼

SQL

book
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸