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

sirocco634 id:sirocco634

sqlã«é–¢ã™ã‚‹sirocco634ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

SQLiteå…¥é–€:SQLiteã®ãƒ‡ãƒ¼ã‚¿åž‹:SQLiteã§åˆ©ç”¨å¯èƒ½ãªãƒ‡ãƒ¼ã‚¿åž‹
ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¯å€¤ã‚’æ ¼ç´ã™ã‚‹ãŸã‚ã®ã‚«ãƒ©ãƒ ã‚’å®šç¾©ã—ã¾ã™ãŒã€ã©ã®ã‚«ãƒ©ãƒ ã«ã©ã®ã‚ˆã†ãªå€¤ã‚’æ ¼ç´ã™ã‚‹ã‹ã«å¿œã˜ã¦ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã“ã§ã¯ SQLite ã®ã‚«ãƒ©ãƒ ã§æŒ‡å®šå¯èƒ½ãªãƒ‡ãƒ¼ã‚¿åž‹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ æ ¼ç´ã•ã‚Œã‚‹å€¤ã®ãƒ‡ãƒ¼ã‚¿åž‹ å¤šãã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã‚«ãƒ©ãƒ æ¯Žã«ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã—ã¾ã™ã€‚ãã®ç‚ºã€ã‚«ãƒ©ãƒ æ¯Žã«æ ¼ç´ã§ãã‚‹å€¤ãŒæ±ºã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚SQLite ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å®šç¾©ã™ã‚‹æ™‚ã«ã‚«ãƒ©ãƒ æ¯Žã«ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã¯å¿…é ˆã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã—ãªã‹ã£ãŸã‚«ãƒ©ãƒ ã«ã¯è‰²ã€…ãªåž‹ã®å€¤ãŒæ ¼ç´ã•ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ãŸã ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã—ãªã‹ã£ãŸå ´åˆã§ã‚‚ã‚«ãƒ©ãƒ ã«æ ¼ç´ã•ã‚ŒãŸå€¤ãŒã©ã‚“ãªãƒ‡ãƒ¼ã‚¿åž‹ãªã®ã‹ã¯åŒºåˆ¥ã—ã¦ã„ã¦ã€ŒNULLã€ã€ŒINTEGERã€ã€ŒREALã€ã€ŒTEXTã€ã€ŒBLOBã€ã®5ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿åž‹ã«åˆ†é¡žã—ã¾ã™ã€‚ NULL NULLå€¤ INTEGER ç¬¦å·ä»˜æ•´æ•°ã€‚1, 2, 3, 4, 6, or 8 ãƒã‚¤ãƒˆã§æ ¼ç´ R
sirocco634 2010/05/13
SQLiteã§åˆ©ç”¨å¯èƒ½ãªãƒ‡ãƒ¼ã‚¿åž‹

sqlite

sql
ãƒªãƒ³ã‚¯
MacPortsã‚’ä½¿ã£ã¦Macã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - æ‹¡å¼µç¾å®Ÿãƒ©ã‚¤ãƒ•
ç§ã€é¤¡åã®ãŸã‚ãªã‚‰é€†ç«‹ã¡ã ã£ã¦ã—ã¾ã™ã‚ˆã€‚ ã“ã˜ã‚‰ã›ã¦ã„ã‚‹ã€‚ é£Ÿã¹ãŸã„ã¨æ€ã£ãŸã‚‰é£Ÿã¹ãŸã„ã®ã§ã‚ã‚‹ã€‚ ã“ã“ãŒåŒ—ã‚«ãƒªãƒ•ã‚©ãƒ«ãƒ‹ã‚¢ã®ç‰‡ç”°èˆŽã§ã‚ã‚ã†ã¨ã€ç§ãŒã‚ã‚“ã¿ã¤ãŒé£Ÿã¹ãŸã„ã¨æ€ãˆã°ã€ã‚ã‚“ã¿ã¤ã¯ä»Šã™ãä½œã£ã¦é£Ÿã¹ãªãã¦ã¯ã„ã‘ãªã„ã‚‚ã®ã«ãªã‚‹ã€‚é£Ÿã„ã—ã‚“åŠã®æ€è€ƒã¯å‡„ã¾ã˜ã„ã€‚ åä¾›ãŒè¦³ã¦ã„ãŸã‚¢ãƒ‹ãƒ¡ã§ã€èµ¤ã¡ã‚ƒã‚“ãŒç©ºã®â€¦
sirocco634 2008/05/28
MacPortsã‚’ä½¿ã£ã¦Macã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

Mac

mysql

