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

waterwalker id:waterwalker

SQLã«é–¢ã™ã‚‹waterwalkerã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã€Œã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯åˆè¦‹ã®æ•µã«ã‚„ã‚‰ã‚Œã¦ã¯ã„ã‘ãªã„ã€DBã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒŸãƒƒã‚¯ã•ã‚“ãŒèªžã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨SQLã®å¦ã³æ–¹
ITæ¥ç•Œã«ãŠã„ã¦æ•°åå¹´ã‚‚ã®é–“ã€å¤§ããªä»•æ§˜å¤‰æ›´ãŒãªãä¸»æµã®æŠ€è¡“ã§ã‚ã‚Šç¶šã‘ã¦ã„ã‚‹ã®ãŒãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨SQLã§ã™ã€‚ã€ŽSQL ç¬¬2ç‰ˆ ã‚¼ãƒã‹ã‚‰ã¯ã˜ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã€ã®è‘—è€…ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒŸãƒƒã‚¯ã•ã‚“ã¯ã€SQLã‚’å¦ã¹ã°é•·ãå½¹ç«‹ã¤ã‚‚ã®ã®ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é…åŠ›ã¯ãã‚Œè‡ªä½“ã®é¢ç™½ã•ã ã¨ãŠã£ã—ã‚ƒã„ã¾ã™ã€‚ä»Šå›žã€ãƒŸãƒƒã‚¯ã•ã‚“ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å½¹å‰²ã‚„é…åŠ›ã€ãã—ã¦SQLã®å¦ã³æ–¹ã«ã¤ã„ã¦ã†ã‹ãŒã„ã¾ã—ãŸã€‚ ã„ã‚ã„ã‚ãªã‚·ã‚¹ãƒ†ãƒ ã‚’è¦‹ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ãŒé¢ç™½ã„ â€•â€•ãƒŸãƒƒã‚¯ã•ã‚“ã¯ã€ŽSQL ç¬¬2ç‰ˆ ã‚¼ãƒã‹ã‚‰ã¯ã˜ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã€ã®ã»ã‹ã«ã‚‚ã€ç¿”æ³³ç¤¾ã‹ã‚‰å¤šæ•°å‡ºç‰ˆã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨SQLã®æ›¸ç±ãŒä¸»ã§ã™ãŒã€æ™®æ®µã¯ã©ã†ã„ã£ãŸä»•äº‹ã‚’ã•ã‚Œã¦ã„ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ ãƒŸãƒƒã‚¯ï¼šç§ã¯SIerã«å‹¤ã‚ã¦ã„ã¦ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã¨ã„ã†ã‚ˆã‚Šã¯ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã§ãƒˆãƒ©ãƒ–ãƒ«ãŒèµ·ããŸã¨ãæ”¯æ´ã‚’è¡Œãªã†ãƒãƒ¼ãƒ ã«æ‰€å±žã—ã¦ã„ã¾ã™ã€‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’é«˜ã‚ã‚‹ã“ã¨ãŒ
waterwalker 2016/06/27
ä»•äº‹

SQL
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«
A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
waterwalker 2012/09/19
DBæ“ä½œç”¨ã®GUIãƒ„ãƒ¼ãƒ«ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã®é››å½¢ç”ŸæˆãŒå¼·åŠ›éŽãŽã‚‹ã€‚

