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

yocchan731 id:yocchan731

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

${{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 -ã‚¨ãƒã‚²ãƒ¼ãƒžãƒ¼ã®ãŸã‚ã®SQL-
SQLã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã—ãŸã‚Šã™ã‚‹ãŸã‚ã®è¨€èªžã§ã™ã€‚ ã“ã®æ–‡æ›¸ã¯ã€ErogameScapeã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰SELECTã‚’ä½¿ã£ã¦è‡ªç”±è‡ªåœ¨ã«ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã“ã¨ã‚’ç›®æ¨™ã«ã—ã¾ã™ã€‚ ã‚¨ãƒã‚²ãƒ¼ã‚’ã‚„ã‚Šã¯ã˜ã‚ã‚‹å¤§å¦ç”Ÿãã‚‰ã„ã®ã¨ãã«ã€å¤§å¦ã®è¬›ç¾©ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã‚“ã§ã€é€€å±ˆã ãªãƒ¼ã¨æ€ã£ãŸæ™‚ã«ã€ErogameScapeã§SQLã‚’å¦ã¶ã“ã¨ã§ã€å°‘ã—ã§ã‚‚SQLã«èˆˆå‘³ã‚’æŒã£ã¦ã€è‡ªèº«ã§ãƒ‡ãƒ¼ã‚¿ã‚’åŠ å·¥ã™ã‚‹ã“ã¨ã‚’å¦ç¿’ã—ã¦é ‚ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚ â€»ç§ã®å¤§å¦ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æŽˆæ¥ã§ã¯ã€è‡ªåˆ†ã®èº«ã®å›žã‚Šã®ä½•ã‹ã‚’ERå›³ã«è½ã¨ã—è¾¼ã‚“ã§ã€DBã‚’è¨è¨ˆã—ã€PostgreSQLã«å®Ÿè£…ã—ã€å®Ÿéš›ã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ›ã—ã¦SELECTã—ã¦ã¿ã‚‹ã¨ã“ã‚ã¾ã§ã‚’ã‚„ã‚Šã¾ã—ãŸã€‚ ERå›³ã¨ã„ã†æ¦‚å¿µã‚’å¦ã‚“ã ã¨ãã€Œã‚ã‚ã€ã“ã‚Œã¯é¢ç™½ã„ã€ã¨æ€ã„ã¾ã—ãŸã€‚ å…ˆç”Ÿã¯ã“ã†è¨€ã£ãŸã®ã§ã™ã€‚ ã€ŒERå›³ã«è½ã¨ã—è¾¼ã‚€ã¨ã€æ€ã„ã‚‚ã‚ˆã‚‰ãªã‹ã£ãŸã“ã¨ãŒåˆ†ã‹ã‚‹ã€‚ã€ã¨ã€‚ å½“æ™‚ã€
yocchan731 2014/01/04
*ã¾ã¨ã‚

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

sql

ã‚²ãƒ¼ãƒ

db

*ãƒã‚¿
ãƒªãƒ³ã‚¯
Ring
Ringã¨ã¯ã€ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ä¼šç¤¾å¾“æ¥å“¡ã‚’å¯¾è±¡ã«ã—ãŸæ–°è¦äº‹æ¥ææ¡ˆåˆ¶åº¦ã§ã™ã€‚ ã€Žã‚¼ã‚¯ã‚·ã‚£ã€ã€ŽR25ã€ã€Žã‚¹ã‚¿ãƒ‡ã‚£ã‚µãƒ—ãƒªã€ãªã©æ•°å¤šãã®äº‹æ¥ã‚’ç”Ÿã¿å‡ºã—ã¦ããŸæ–°è¦äº‹æ¥åˆ¶åº¦ã¯ã€ 1982å¹´ã«ã€ŒRINGã€ã¨ã—ã¦ã‚¹ã‚¿ãƒ¼ãƒˆã—ã€1990å¹´ã€ŒNew RINGã€ã¨æ”¹å®šã€ãã—ã¦2018å¹´ã€ŒRingã€ã«ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã—ã¾ã—ãŸã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ã®å¾“æ¥å“¡ã¯èª°ã§ã‚‚è‡ªç”±ã«å‚åŠ ã™ã‚‹ã“ã¨ãŒã§ãã€ ãƒ†ãƒ¼ãƒžã¯ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã®æ—¢å˜é ˜åŸŸã«é™ã‚‰ãšã€ã‚ã‚Šã¨ã‚ã‚‰ã‚†ã‚‹é ˜åŸŸãŒå¯¾è±¡ã§ã™ã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã«ã¨ã£ã¦ã€Ringã¨ã¯ã€Œæ–°ã—ã„ä¾¡å€¤ã®å‰µé€ ã€ã¨ã„ã†ã‚°ãƒ«ãƒ¼ãƒ—çµŒå–¶ç†å¿µã‚’ä½“ç¾ã™ã‚‹å ´ã§ã‚ã‚Šã€ å¾“æ¥å“¡ãŒè‡ªåˆ†ã®æ„æ€ã§æ–°è¦äº‹æ¥ã‚’ææ¡ˆãƒ»å®Ÿç¾ã§ãã‚‹æ©Ÿä¼šã§ã™ã€‚ Ringãƒ•ãƒãƒ¼ ãã®å¾Œã®äº‹æ¥é–‹ç™ºæ‰‹æ³• Ringã‚’é€šéŽã—ãŸæ¡ˆä»¶ã¯ã€äº‹æ¥åŒ–ã‚’æ¤œè¨Žã™ã‚‹æ¨©åˆ©ã‚’å¾—ã¦ã€äº‹æ¥é–‹ç™ºã‚’è¡Œã„ã¾ã™ã€‚ ã•ã¾ã–ã¾ãªäº‹æ¥é–‹ç™ºã®æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ãŒã€ä¾‹ãˆã°æ—¢å˜é ˜åŸŸã§ã®äº‹æ¥é–‹ç™ºã®å ´åˆã¯ã€ æ‹…å½“äº‹æ¥ä¼šç¤¾å†…ã§äºˆç®—ã‚„
yocchan731 2011/02/21
*ã‚µãƒ¼ãƒ

mysql

æ¤œç´¢

æœ€é©åŒ–

sql

db
ãƒªãƒ³ã‚¯
Mysql+PHPã§ä»¶æ•°å–å¾—ï¼šCOUNT mysql_num_rows FOUND_ROWS æ¯”è¼ƒ | æ ªå¼ä¼šç¤¾ãƒ•ã‚©ãƒ¬ã‚¹ãƒˆãƒ»ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒ„
ã®ã‚ˆã†ã«ã€å…¨ä½“ä»¶æ•°ã¨è¡¨ç¤ºä¸ã®ãƒ‡ãƒ¼ã‚¿ä»¶æ•°ãŒä½µè¨˜ã•ã‚Œã‚‹å ´åˆãŒå¤šã„ã€‚ã¨ã“ã‚ãŒã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒå¤šããªã£ãŸã‚Šã€SQLæ–‡ãŒè¤‡é›‘ã«ãªã‚‹ã¨ã€å…¨ä½“ä»¶æ•°ã®å–å¾—ã«ã‹ã‹ã‚‹ã‚¹ãƒ”ãƒ¼ãƒ‰ãŒç‰©å‡„ãé…ããªã‚‹å ´åˆãŒã‚ã‚‹ã€‚ ã¨è¨€ã†è¨³ã§ã€ã©ã®ã‚ˆã†ãªæ–¹æ³•ã§å…¨ä½“ä»¶æ•°ã‚’å–å¾—ã™ã‚‹ã®ãŒé«˜é€Ÿãªã®ã‹ã‚’èª¿ã¹ã¦ã¿ãŸã€‚ ç’°å¢ƒã¯Mysql+PHPã€‚å€™è£œã¯æ¬¡ã®ï¼“ã¤ã€‚ COUNTã‚’ä½¿ã†ã€‚ mysql_num_rowsã‚’ä½¿ã†ã€‚ï¼ˆ*ï¼°ï¼¨ï¼°é–¢æ•°ï¼‰ FOUND_ROWSã¨SQL_CALC_FOUND_ROWSã‚’ä½¿ã†ã€‚ ã‚µãƒ³ãƒ—ãƒ« â€»ä»¥ä¸‹ã®SQLã®çµæžœã€åŠã³ã€LIMITã®åˆ¶ç´„ã‚’å¤–ã—ãŸå ´åˆã®çµæžœï¼ˆï¼å…¨ä½“ä»¶æ•°ï¼‰ã‚’å–å¾—ã™ã‚‹ã€‚ $query = 'SELECT id, name, area FROM company ORDER BY id LIMIT 20'; $q1 = 'SELECT COUNT(*) FROM company'; //å…¨ä½“ä»¶æ•°ã‚’å–å¾—ã™ã‚‹ã‚·ãƒ³ãƒ—ãƒ«ãªSQLã‚¯ã‚¨
yocchan731 2011/01/16
*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

mysql

sql

php

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘PHPãƒ‡ãƒ™ãƒãƒƒãƒ‘ãŒãŠã‹ã—ãŒã¡ãª10ã®MySQLé–“é•ã„ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
SitePoint: New Articles, Fresh Thinking for Web Developers and Designers PHPã‚’ä½¿ã£ã¦Webã‚µã‚¤ãƒˆã‚„Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ§‹ç¯‰ã™ã‚‹å ´åˆã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚ä½µç”¨ã™ã‚‹ã“ã¨ãŒå¤šã„ã€‚ãã—ã¦ãã®å ´åˆã«æŽ¡ç”¨ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã²ã¨ã¤ã«MySQLãŒã‚ã‚‹ã€‚PHPã¯ã™ãã«åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã¨ã„ã‚ã‚Œã¦ã„ã‚‹ãŒã€MySQLã‚„SQLã¯ãã†ã§ã¯ãªã„ã€‚å …ç‰¢ã§ä¿¡é ¼ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¨è¨ˆã—ã€ãã‚Œã‚’æ‰±ã†SQLã‚¯ã‚¨ãƒªã‚’ä½œæˆã™ã‚‹ã«ã¯ãã‚Œãªã‚Šã®å¦ç¿’æ™‚é–“ã¨çµŒé¨“ãŒå¿…è¦ã ã€‚ ã“ã†ã—ãŸè©±é¡ŒãŒSitePointã«ãŠã„ã¦Top 10 MySQL Mistakes Made By PHP Developersã¨ã—ã¦æŽ²è¼‰ã•ã‚Œã¦ã„ã‚‹ã€‚PHPãƒ‡ãƒ™ãƒãƒƒãƒ‘ãŒçŠ¯ã—ãŒã¡ãª10ã®MySQLãƒŸã‚¹ãƒ†ã‚¤ã‚¯ã¨ã„ã†å†…å®¹ã«ãªã£ã¦ã„ã‚‹ã€‚ã©ã†ã„ã£ãŸé–“é•ã„ã‚’ã—ã¦ã—ã¾ã†ã‹ç°¡å˜ã«
yocchan731 2010/11/25
*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

mysql

sql

php

tips
ãƒªãƒ³ã‚¯
PHPã®SQLite3ã‚¯ãƒ©ã‚¹ã‚’ä½¿ã£ã¦SQLite3ã‚’æ“ä½œã™ã‚‹ - å°ã•ã„é ƒã¯ã‚¨ãƒ©å‘¼å¸
å‰å›žã¾ã§ã®ã‚¨ãƒ³ãƒˆãƒªã§ã€Mac OS X 10.6 Snow Leopardä¸Šã§PHP5ã¨SQLite3ã‚’å‹•ã‹ã™ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã§ã€ä»Šå›žã¯PHPã‹ã‚‰SQLite3ã‚’æ“ä½œã—ã¦ã¿ã¾ã—ãŸã€‚ å‰å›žã®ã‚¨ãƒ³ãƒˆãƒªã¯ã€ã“ã¡ã‚‰ã€‚ Mac OS X. 10.6 Snow Leopardã§SQLite3ã‚’å‹•ã‹ã—ã¦ã¿ãŸã‚ˆã€‚ - å¤§äººã«ãªã£ãŸã‚‰è‚ºå‘¼å¸ Mac OS X. 10.6 Snow Leopardã§PHP5.3ã‚’å‹•ã‹ã—ã¦ã¿ãŸã‚ˆã€‚ - å¤§äººã«ãªã£ãŸã‚‰è‚ºå‘¼å¸ åƒ•ã¯PHPã®ã‚³ãƒ¼ãƒ‰ã‚’ã»ã¨ã‚“ã©æ›¸ã„ãŸã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ãªã®ã§ã€ä»¥ä¸‹ã«è¨˜è¼‰ã™ã‚‹ã‚³ãƒ¼ãƒ‰ã¯è‡ªä¿¡ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ã¨ã‚Šã‚ãˆãšå‹•ããƒ¬ãƒ™ãƒ«ã¨ã„ã†ã“ã¨ã§è¦‹ã¦ãã ã•ã„ã€‚ ä»¥ä¸‹ã®ã‚µã‚¤ãƒˆã‚’å‚è€ƒã«ã€è©¦è¡ŒéŒ¯èª¤ã—ãªãŒã‚‰å‹•ã‹ã—ã¦ã¿ã¾ã—ãŸã€‚ PHPåŸºç¤Žæ–‡æ³•æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼ | Shin x blog PHP: SQLite3 - Manual SQLite3ã«æŽ¥ç¶šã™ã‚‹ SQLite3ã«æŽ¥
yocchan731 2010/10/13
*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

php

db

sql
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
yocchan731 2010/10/13
*ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

db

å¤‰æ›

sql

tips
ãƒªãƒ³ã‚¯
ä»Šå¤œã“ãã‚ã‹ã‚‹å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€€ï½ž é«˜æœ¨æµ©å…‰æ°ã«èžã„ã¦ã¿ãŸ
ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã¨ã„ã†SQLã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã«ç„¦ç‚¹ã‚’å½“ã¦ãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒã€2010å¹´3æœˆã«IPAï¼ˆç‹¬ç«‹è¡Œæ”¿æ³•äººæƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼‰ã‹ã‚‰å…¬é–‹ã•ã‚ŒãŸã€‚ ã“ã‚Œã¯2006å¹´1æœˆã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã‚‹ã€Webã‚µã‚¤ãƒˆé–‹ç™ºè€…ã‚„é‹å–¶è€…å‘ã‘ã®ã‚»ã‚ãƒ¥ã‚¢Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã®ãŸã‚ã®è³‡æ–™ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ã®åˆ¥å†Šã¨ã—ã¦æ›¸ã‹ã‚ŒãŸã‚‚ã®ã§ã‚ã‚‹ã€‚ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ãŒ92ãƒšãƒ¼ã‚¸ãªã®ã«å¯¾ã—ã¦ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã ã‘ã§40ãƒšãƒ¼ã‚¸ã‚‚ã®åˆ†é‡ãŒã‚ã‚‹ã€‚ãªãœã“ã‚“ãªã«åˆ†åŽšã„ã®ã ã‚ã†ã‹ã€‚ ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä½œæˆã«å”åŠ›ã—ãŸã¨ã„ã†ã€ç‹¬ç«‹è¡Œæ”¿æ³•äººç”£æ¥æŠ€è¡“ç·åˆç ”ç©¶æ‰€ æƒ…å ±ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç ”ç©¶ã‚»ãƒ³ã‚¿ãƒ¼ã®é«˜æœ¨æµ©å…‰æ°ã«ãŠè©±ã‚’ä¼ºã†ã“ã¨ãŒã§ããŸã€‚é«˜æœ¨æ°ã¯å€‹äººãƒ–ãƒã‚°ã€Œé«˜æœ¨æµ©å…‰ï¼ è‡ªå®…ã®æ—¥è¨˜ã€ã§ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£é–¢é€£ã®å•é¡Œã‚’è¿½æ±‚ã™ã‚‹è«–å®¢ã¨ã—ã¦ã‚‚çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ç†è€…ã‚‚ä»¥å‰ã€ã“ã®é€£è¼‰ã®ã€Œä»Šå¤œã‚ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã®å›žï¼ˆ2006å¹´11æœˆ
yocchan731 2010/06/26
*èªã¿ç‰©

*è³‡æ–™

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

sql

db

ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ™ãƒ¼ã‚¹ã®HAãªæ§‹æˆã«ã¤ã„ã¦è€ƒãˆãŸãƒ¡ãƒ¢ã§ã™ã€‚ 3å°(ã¨ã„ã†ã‹2å°ï¼‹1å°)ãŒã„ã„ã‹ãªãã¨æ€ã£ã¦ã„ã¦ã€å‰åŠã¯ãã®ç†ç”±ã‚’ã€å¾ŒåŠã§ã¯{ãƒžã‚¹ã‚¿,ã‚¹ãƒ¬ãƒ¼ãƒ–}ãŒ{å†èµ·ä¸èƒ½ã«ãªã£ãŸ,ã¡ã‚‡ã£ã¨ãƒ€ã‚¦ãƒ³ã—ã¦ã™ãå¾©å¸°ã—ãŸ}å ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ ä»Šã®ã¨ã“ã‚ã¯ã“ã‚ŒãŒãƒ™ã‚¹ãƒˆã‹ãªã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã€Œã“ã†ã—ãŸã»ã†ãŒã„ã„ã¨æ€ã†ï¼ã€ã€Œã“ã“ãŒãŠã‹ã—ã„ï¼ã€ãªã©ãªã©ã®ã”æ„è¦‹ã¯ã‚³ãƒ¡ãƒ³ãƒˆã€TBãªã©ã§ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ã‚´ãƒ¼ãƒ« ãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ ãƒªã‚«ãƒãƒªã®ä½œæ¥ã¯ã§ãã‚‹ã ã‘å˜ç´”ã«ã€ã‹ã¤ã€çŸæ™‚é–“ã§å®Œäº†ã™ã‚‹ã‚ˆã†ã«ã—ãŸã„ ã‚ã‚“ã©ãã•ã„ã®ã¯ã„ã‚„ åŸºæœ¬æ§‹æˆã€æ–¹é‡ 2å°ï¼‹1å° ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã†ã®ã¯2å° (db1, db2) ã‚‚ã†1å°ã¯ç®¡ç†ç”¨ (db3) ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å¤šæ•°ä¸¦ã¹ã‚‹æ§‹æˆã«ã¯ã—ãªã„ å°æ•°å¢—ãˆã‚‹ã¨ç®¡ç†ã‚³ã‚¹ãƒˆãŒä¸ŠãŒã‚‹ ãƒžã‚¹ã‚¿ãƒ€ã‚¦ãƒ³æ™‚ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã¨ãã®ãƒ•ã‚§ã‚¤ãƒ«ãƒ
yocchan731 2009/10/23
*ã‚µãƒ¼ãƒ

sql

db

mysql

tips
ãƒªãƒ³ã‚¯
MySQLã®rootã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¿˜ã‚ŒãŸå ´åˆã«å¤‰æ›´ã™ã‚‹æ–¹æ³•ãƒ¡ãƒ¢ - uncertain world
å‰ä»»ã®äººãŒrootã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰æ®‹ã•ãªã„ã¾ã¾å±…ãªããªã£ã¦ã€ ã¨ã£ã¦ã‚‚å›°ã£ãŸã®ã§(grantã§ããªã„)ã€ åˆæœŸåŒ–ã™ã‚‹æ–¹æ³•è¦‹ã¦ãŸã‚“ã ã‘ã©ã€æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã®ã˜ã‚ƒæ²»ã‚‰ãªãã¦ã€ æœ¬å®¶ã®æ–¹ã¿ãŸã‚‰æ²»ã£ãŸ > UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; > FLUSH PRIVILEGES; ã“ã‚Œã§MyNewPassã«æ–°ã—ã„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰å…¥ã‚Œã‚Œã°okã¿ãŸã„ã€‚ ãƒ»MySQL :: MySQL 5.1 Reference Manual :: B.1.4.1 How to Reset the Root Password http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html ãƒ»5/31è¿½è¨˜ ãªãœã‹ãƒ›ãƒƒãƒ†ãƒ³ãƒˆãƒªã«ä¸ŠãŒã£ã¦ã—ã¾ã£ã¦ã„ãŸã®ã§ã€ã¡ã‚‡ã£
yocchan731 2009/05/30
*ã‚µãƒ¼ãƒ

tips

sql

ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰

ãƒˆãƒ©ãƒ–ãƒ«
ãƒªãƒ³ã‚¯
ã‚°ãƒ©ãƒ•ã‚£ã‚«ãƒ«ã«ã‚¯ã‚¨ãƒªãƒ¼ã‚’æ§‹ç¯‰ï¼†ãƒ¬ãƒãƒ¼ãƒˆå‡ºåŠ›Â·Wabit MOONGIFT
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’è¤‡é›‘ãªæ¡ä»¶ã‚’ä»˜ã‘ã¤ã¤å–ã‚Šå‡ºã—ã¦ãƒ¬ãƒãƒ¼ãƒˆã«ã—ã¦ã»ã—ã„ï¼Œã¨ã„ã†ã®ã¯ã‚ˆãã‚ã‚‹ãƒ‹ãƒ¼ã‚ºã ã‚ã†ã€‚ç¹°ã‚Šè¿”ã—ä½¿ã†ã‚‚ã®ã§ã‚ã‚Œã°ã‚ã‚‰ã‹ã˜ã‚çµ„ã‚“ã§ã—ã¾ã†ã®ã ãŒã€ã ã„ãŸã„ã¯ãã†ã§ã¯ãªã„ã€‚ä»Šå›žã ã‘æ¬²ã—ã„ã¨ã„ã†å ´åˆã°ã‹ã‚Šã ã€‚ ã‚¯ã‚¨ãƒªãƒ¼è¨å®š å®Ÿè¡Œçµæžœã‚’è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«è²¼ä»˜ã‘ã¦ç”»åƒã‚„ãƒ†ã‚ã‚¹ãƒˆã‚’è¿½åŠ ã—ã¦å½¢å¼ã‚’æ•´ãˆã¦â€¦ãªã‚“ã¦æ¯Žåº¦ã‚„ã£ã¦ã„ã‚‰ã‚Œãªã„ã€‚ãã“ã§Wabitã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Wabitã€ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«ã‚¯ã‚¨ãƒªãƒ¼æ§‹ç¯‰ï¼†ãƒ¬ãƒãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ Wabitã¯Javaã§ä½œã‚‰ã‚ŒãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€MySQLã‚„PostgreSQLã€Oracle8iã€œ10gã€SQL Serverã€DB2ãªã©å¤šæ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚Windows/Mac OSX/Linuxã®ãã‚Œãžã‚Œã®ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§å‹•ä½œã™ã‚‹ã€‚æŽ¥ç¶šã—ãŸå…ˆã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ‰ãƒ©ãƒƒã‚°ã‚¢ãƒ³ãƒ‰ãƒ‰ãƒãƒƒãƒ—ã§è¿½åŠ ã—
yocchan731 2009/02/04
ãŠã‚‚ã—ã‚ã„ï¼

*ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

java

sql
ãƒªãƒ³ã‚¯
GitHub - livedoor/cicindela2: a highly customizable recommendation engine written in perl + MySQL
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
yocchan731 2008/12/24
*ç ”ç©¶

api

é–‹ç™º

perl

livedoor

sql

ãƒ¬ã‚³ãƒ¡ãƒ³ãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
Apache/PHP/MySQLãªã©ã‚’Windowsã«ä¸€ç™ºã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ã€ŒVertrigoServã€ - GIGAZINE
Apache/PHP/MySQL/SQLite/SQLiteManage/PhpMyAdmin/Zend Optimizerã‚’Windowsã«ã¾ã¨ã‚ã¦ã‚ªãƒ¼ãƒ«ã‚¤ãƒ³ãƒ¯ãƒ³ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã®ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚Œã¦ã„ã‚‹ã“ã®ã€ŒVertrigoServã€ã€‚ ã“ã‚Œã‚‰ã®å„ã‚½ãƒ•ãƒˆã«ã¤ã„ã¦ç°¡å˜ã«è¨å®šã‚’å¤‰æ›´ã§ãã‚‹ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ‘ãƒãƒ«ã£ã½ã„ã‚‚ã®ãŒã‚¿ã‚¹ã‚¯ãƒˆãƒ¬ã‚¤ã‹ã‚‰ä¸€ç™ºã§å‘¼ã³å‡ºã›ã‚‹ã‚ˆã†ã«ãªã£ã¦ãŠã‚Šã€éžå¸¸ã«è¨å®šãŒç°¡å˜ã§ã™ã€‚ã¾ãŸã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã¯æ—¥æœ¬èªžåŒ–ã•ã‚Œã¦ã„ã‚‹ã®ã§å®‰å¿ƒã§ã™ã€‚ å®Ÿéš›ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ãªã©ã¯ä»¥ä¸‹ã‹ã‚‰ã€‚ VertrigoServ http://vertrigo.sourceforge.net/ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã‚‰å®Ÿè¡Œã—ã¾ã™ ã€ŒOKã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œæ¬¡ã¸ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€ŒåŒæ„ã™ã‚‹ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œæ¬¡ã¸ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã•ã‚‰ã«ã€Œæ¬¡ã¸ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä¸â€¦â€¦
yocchan731 2008/03/25
*ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

apache

*webåˆ¶ä½œ

gigazine

php

sql

windows

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©

ãƒ„ãƒ¼ãƒ«

ä¾¿åˆ©
ãƒªãƒ³ã‚¯
Google Visualization APIã‚’æ—©é€Ÿä½¿ã£ã¦ã¿ãŸ - builder by ZDNet Japan
RPAè¦‹ç›´ã•ã‚Œã‚‹â€æ¥å‹™â€ã¨â€äººâ€ã®é–¢ä¿‚ äººçš„ãƒªã‚½ãƒ¼ã‚¹ã‚’å˜ç´”ä½œæ¥ã‹ã‚‰è§£æ”¾ï¼ é«˜ä»˜åŠ ä¾¡å€¤æ¥å‹™ã¸ã®è»¢æ›ã®ãŸã‚ã« è†¨å¤§ãªã‚¢ã‚¯ã‚»ã‚¹ã‚’æ”¯ãˆã‚‹å±‹å°éª¨ é«˜ã„å®‰å®šæ€§ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ä¸¡ç«‹ ZOZOTOWNãŒé¸ã‚“ã ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸åŸºç›¤ã‚’è§£èª¬ ãƒ“ã‚¸ãƒã‚¹ã®æŽ¨é€²ã«ã¯å¿…é ˆï¼ ZDNetÃ—ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒè´ˆã‚‹ç‰¹åˆ¥ä¼ç”» ä»Šã€å¿…è¦ãªæˆ¦ç•¥çš„ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ã‚¬ãƒãƒŠãƒ³ã‚¹ ãƒªãƒ¢ãƒ¼ãƒˆãƒ¯ãƒ¼ã‚¯ã‚’æˆåŠŸã•ã›ã‚‹æ–¹æ³• å¿…é ˆã¨ãªã‚‹ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’ã©ã†å¼·åŒ–ã™ã‚‹ã‹ å¿…è¦ãªå¯¾ç–5ã¤ã‚’ç´¹ä»‹ å¹´é–“5,000ä»¶ã®å•ã„åˆã‚ã›ã«å¯¾å¿œ ç–‘å•ã‚’è§£æ¶ˆã—ãŸã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚‚ç”ãˆã‚‹æƒ…ã‚·ã‚¹ã‚‚ ã¿ã‚“ãªå¹¸ã›ã«ãªã‚‹ãƒ˜ãƒ«ãƒ—ãƒ‡ã‚¹ã‚¯ã®æœ€é©è§£ é«˜ã„å¾“æ¥å“¡æº€è¶³åº¦ã¨å®‰å¿ƒãƒ»å®‰å…¨ æ–°æ™‚ä»£ã«ã‚€ã‘ãŸç†æƒ³ã®æ¥å‹™ç’°å¢ƒã“ã Anywhere WorkspaceãŒç›®æŒ‡ã™æœªæ¥ ã‚¨ãƒƒã‚¸å¸‚å ´ã®æ´»æ€§åŒ–ã¸ é«˜ã¾ã‚‹IoTã‚’ä¸å¿ƒã¨ã—ãŸã‚¨ãƒƒã‚¸åˆ†é‡Žã¸ã®æœŸå¾… OSSæ´»ç”¨ãŒæ–°ã—ã„æ™‚ä»£ã®ãƒ“ã‚¸ãƒã‚¹ã‚’æ‹“ã ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ã¯æ¬¡ã®ã‚¹ãƒ†ãƒ¼ã‚¸ã¸ ãƒˆãƒ©ãƒ‡ã‚£ã‚·ãƒ§ãƒŠãƒ«
yocchan731 2008/03/22
*webã‚µãƒ¼ãƒ“ã‚¹

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

javascript

google

api

sql
ãƒªãƒ³ã‚¯
SQLã«ã‚ˆã‚‹æ•°ç‹¬ã®é«˜é€Ÿè§£æ³•ï¼šCodeZine
CALCULATE_GS_V3ã¯æŽ§ãˆã‚ã«è¨€ã£ã¦ã‚‚ã€Œé…ã™ãŽã‚‹ã€ã®ã§ã€ã“ã‚Œã«æ¯”ã¹ã¦ã€Œé«˜é€Ÿã€ã§ã‚ã£ã¦ã‚‚ã€ã€Œæ•°ç‹¬ã€ã®è§£æ³•ã¨ã—ã¦ç‰¹åˆ¥é«˜é€Ÿãªã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ï¼ˆæ•°ç‹¬ã‚’ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã§è§£ã„ãŸçµŒé¨“ã®ã‚ã‚‹äººãªã‚‰ã€æ¨™æº–çš„ãªã‚µã‚¤ã‚º9Ã—9ã®æ•°ç‹¬ã‚’ã€ä»Šæ—¥ã®è¨ˆç®—æ©Ÿã¯æ•°ç§’ã§è§£ãã“ã¨ã¯ã”å˜ã˜ã§ã—ã‚‡ã†ï¼‰ã€‚ã—ã‹ã—ãªãŒã‚‰ã€æœ¬ç¨¿ã§ç´¹ä»‹ã™ã‚‹SQLã®æ›¸ãæ–¹ã¯ã€ã•ã¾ã–ã¾ãªå ´é¢ã§å¿œç”¨ã§ãã‚‹ã¯ãšã§ã™ã€‚ã“ã“ã§ç´¹ä»‹ã™ã‚‹æ–¹æ³•ã‚ˆã‚Šã‚‚åŠ‡çš„ã«é€Ÿã„æ–¹æ³•ã‚’ç¬¬3éƒ¨ã§ç´¹ä»‹ã—ã¦ã„ã‚‹ã®ã§ä½µã›ã¦ãŠèªã¿ãã ã•ã„ï¼ˆ1ç§’ç¨‹åº¦ã§è§£ã‘ã¾ã™ï¼‰ã€‚å¯¾è±¡èªè€…è¨ˆç®—æ©Ÿã§ãƒ‘ã‚ºãƒ«ã‚’è§£ãã“ã¨ã«èˆˆå‘³ã®ã‚ã‚‹æ–¹æ•°ç‹¬ã‚’çŸ¥ã£ã¦ã„ã‚‹æ–¹ï¼ˆæ•°ç‹¬è‡ªä½“ã«ã¤ã„ã¦ã®èª¬æ˜Žã¯ã—ã¾ã›ã‚“ï¼‰ã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã«ã¤ã„ã¦å¦ã³ãŸã„ï¼ˆã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£è‡ªä½“ã«ã¤ã„ã¦ã¯èª¬æ˜Žã—ã¾ã›ã‚“ãŒã€é›°å›²æ°—ã¯åˆ†ã‹ã‚‹ã¨æ€ã„ã¾ã™ï¼‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã§ã€Œãƒ‡ãƒ¼ã‚¿ã®ç®¡ç†ã€ã‚’è¶…ãˆãŸã“ã¨ã‚’ã—ã¦ã¿ãŸã„æ–¹ å¿…è¦ãªç’°å¢ƒã€€æœ¬æ–‡ã®ã‚³ãƒ¼ãƒ‰ã‚’ãã®ã¾ã¾å®Ÿè¡Œã™ã‚‹ã«ã¯MyS
yocchan731 2007/09/11
*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

sql

ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ

é«˜é€ŸåŒ–

ã‚²ãƒ¼ãƒ
ãƒªãƒ³ã‚¯
PostgreSQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚ - å¾’ç„¶ãªã‚‹ã¾ã¾ã«Blog
PostgreSQLã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ ãã®æ™‚ã«èª¿ã¹ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã‚’å‚™å¿˜éŒ²ã¨ã—ã¦æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®é•ã„ã‚„ã‚µãƒ¼ãƒã®è¦æ¨¡ãªã©ã«ã‚ˆã£ã¦ã‚‚ åŠ¹æžœã¯å¤‰ã‚ã£ã¦ãã‚‹ã¨æ€ã†ã®ã§ã‚ãã¾ã§å‚è€ƒç¨‹åº¦ã®ã‚‚ã®ã§ã™ãŒã€‚ ãƒ»shared_buffers 7ç³»ã§ã¯8000ã€œ10000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ 8ç³»ã§ã¯150000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ã“ã¨ãŒå¯èƒ½ã€100000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ã“ã‚Œã«å¤šãå‰²ã‚Šå½“ã¦ã‚‹ã‚ˆã‚ŠOSã®ãƒãƒƒãƒ•ã‚¡é ˜åŸŸã¨ã—ã¦ä½¿ã†æ–¹ãŒæ€§èƒ½ãŒå‘ä¸Šã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã‚’å‰²ã‚Šå‡ºã—ã¦è¨å®šã™ã‚‹ã®ãŒãƒ™ã‚¹ãƒˆ ç°¡å˜ã«è¨å®šã™ã‚‹ãªã‚‰æè¼‰ãƒ¡ãƒ¢ãƒªé‡ã®1/4ã€æè¼‰ãƒ¡ãƒ¢ãƒªãŒå¤šã‘ã‚Œã°1/2ãã‚‰ã„ã§ã‚‚å¯ ãƒ»max_connections 7ç³»ã§ã¯256ç¨‹åº¦ã€8ç³»ã§ã¯1000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ãƒ»work_mem(sort_mem) é©åˆ‡ãªã‚µã‚¤ã‚ºã«èª¿æ•´ã™ã‚‹ã€2048ã€œ4096ç¨‹åº¦ ãƒ—ãƒã‚»ã‚¹æ¯Ž
yocchan731 2007/07/23
*ã‚µãƒ¼ãƒ

*ã¾ã¨ã‚

é«˜é€ŸåŒ–

sql

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
Webã‚µãƒ¼ãƒã¸ã®æ”»æ’ƒã‚’è¦‹æŠœã â€• ï¼ IT
ã‚¦ã‚¤ãƒ«ã‚¹ã€ãƒ¯ãƒ¼ãƒ ã€ãƒœãƒƒãƒˆã«ã‚ˆã‚‹æ”»æ’ƒâ€¦â€¦ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ä¸Šã«å˜åœ¨ã™ã‚‹è„…å¨ã¯å¤šç¨®å¤šæ§˜ã§ã‚ã‚‹ã€‚ã‚µãƒ¼ãƒã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸå½¢è·¡ã‚’è¦‹ã¦ã€ãã‚ŒãŒé€šå¸¸ã®ã‚‚ã®ãªã®ã‹ã€ãã‚Œã¨ã‚‚è„…å¨ãªã®ã‹ã‚’åˆ¤æ–ã™ã‚‹ã«ã¯çŸ¥è˜ã¨çµŒé¨“ãŒå¿…è¦ã¨ãªã‚‹ã€‚ãã“ã§æœ¬é€£è¼‰ã§ã¯ã€ã‚¤ãƒ³ã‚·ãƒ‡ãƒ³ãƒˆãƒ»ãƒãƒ³ãƒ‰ãƒªãƒ³ã‚°ã®ãŸã‚ã«å¿…è¦ãªã€Œå•é¡Œã‚’è¦‹æŠœãã€ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’åˆ†é‡Žã”ã¨ã«è§£èª¬ã—ã¦ã„ãï¼ˆç·¨é›†éƒ¨ï¼‰ â€»ã”æ³¨æ„ ä»–ç¤¾ãŠã‚ˆã³ä»–çµ„ç¹”ã®Webã‚µã‚¤ãƒˆãªã©ã¸ã®ãƒãƒ¼ãƒˆã‚¹ã‚ãƒ£ãƒ³ãŠã‚ˆã³ãƒ‡ãƒ¼ã‚¿ã®å–å¾—ãªã©ã®è¡Œç‚ºã§å¾—ãŸæƒ…å ±ã‚’ä¾µå…¥ãªã©ã«æ‚ªç”¨ã™ã‚‹ã‹ã€ã¾ãŸã¯åŒã˜ç›®çš„ã‚’æŒã¤ç¬¬ä¸‰è€…ã«æä¾›ã—ãŸæ™‚ç‚¹ã§é•æ³•ã¨ãªã‚Šã¾ã™ã€‚ã”æ³¨æ„ãã ã•ã„ã€‚ æœ¬ç¨¿ã®å†…å®¹ã‚’æ¤œè¨¼ã™ã‚‹å ´åˆã¯ã€å¿…ãšå½±éŸ¿ã‚’åŠã¼ã•ãªã„é™ã‚‰ã‚ŒãŸç’°å¢ƒä¸‹ã§è¡Œã£ã¦ä¸‹ã•ã„ã€‚ ã¾ãŸã€æœ¬ç¨¿ã‚’åˆ©ç”¨ã—ãŸè¡Œç‚ºã«ã‚ˆã‚‹å•é¡Œã«é–¢ã—ã¾ã—ã¦ã¯ã€ç†è€…ãŠã‚ˆã³ã‚¢ã‚¤ãƒ†ã‚£ãƒ¡ãƒ‡ã‚£ã‚¢æ ªå¼ä¼šç¤¾ã¯ä¸€åˆ‡è²¬ä»»ã‚’è² ã„ã‹ãã¾ã™ã€‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ã‚¤ãƒ³ã‚·ãƒ‡ãƒ³ãƒˆã‚’æœ€çµ‚åˆ¤æ–ã™ã‚‹ã®ã¯ã€Œäººé–“ã€ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã¯ã€ã„ã‚ãšã¨çŸ¥ã‚ŒãŸä¸–
yocchan731 2007/07/14
*ã‚µãƒ¼ãƒ

ã‚·ã‚¹ãƒ†ãƒ ç›£è¦–

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

apache

sql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
å¹³ç´ ã‚ˆã‚Šã€ŒPHPãƒ—ãƒï¼ã€ã‚’ã”æ„›é¡§ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ 2006å¹´ã‚ˆã‚Šé‹å–¶ã—ã¦ã¾ã„ã‚Šã¾ã—ãŸã€ŒPHPãƒ—ãƒï¼ã€ã§ã™ãŒã€ã‚µãƒ¼ãƒ“ã‚¹ã®åˆ©ç”¨çŠ¶æ³ã‚’é‘‘ã¿ã¾ã—ã¦ã€2018å¹´9æœˆ25æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã•ã›ã¦ã„ãŸã ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã¾ã—ã¦ã€2018å¹´8æœˆ28æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’æŒã¡ã¾ã—ã¦ã€æ–°è¦ä¼šå“¡ç™»éŒ²ãªã‚‰ã³ã«Q&AæŽ²ç¤ºæ¿ã¸ã®æ–°ãŸãªè³ªå•ã€å›žç”ã®æŠ•ç¨¿ã‚’åœæ¢ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ãªãŠã€ã”ç™»éŒ²ã„ãŸã ã„ãŸçš†æ§˜ã®å€‹äººæƒ…å ±ã«ã¤ãã¾ã—ã¦ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†å¾Œã€å¼Šç¤¾ãŒè²¬ä»»ã‚’ã‚‚ã£ã¦æ¶ˆåŽ»ã„ãŸã—ã¾ã™ã€‚ ã“ã‚Œã¾ã§å¤šãã®çš†æ§˜ã«ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ã¦ã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã€çš†æ§˜ã«ã¯ã”ä¸ä¾¿ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ã“ã¨ã€å¿ƒã‚ˆã‚ŠãŠè©«ã³ç”³ã—ä¸Šã’ã¾ã™ã€‚ æœ¬ä»¶ã«é–¢ã™ã‚‹ãŠå•ã„åˆã‚ã›ã¯ã“ã¡ã‚‰ã‚ˆã‚ŠãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
yocchan731 2007/07/10
*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

php

sql
ãƒªãƒ³ã‚¯
PHPã‚¿ã‚°ã‚¯ãƒ©ã‚¦ãƒ‰ã®ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«:phpspoté–‹ç™ºæ—¥èªŒ
PHP Tag Cloud Tutorial | Prism-Perfect.net Well, it's actually so simple it's not really a tutorial at all so much as a snippet with a bit of explanation. But I've had some people ask how it's done, so here's how I do it.PHPã§MySQLã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–ã£ã¦ã‚¿ã‚°ã‚¯ãƒ©ã‚¦ãƒ‰ã‚’ä½œæˆã™ã‚‹ã‚µãƒ³ãƒ—ãƒ«ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ MySQLãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ†ãƒ¼ãƒ–ãƒ«åã¨ã‚«ãƒ©ãƒ å(id,ã‚¯ãƒ©ã‚¦ãƒ‰å¯¾è±¡ã‚«ãƒ©ãƒ å)ã€ ãã—ã¦ãƒ•ã‚©ãƒ³ãƒˆã®æœ€å¤§ã‚µã‚¤ã‚ºã€æœ€å°ã‚µã‚¤ã‚ºã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã§ç°¡å˜ã«ã‚¿ã‚°ã‚¯ãƒ©ã‚¦ãƒ‰ãŒç”Ÿæˆã§ãã¾ã™ã€‚ æ¬¡ãŒå‡ºåŠ›ã•ã‚Œã‚‹ã‚¿ã‚°ã‚¯ãƒ©ã‚¦ãƒ‰ã®ã‚µãƒ³ãƒ—ãƒ«ä¾‹ ã€ŒPHPç”¨ã‚¿ã‚°ã‚¯ãƒ©ã‚¦ãƒ‰ç”Ÿæˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªï¼ˆHTML_TagCloudï¼‰
yocchan731 2007/06/20
php

ã‚¿ã‚°ã‚¯ãƒ©ã‚¦ãƒ‰

*ãƒ‡ã‚¶ã‚¤ãƒ³

sql

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL FULLTEXT Ngram : LIKEæ¤œç´¢ã‚ˆã‚Šæ•°åå€é«˜é€Ÿãªã€ãŠæ‰‹è»½ æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ã«ã¤ã„ã¦ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
yocchan731 2007/03/15
sql

æ¤œç´¢

*è³‡æ–™

perl

php

*ã‚µãƒ¼ãƒ

*ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
ã‚»ã‚ãƒ¥ã‚¢ãªLinuxç’°å¢ƒã¸ã®è¿‘é“â€•â€•Damn Vulnerable Linuxã®ç„¡é˜²å‚™ã•ã‚’æ¥µã‚ã‚ï¼ | OSDN Magazine
Damn Vulnerable Linuxï¼ˆDVLï¼‰ã«ã¯ã€ã‚»ã‚ãƒ¥ã‚¢ãªLinuxãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚ã‚Œã°å‚™ãˆã¦ã„ã¦ã¯â€œã„ã‘ãªã„â€ã‚ã‚‰ã‚†ã‚‹è¦ç´ ãŒå–ã‚Šãã‚ãˆã‚‰ã‚Œã¦ã„ã‚‹ã€‚DVLã®é–‹ç™ºé™£ã¯ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ›ãƒ¼ãƒ«ã®åŽŸå› ã¨ãªã‚‹ç©´ã ã‚‰ã‘ã®æ—§å¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’æ„å›³çš„ã«å¯„ã›é›†ã‚ã‚‹ã“ã¨ã§ã€å¤–éƒ¨ã‹ã‚‰ã®æ”»æ’ƒã«å¯¾ã—ã¦ç„¡é˜²å‚™æ¥µã¾ã‚‹Linuxãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚ã–ã‚ã–ç”Ÿã¿å‡ºã—ãŸã®ã ã€‚ã‚‚ã£ã¨ã‚‚ã“ã®ãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã€ä¸€èˆ¬ãƒ¦ãƒ¼ã‚¶ã®ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ç’°å¢ƒã§ä½¿ã‚ã‚Œã‚‹ã“ã¨ã‚’å‰æã¨ã—ã¦ã„ã‚‹è¨³ã§ã¯ãªãã€ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç”¨ã®æ•™æã¨ã—ã¦ä½œã‚‰ã‚ŒãŸã®ã§ã‚ã‚‹ãŒã€‚ DVLã¯ã€1æžšã®ãƒ©ã‚¤ãƒ–CDã«åŽã‚ã‚‰ã‚ŒãŸå®¹é‡150MBã®ISOå½¢å¼ã§é…å¸ƒã•ã‚Œã¦ã„ã‚‹ã€‚ãã®æ¯ä½“ã¨ã•ã‚ŒãŸã®ã¯ã€ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆãªLinuxãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦äººæ°—ã®é«˜ã„Damn Small Linuxï¼ˆDSLï¼‰ã§ã‚ã‚‹ãŒã€ãã®é¸å®šç†ç”±ã¯ã“ã†ã—ãŸã‚µã‚¤ã‚ºã®å°ã•ã•ã ã‘ã§ã¯ãªãã€2.6
yocchan731 2007/03/05
linux

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

sql

*ã‚µãƒ¼ãƒ

ãŠå½¹ç«‹ã¡

*æ•™è‚²

*ç ”ç©¶

è§£æž
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