sql
ãƒªãƒ³ã‚¯
Something PostgreSQL
since 1999/11/29 , 2002/11/29 Updated. Windowsãƒ¦ãƒ¼ã‚¶ã®ãŸã‚ã® PostgreSQL å°Žå…¥æ´»ç”¨ã‚¬ã‚¤ãƒ‰ å¥½è©•ç™ºå£²ä¸ã§ã™ã€‚ ã“ã“ã«ã¯ãªãœã‹PostgreSQLãªã‚‚ã®ã‚’ç½®ã„ã¦ã„ã¾ã™ã€‚PostgreSQLã˜ã‚ƒç„¡ã„ç‰©ãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ ãã‚Œã¯å¾¡æ„›æ•¬ã¨ã„ã†ã“ã¨ã§ã€‚ PostgreSQL for cygwin Cygwin(Windowsä¸Šã§å‹•ãUNIXã‚¨ãƒŸãƒ¥ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¬ã‚¤ãƒ¤)ç”¨ã®PostgreSQLã®ãƒã‚¤ãƒŠãƒªã§ã™ã€‚Win2000ã§ã®ã¿å‹•ä½œã‚’ç¢ºèªã—ã¦ã„ã¾ã™ã€‚9x/Meã§ã‚‚ç›¸å¿œã«å‹•ä½œã™ã‚‹ã‚ˆã†ã§ã™ã€‚ 7.2.1ä»¥ä¸‹ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã¯ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã«å•é¡ŒãŒã‚ã‚‹ã“ã¨ãŒå ±å‘Šã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚’ãŠã™ã™ã‚ã—ã¾ã™ã€‚ ä»¥ä¸‹ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯å®Ÿè¡Œã«ã¯cygipcãŒå¿…è¦ã§ã™ã€‚å¿…è¦ãªãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯7.3ã‹æœªæº€ã‹ã§æ±ºã¾ã‚‹ã®ã§æ°—ã‚’ä»˜ã‘ã¦ãã ã•ã„ã€‚Cygutilsã«ã¦ãƒ€ã‚¦ãƒ³ãƒãƒ¼
sirocco634 2008/05/27
Cygwinä¸Šã®postgreSQL

postgreSQL

sql
ãƒªãƒ³ã‚¯
Electronic Genome - [Ubuntu] PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ»åˆæœŸè¨å®šãƒ»ä½¿ã„æ–¹ãƒ¡ãƒ¢
PostgreSQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã¨åˆæœŸè¨å®šãƒ¡ãƒ¢ã€‚ â– PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Ubuntu7.10ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã€‚ ã ã‘ã§ä»¥ä¸‹ã®ã‚ˆã†ã«ä¾å˜ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’è‡ªå‹•ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãã‚Œã¾ã™ã€‚ postgresqlã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« $ sudo apt-get install postgresql ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒªã‚¹ãƒˆã‚’èªã¿è¾¼ã‚“ã§ã„ã¾ã™... å®Œäº† ä¾å˜é–¢ä¿‚ãƒ„ãƒªãƒ¼ã‚’ä½œæˆã—ã¦ã„ã¾ã™ Reading state information... å®Œäº† ä»¥ä¸‹ã®ç‰¹åˆ¥ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¾ã™: libpq5 postgresql-8.2 postgresql-client-8.2 postgresql-client-common postgresql-common â– PostgreSQLã®ãƒ¦ãƒ¼ã‚¶ç®¡ç† PostgreSQLã¯Linuxã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã¨ã¯åˆ¥ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ¦ãƒ¼ã‚¶ã‚’ç®¡ç†ã—ã¦ã„ã‚‹ã€‚ãƒ‡ãƒ•ã‚©ãƒ«
sirocco634 2008/05/27
PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ»åˆæœŸè¨å®šãƒ»ä½¿ã„æ–¹ãƒ¡ãƒ¢

postgreSQL

sql
ãƒªãƒ³ã‚¯
Macã§Webé–‹ç™º-(2) XAMPP for Macã«PostgreSQLã‚’è¿½åŠ | Tokyo O life
XAMPP for MacOS Xã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€MySQLã¨SQLiteãŒå…¥ã£ã¦ã„ã‚‹ãŒã€PostgreSQLãŒå…¥ã£ã¦ã„ãªã„ã€‚ ãã“ã§ã€PostgreSQLã‚’ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€XAMPP for MacOS Xã®PHPã‹ã‚‰åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã€‚ ï¼ˆâ€»PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã¯ã€ã€ŒXcode Toolsã€ãŒå¿…è¦ã§ã™ã€‚Mac OS Xã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«DVDã«å…¥ã£ã¦ã„ã¾ã™ï¼‰ ã€XAMPP for Macã®Developer Packageã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‘ XAMPP for Mac OS Xã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ http://www.apachefriends.org/en/xampp-macosx.htm ã€ŒDeveloper Packageã€ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãŒå§‹ã¾ã‚‹ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãŒå®Œäº†ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã«ç§»å‹•ã™ã‚‹ã€‚ ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã‚’èµ·å‹•ã—ã€ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰
sirocco634 2008/05/27
sql

postgreSQL
ãƒªãƒ³ã‚¯
ã€Proton.jpã€‘ PostgreSQLã‚’ä½¿ã£ã¦ã¿ã‚ˆã†
PostgreSQLã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®SQLè¨€èªžã«ã‚‚å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚å›½éš›åŒ–ã«ã‚‚å¯¾å¿œã—ã¦ãŠã‚Šã€æ—¥æœ¬èªžã‚‚ä½¿ãˆã¾ã™ã€‚Linuxç‰UNIXç³»ã®OSã ã‘ã§ãªãWindowsã‚„Mac OS Xã«ã‚‚å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ ã“ã“ã§ç´¹ä»‹ã™ã‚‹ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã‚„ä½¿ã„æ–¹ã¯Mac OS Xä¸Šã§ç¢ºèªã—ãŸã‚‚ã®ã§ã™ãŒã€ä»–ã®UNIXç³»OSï¼ˆLinux, FreeBSDç‰ï¼‰ã§ã‚‚å…±é€šã§ã™ã®ã§å‚è€ƒã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« PostgreSQLã‚’Mac OS Xã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å‰ã«ã€ã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒè¨å®šã‹ã‚‰ postgres ã¨ã„ã†åå‰ã§ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’ä½œæˆã—ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ‰€æœ‰è€…ã‚’postgresã¨ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œã‚‚postgresã§è¡Œã†ã“ã¨ã«ã™ã‚Œã°ã€ä¸‡ãŒä¸€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒä¹—ã£å–ã‚‰ã‚ŒãŸå ´åˆã«ã‚‚ä»–ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’ä¿è·å‡ºæ¥ã‚‹ã‹ã‚‰ã§ã™ã€‚ æ¬¡ã«ã€ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
sirocco634 2008/05/27
postgreSQLã®å°Žå…¥

SQL

postgreSQL
ãƒªãƒ³ã‚¯
ç‰¹é›†:åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ - ç‰¹é›†:åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼šITpro
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã€‚ã©ã‚“ãªSQLæ–‡ã‚’æŠ•ã’ãŸã‚‰ã©ã‚“ãªçµæžœãŒè¿”ã£ã¦ãã‚‹ã‹ã•ãˆçŸ¥ã£ã¦ã„ã‚Œã°ã‚ˆã„ã€---ãã†æ€ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã—ã‹ã—ï¼Œæœ¬ç‰©ã®ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ãƒ»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ç›®æŒ‡ã™ã®ã§ã‚ã‚Œã°ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå‹•ãä»•çµ„ã¿ã‚’å¦ã¶ã“ã¨ã¯é¿ã‘ã¦é€šã‚Œã¾ã›ã‚“ã€‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãªã©ã«å•é¡ŒãŒç”Ÿã˜ãŸã¨ãã©ã“ã‹ã‚‰æ‰‹ã‚’ä»˜ã‘ã¦ã„ã„ã®ã‹çš†ç›®è¦‹å½“ãŒã¤ã‹ãªã„ï¼Œã¨ã„ã£ãŸäº‹æ…‹ã«é™¥ã‚Šã‹ãã¾ã›ã‚“ã€‚ å¸‚è²©ã®RDBMSã®å†…éƒ¨ã¯ã‹ãªã‚Šè¤‡é›‘ã§ã™ãŒï¼ŒåŸºæœ¬çš„ãªéƒ¨åˆ†ã‚’ç†è§£ã™ã‚‹ã®ã¯ãã‚Œã»ã©é›£ã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã®ç‰¹é›†ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å‹•ãä»•çµ„ã¿ã‚’ç†è§£ã—ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒˆãƒ â—ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®ã¾ã¾ã§ã„ã„ã®ï¼Ÿ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ1ï¼‰ ï¼°ï½ï½’ï½”ï¼‘ â—SQLæ–‡ã¯ã©ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã®ã‹ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ2ï¼‰ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ3ï¼‰ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ4ï¼‰ åŸº
sirocco634 2007/11/24
åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿

Software

database

study

sql
ãƒªãƒ³ã‚¯
1