SQL

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
PostgreSQL ã® COPY ã‚³ãƒžãƒ³ãƒ‰ã¨ SQL ã ã‘ã§æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ - hoge256ãƒ–ãƒã‚°
PostgreSQL ã® COPY ã‚³ãƒžãƒ³ãƒ‰ã¨ SQL ã ã‘ã‚’ä½¿ã£ã¦ã€ã„ã‚ã„ã‚ãªãƒ‡ãƒ¼ã‚¿ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãŒå¾—æ„ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚ã‚“ã¾ã‚Šå¾—æ„ã˜ã‚ƒãªã„ã£ã¦ã„ã†äººã ã¨ã€ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹éš›ã«ã€ä½•ã§ã‚‚ã‹ã‚“ã§ã‚‚ã‚´ãƒªã‚´ãƒªã¨ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ã„ã¦æ¸ˆã¾ã›ã¦ã—ã¾ã†ã“ã¨ãŒå¤šã„ã‹ã¨æ€ã„ã¾ã™ãŒã€COPY ã‚³ãƒžãƒ³ãƒ‰ã¨ SQL ã ã‘ã§ã‚‚çµæ§‹è¤‡é›‘ãªãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã“ã¨ãŒã§ããŸã‚Šã—ã¾ã™ã®ã§ã€ç°¡å˜ã«ç´¹ä»‹ã—ã¦ã¿ã¾ã™ã€‚ ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã‚’ã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã—ãªãŒã‚‰ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ ä¾‹ãˆã°ã€æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ user_no_seq ã¨ã„ã†ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ãŒã‚ã£ãŸã¨ã—ã¾ã™ã€‚ user_no | user_name | total_score ---------+-----------+------------- 1 | A | 120 2 | B | 130 3 | C | 9
waterwalker 2012/01/17
SQL
ãƒªãƒ³ã‚¯
PostgreSQL ALTER TABLEã‚’ä½¿ã‚ãªã„ã‚«ãƒ©ãƒ è¿½åŠ æ‰‹é † - 130å˜ä½
testtable column_A,column_B,column_C ã“ã‚“ãªãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã£ã¦ã€æ—¢ã«ã„ãã¤ã‹ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ã¦ã„ã‚‹ã€‚ã§ã€æ–°ãŸã«ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã—ãŸã„ã‚“ã ã‘ã©ã€é€”ä¸ã®column_Bã¨column_Cã®é–“ã«è¿½åŠ ã—ãŸã„ã€‚ã§ã‚‚ã€ŒALTER TABLEã€ã ã¨æœ«å°¾ã«ã‚«ãƒ©ãƒ ãŒã§ãã¦ã—ã¾ã†ã®ã§ã€ãã‚Œã¯é¿ã‘ãŸã„ã€‚ ãã‚“ãªå ´åˆã§ã€pgAdminã®æ©Ÿèƒ½ã‚’ä½¿ã£ãŸã‚Šã›ãšã«SQLã®ã¿ã§ã‚«ãƒ©ãƒ è¿½åŠ ã‚’è¡Œã†æ‰‹é †ã€‚ --1.å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆ CREATE TABLE testtable_bak AS ( SELECT * FROM testtable ); --2.å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å‰Šé™¤ DROP TABLE testtable CASCADE; --3.ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã—ãŸæ–°ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆ CREATE TABLE testtable ( column_A decimal(15) NOT NUL
waterwalker 2011/05/12
PostgreSQL

SQL

ALTER
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

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

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Chromeæ‹¡å¼µæ©Ÿèƒ½ã«ã¤ã„ã¦ã®ãŠçŸ¥ã‚‰ã›ã¨æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã”åˆ©ç”¨ã®ãŠé¡˜ã„

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

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

A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«

PostgreSQL ã® COPY ã‚³ãƒžãƒ³ãƒ‰ã¨ SQL ã ã‘ã§æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ - hoge256ãƒ–ãƒ­ã‚°

PostgreSQL ALTER TABLEã‚’ä½¿ã‚ãªã„ã‚«ãƒ©ãƒ è¿½åŠ æ‰‹é † - 130å˜ä½

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Chromeæ‹¡å¼µæ©Ÿèƒ½ã«ã¤ã„ã¦ã®ãŠçŸ¥ã‚‰ã›ã¨æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã”åˆ©ç”¨ã®ãŠé¡˜ã„

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (4)

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

A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«

PostgreSQL ã® COPY ã‚³ãƒžãƒ³ãƒ‰ã¨ SQL ã ã‘ã§æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ - hoge256ãƒ–ãƒã‚°

PostgreSQL ALTER TABLEã‚’ä½¿ã‚ãªã„ã‚«ãƒ©ãƒ è¿½åŠ æ‰‹é † - 130å˜ä½

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Chromeæ‹¡å¼µæ©Ÿèƒ½ã«ã¤ã„ã¦ã®ãŠçŸ¥ã‚‰ã›ã¨æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã”åˆ©ç”¨ã®ãŠé¡˜ã„

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