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

webmarksjp id:webmarksjp

sqlã¨tipsã«é–¢ã™ã‚‹webmarksjpã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (19)

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

MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ã“ã®æ–‡æ›¸ã¯ã€osCommerceã§ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹MySQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãŠã‚‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†è€…ã‚ˆã‚Šã‚‚ã€ãƒ¦ãƒ¼ã‚¶ã«å‘ã‘ã¦æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ã“ã“ã§ã¯ã€MySQLã‚µãƒ¼ãƒã¯èµ·å‹•ã—ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®æ–‡å—ã«ã¤ã„ã¦ MySQLã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã®å¤§æ–‡å—ã¨å°æ–‡å—ã‚’åŒºåˆ¥ã—ã¦ã„ã¾ã™ã€‚ãã‚Œä»¥å¤–ã¯åŒºåˆ¥ã—ã¾ã›ã‚“ã€‚ MySQLã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã«ä½¿ãˆã‚‹æ–‡å—ã¯ã€è‹±æ•°å—ã¨_ï¼ˆã‚¢ãƒ³ãƒ€ãƒ¼ãƒãƒ¼ï¼‰ã€$ã€ã‚µãƒ¼ãƒã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã«ã‚ã‚‹æ–‡å—ã§ã™ã€‚ çŸ¥ã£ã¦ãŠããŸã„ã‚³ãƒžãƒ³ãƒ‰ mysqladminï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆãƒ»å‰Šé™¤ã‚„ã€MySQLã‚µãƒ¼ãƒã®æƒ…å ±ã‚’å¾—ã‚‹ï¼‰ mysqlshowï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ï¼‰ mysqlï¼ˆMySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®èµ·å‹•ï¼‰ mysqldumpï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ€ãƒ³ãƒ—ã™ã‚‹ï¼‰ myisamchkï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«
webmarksjp 2008/07/15
MySQL

tips

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

sql

command

è³‡æ–™

é–‹ç™º

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå‰ç·¨ï¼‰ï¼šITpro
ãƒã‚¤ãƒ³ãƒˆ ãƒ»é«˜åº¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ã‚¸ãƒ§ã‚¤ãƒ³ã‚’åˆ©ç”¨ã—ï¼Œæœ€çŸçµŒè·¯ã§ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ ãƒ»ãƒ¡ãƒ¢ãƒªãƒ¼ä¸è¶³ã‚’è‡ªå¾‹çš„ã«è§£æ¶ˆã—ï¼Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ã‚’é«˜ã‚ã‚‹ ãƒ»ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ¼DBã¯å…¨ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªãƒ¼ã§å‡¦ç†ã—ï¼Œé«˜é€ŸåŒ–ã‚’å›³ã‚‹ ç›®çš„åœ°ã«æ—©ãåˆ°ç€ã—ãŸã„ãªã‚‰ï¼Œæœ€çŸã®çµŒè·¯ã‚’æœ€é€Ÿã§è¡Œã‘ã°ã‚ˆã„ã€‚ã“ã‚Œã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã§ã‚‚åŒæ§˜ã ï¼ˆå›³1ï¼‰ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã®æœ€çŸçµŒè·¯ã‚’è¦‹ã¤ã‘ï¼Œãƒ¡ãƒ¢ãƒªãƒ¼ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ã‚’å¢—ã‚„ã—ã¦ï¼Œæœ€é€Ÿã§ãŸã©ã‚Šç€ãã€‚DBã«ã¯ãã‚“ãªæŠ€è¡“ãŒè©°ã¾ã£ã¦ã„ã‚‹ã€‚ å›³1â—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–æŠ€è¡“ã®ãƒã‚¤ãƒ³ãƒˆ ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã„ã€ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ã€‚ã¾ãŸã€ã§ãã‚‹ã ã‘ãƒ¡ãƒ¢ãƒªãƒ¼ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã›ã¦ãŠãã“ã¨ã§ã€ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ã€ã¨ã„ã†äºŒã¤ã®ãƒã‚¤ãƒ³ãƒˆãŒã‚ã‚‹ [ç”»åƒã®ã‚¯ãƒªãƒƒã‚¯ã§æ‹¡å¤§è¡¨ç¤º] ä»¥ä¸‹ã§ã¯ï¼Œï¼ˆ1ï¼‰ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ä»•çµ„ã¿ã¨ï¼Œï¼ˆ2ï¼‰ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ä»•çµ„ã¿ã®
webmarksjp 2008/07/15
æ€§èƒ½

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

è§£èª¬

database

in-memory

SQL

Dev

tips

tuning
ãƒªãƒ³ã‚¯
Open Tech Press | MySQLãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³•
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
webmarksjp 2008/07/14
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

backup

tips

database

development

sql

language
ãƒªãƒ³ã‚¯
SAK Streets
Visual Basic(VB), ADO, RDO, SQL, Oracle PL/SQL, Oracle oo4o, CGI Perl, PHP, MySQL, ASP, JAVA Servlet, JSP, PostgreSQL ç‰ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžè³‡æ–™ã¨CGIç”»åƒæ·»ä»˜æŽ²ç¤ºæ¿ä»–ãƒ•ãƒªãƒ¼CGI, ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å…¬é–‹
webmarksjp 2008/07/14
Perl

vb

sql

php

oracle

tips

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

ã“ã‚Œã¯ä¾¿åˆ©

â˜†SQL
ãƒªãƒ³ã‚¯
SHIFT the Oracle - oracle tips and tricks
ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¯ 2007 å¹´ã«ä»¥ä¸‹ã®å°‚ç”¨ãƒ‰ãƒ¡ã‚¤ãƒ³ã«ç§»è»¢ã—ã¾ã—ãŸã€‚ https://www.shift-the-oracle.com/
webmarksjp 2008/07/14
ä»•äº‹

oracle

tips

database

sql

db

reference

development
ãƒªãƒ³ã‚¯
åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ5ï¼‰ï¼šITpro
SQLæ–‡ã‚’å®Ÿè¡Œã™ã‚‹éš›ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤§ããªå½±éŸ¿ã‚’åŠã¼ã™ã‚‚ã®ã¨ã—ã¦ï¼Œã‚‚ã†ä¸€ã¤ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‚Šã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã¯ï¼Œã©ã†å®šç¾©ã™ã¹ãã‹ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆä¸Šã®å•é¡Œã¨ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æœ‰åŠ¹ã«ä½¿ã†ãŸã‚ã®SQLæ–‡ã‚’ã©ã†æ›¸ãã¹ãã‹ã¨ã„ã†ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ä¸Šã®å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã“ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆä¸Šã®å•é¡Œã‚’ä¸»ã«å–ã‚Šä¸Šã’ã¾ã™ã€‚SQLæ–‡ã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«ã¤ã„ã¦ã¯å›²ã¿è¨˜äº‹ã€ŒSQLæ–‡ã‚’æœ€é€Ÿã«ã™ã‚‹11ã®ãƒã‚¤ãƒ³ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ï¼Œãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¤œç´¢é€Ÿåº¦ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ãã‚Œãžã‚Œã®SQLæ–‡ã«å¯¾ã—ã¦æœ€é©ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹ã®ãŒç†æƒ³çš„ã§ã™ãŒï¼Œå®Ÿéš›ã«ã¯ã‚ã‚‹ç¨‹åº¦é™ã‚‰ã‚ŒãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ï¼Œå¿…è¦ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¦ä»¶ã‚’æº€ãŸã™ã‚ˆã†ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚åŠ ãˆã¦ï¼Œã©ã‚“ãªSQLæ–‡ãŒå®Ÿéš›ã«ç™ºè¡Œã•ã‚Œã‚‹ã®ã‹ãŒã‚ã‚‰ã‹ã˜ã‚ã‚ã‹ã£ã¦ã„ãªã„å ´åˆã¯ï¼Œé©å½“ãªæƒ³å®šã«åŸºã¥ã„ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã—ã¦ãŠã‹ãªãã¦ã¯
webmarksjp 2008/07/14
study

pc

archive

database

sql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

RDBMS

tips

*ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
mysqlã‚³ãƒžãƒ³ãƒ‰ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã¨ã‹ã‚«ãƒ©ãƒ åã®è£œå®Œ(completion)ã‚’ã™ã‚‹æ–¹æ³• - (ã²)ãƒ¡ãƒ¢
è¿½è¨˜: rehash(auto-rehashã‚‚å«ã‚€)ã™ã‚‹ã¨ã€SQLæ–‡ã®è£œå®Œ(seleã§ã‚¿ãƒ–æ‰“éµã¨ã‹)ãŒåŠ¹ã‹ãªããªã‚‹ã‚ˆã¨ã€ã¯ã™å‘ã‹ã„ã®äººã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ å€‹äººçš„ã«ã¯ã€SQLã¯ã€Œmysql> help selectã€ã¨ã‹ã§ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ˜ãƒ«ãƒ—ãŒã³ã‚‡ã£ã¨å‡ºã‚‹ã®ã§ã€ã‚¹ã‚ãƒ¼ãƒžã®è£œå®ŒãŒã§ãã‚‹ã‚“ãªã‚‰SQLã®è£œå®Œã¯ã¨ã‚Šã‚ãˆãšã‚ãã‚‰ã‚ã¦ã‚‚ã„ã„ã‹ãªã¨æ€ã£ã¦ã„ã¾ã™ã€‚ å¸¸ã€…ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã¨ã‹è£œå®Œã§ãã‚‹ã¨ã„ã„ãªãƒ¼ã¨æ€ã£ã¦ã„ãŸã®ã§ã€ãƒœãƒã£ã¨ãã„ã¦ã¿ãŸã‚‰æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ã‚ã–ãƒ¼ãƒ¼ãƒ¼ãƒ¼ã£ã™ï¼ id:mikihoshi++ id:tokuhirom++ id:precuredaisuki++ ãŠã‹ã’ã§åŠ¹çŽ‡ãŒ300%ä¸ŠãŒã‚Šã¾ã—ãŸã€‚(Benchmark::Stopwatchã§è¨ˆæ¸¬) http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option
webmarksjp 2008/07/14
mysql

sql

tips

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

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
TECHSCORE - Java,SQLãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æŠ€è¡“è§£èª¬
SQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œè¨€èªžSQLã«ã¤ã„ã¦ã€ã¾ãŸRDBMSã®æŒã¤æ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãè§£èª¬ã—ã¾ã™ã€‚ DBæ¦‚è¦ã€SQLã€ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œã€ãƒ‡ãƒ¼ã‚¿æ“ä½œ ... ç‰¹é›†ï¼šreplication PostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã‚’ç´¹ä»‹ã—ã€ãã‚Œã‚‰ã®æ©Ÿèƒ½ã‚’æ¯”è¼ƒã—ã¦ã„ãã¾ã™ã€‚ ç‰¹é›†ï¼špgbench PostgreSQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã«ç”¨ã„ã‚‰ã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚‹ pgbench ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLæ¼”ç¿’å•é¡Œ å„ç« ã«ç”¨æ„ã•ã‚ŒãŸæ¼”ç¿’å•é¡Œã‚’é›†ã‚ã¾ã—ãŸã€‚
webmarksjp 2008/07/14
Java

Web

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

portal

programming

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

program

development

tips
ãƒªãƒ³ã‚¯
ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã§mysqlã®è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— | ãƒ©ãƒ³ã‚µãƒ¼ã‚ºç¤¾é•·æ—¥è¨˜
ã„ã„ãï¼ 4 ãƒ„ã‚¤ãƒ¼ãƒˆ B! ã¯ã¦ãƒ– 185 Pocket 22 ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã¯éžå¸¸ã«é«˜æ©Ÿèƒ½ãªã‚“ã§ã™ãŒã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã ã‘ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ï¼ˆç§ãŒç¢ºèªã™ã‚‹é™ã‚Šã€‚ï¼‰ HTMLã‚„GIFã€PHPãªã©ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯ãƒãƒ¼ã‚«ãƒ«ã®PCã§æŒã£ã¦ã„ã‚‹ã‹ã‚‰å¤§æŠµã¯å¤§ä¸ˆå¤«ã ã¨ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç³»ã¯é–“é•ã£ã¦å…¨éƒ¨æ¶ˆã—ã¦ã—ã¾ã£ãŸæ—¥ã«ã¯ç›®ã‚‚å½“ã¦ã‚‰ã‚Œã¾ã›ã‚“ã€‚ã€‚å®šæœŸçš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ãŒã€å¿˜ã‚Œã‚‹ã“ã¨ã‚‚ã‚ˆãã‚ã‚‹ã®ã§ã€è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’cronã«ç™»éŒ²ã—ã¨ãã¾ã—ãŸã€‚ ã‚ˆãã‚ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ã™ãŒã€å‚è€ƒã¾ã§ã«å¼µã£ã¦ãŠãã¾ã™ã€‚3æ—¥é–“åˆ†ã®MYSQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ã‚¿ã‚’ä¿æŒã—ã¾ã™ã€‚mysqlã®ID/PWãªã©ã¯æ›¸ãæ›ãˆã¦ä¸‹ã•ã„ã€‚ ä½•ã‚‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãªã‚“ã¦ã—ã¦ãªã„ï¼ã¨ã„ã†äººã¯ã€è‡ªå·±è²¬ä»»ã§ä½¿ã£ã¦ã¿ã¦ä¸‹ã•ã„ã€‚ #!/bin/sh PATH=/bin:/usr/bin:/sbin:/usr/sbin:/
webmarksjp 2008/07/14
ã‚µãƒ¼ãƒãƒ¼

ã‚µãƒ¼ãƒ

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

é‹ç”¨

web

sql

db

mysql

tips
ãƒªãƒ³ã‚¯
GT Nitro: ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ãƒ»ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ã‚²ãƒ¼ãƒ - Google Play ã®ã‚¢ãƒ—ãƒª
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
webmarksjp 2008/07/14
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

DB

performance

tips

sql

ã‚ãƒ£ãƒªã‚¢
ãƒªãƒ³ã‚¯
Tagã®æ¤œç´¢ã«MySQLã®å…¨æ–‡æ¤œç´¢ã‚’ä½¿ã† : blog.nomadscafe.jp
Tagã®æ¤œç´¢ã«MySQLã®å…¨æ–‡æ¤œç´¢ã‚’ä½¿ã† Tags with MySQL fulltextã‚’å‚è€ƒã«ã—ã¦è©¦ã—ã¦ã¿ãŸã€‚ Femoã®ä¸ã§ã€ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ãŸã®ã«ç¶šã„ã¦ã€ã€Œå®Œäº†ã€ã‚„ã€Œfinishã€ã¨è¨€ã£ãŸã‚¿ã‚°ãŒã¤ã„ã¦ã„ã‚‹å ´åˆè¡¨ç¤ºã—ãªã„ã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’è€ƒãˆã¦ã„ã‚‹ã€‚ ãã†ãªã£ã¦ãã‚‹ã¨ã€SQLã‚’ã©ã†æ›¸ã‘ã°ã„ã„ã®ã‹ã€ã¾ãŸè¤‡é›‘ãªSQLã‚’æ§‹ç¯‰ã—ãŸã¨ãã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯å¤§ä¸ˆå¤«ãªã®ã‹ã¨å¿ƒé…ã€‚ãã“ã§ã€ä¸Šè¨˜ã®URLã‚’å‚è€ƒã«ã—ãªãŒã‚‰MySQLã®å…¨æ–‡æ¤œç´¢ã«æ³¨ç›®ã€‚ create table ft_tags( id int unsigned not null auto_increment primary key, tags text, unpack text, fulltext (unpack) ) ã¨è¨€ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã€‚ ã“ã“ã«ã€ my @tags = ( q/task femo/, q/femo mail t
webmarksjp 2008/07/14
Pè¨€èªž

Webãƒ‡ã‚¶ã‚¤ãƒ³

ãƒ—ãƒã‚°ãƒ©ãƒ

mysql

tag

db

tips

perl

sql

search
ãƒªãƒ³ã‚¯
SQLã§é›†åˆæ¼”ç®—ï¼šCodeZine
ã¯ã˜ã‚ã«ã€€SQLãŒé›†åˆè«–ã«ç«‹è„šã™ã‚‹è¨€èªžã§ã‚ã‚‹ã¨ã„ã†ã“ã¨ã¯ã€ã“ã®é€£è¼‰ã§ä¸€è²«ã—ã¦å¼·èª¿ã—ã¦ããŸãƒ†ãƒ¼ãƒžã®ä¸€ã¤ã§ã™ã€‚ãã®ç‰¹æ€§ã®ã‚†ãˆã«ã€SQLã¯ã€Œé›†åˆæŒ‡å‘è¨€èªžã€ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã—ã€å®Ÿéš›ã€é›†åˆçš„ãªè¦³ç‚¹ã‹ã‚‰è¦‹ãŸã¨ãã«åˆã‚ã¦ã€ãã®å¼·åŠ›ã•ãŒç†è§£ã§ãã‚‹ã¨ç§ã¯è€ƒãˆã¦ã„ã¾ã™ã€‚ã—ã‹ã—ç¾å®Ÿã«ã¯ã€SQLã®ã“ã®å´é¢ã¯é•·ã‚‰ãç„¡è¦–ã•ã‚Œã¦ãã¾ã—ãŸã€‚ã€€ãã®èƒŒæ™¯ã«ã¯ã€SQLã«ã‚‚è²¬ä»»ã®ä¸€ç«¯ãŒã‚ã‚Šã¾ã™ã€‚ã¨ã„ã†ã®ã‚‚ã€SQLã¯ã¡ã‚‡ã£ã¨å‰ã¾ã§ã€é«˜æ ¡ã§ç¿’ã†ç¨‹åº¦ã®åŸºæœ¬çš„ãªé›†åˆæ¼”ç®—åã™ã‚‰æŒã£ã¦ã„ãªã‹ã£ãŸã‹ã‚‰ã§ã™ã€‚å’Œï¼ˆUNIONï¼‰ã“ãSQL-86ã‹ã‚‰ã®å¤å‚ã§ã™ãŒã€äº¤å·®ï¼ˆINTERSECTï¼‰ã¨å·®ï¼ˆEXCEPTï¼‰ãŒæ¨™æº–ã«å…¥ã£ãŸã®ã¯SQL-92ã§ã™ã—ã€é™¤ç®—ï¼ˆDIVIDE BYï¼‰ãŒæœªã ã«æ¨™æº–åŒ–ã•ã‚Œã¦ã„ãªã„ã“ã¨ã¯ã€å‰ã«ã‚‚è¿°ã¹ã¾ã—ãŸã€‚ã ã‹ã‚‰ã€SQLãŒè¨€èªžã¨ã—ã¦ä¸å®Œå…¨ã ã¨ã„ã†æ‰¹åˆ¤ã¯ã€ç†ç”±ã®ãªã„ã‚‚ã®ã§ã¯ãªã‹ã£ãŸã®ã§ã™ã€‚ã€€ã—ã‹ã—ã€ç¾åœ¨ã§ã¯æ¨™æº–SQLã«åŸºæœ¬çš„ãªé›†åˆæ¼”ç®—å
webmarksjp 2008/07/14
DB

deferred

SQL

Programming

tips

database

@MySQL

@SQL
ãƒªãƒ³ã‚¯
Oracle Technology Network (OTN) Japan
webmarksjp 2008/07/13
DB

ORACLE

_ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

sql

manual

tips
ãƒªãƒ³ã‚¯
PreparedStatementAndNull
312 ï¼š1/3ï¼š05/03/12 03:17:26 ID:??? çªç„¶ã§ã™ãŒï¼Œé¢ç™½ã„ SQL ã‚’æ€ã„ã¤ã„ãŸã®ã§ï¼Œã”æ„è¦‹ã‚’é ‚ããŸã„ã§ã™ï¼Žèˆˆå‘³ã‚’æŒãŸã‚ŒãŸæ–¹ã¯ä½¿ã£ã¦ã¿ã¦ãã ã¡ã„ã€‚ ä¸€èˆ¬çš„ã«ï¼ŒSQL ã®ç™ºè¡Œã¯ï¼Œãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ä½¿ã†æ–¹ãŒã‚ˆã„ã¨ã•ã‚Œã¦ã„ã‚‹ï¼Žãã®ç†ç”±ã¯ï¼Œ DBMS ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒè‰¯ãåŠ¹ãï¼Ž SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ç‰ã®å±é™ºãŒé¿ã‘ã‚‰ã‚Œã‚‹ï¼Œç‰ï¼Ž ã—ã‹ã—ï¼Œwebã‚¢ãƒ—ãƒªã®æ¤œç´¢ãƒ•ã‚©ãƒ¼ãƒ ãªã©ã§ã¯ï¼Œãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯ä½¿ãˆãªã„å ´åˆãŒå¤šã‹ã£ãŸï¼Žæ¤œç´¢æ¡ä»¶é …ç›®ãŒè¤‡æ•°å˜åœ¨ã—ã¦ã„ã¦ï¼Œã„ãšã‚Œã®é …ç›®ã‚‚å¿…é ˆã§ç„¡ã„å ´åˆï¼Œé …ç›®ãŒå…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ã‹ã©ã†ã‹ã‚’ãƒã‚§ãƒƒã‚¯ã—ï¼Œãã‚Œã«åˆã‚ã›ã¦SQL æ–‡ã® WHERE å¥ã®å†…å®¹ã‚’ãƒ„ã‚®ãƒã‚®ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã‹ã‚‰ã ï¼Ž SQLæ–‡ãã®ã‚‚ã®ã‚‚ï¼Œãã—ã¦ãã‚Œã«ã‚»ãƒƒãƒˆã™ã‚‹å¼•æ•°ã®å€‹æ•°ã‚‚å¯å¤‰ãªã®ã§ï¼Œãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ä½¿ã†ã®ã¯ç„¡ç†ã ã£ãŸã®ã§ã‚ã‚‹ï¼Ž ä»Šå›žæ€ã„ã¤ã„ãŸã®ã¯ï¼Œã“ã®ã‚ˆã†ãªæ¡ä»¶ã§
webmarksjp 2008/07/13
programming

tips

sql

rdbms

db

DBè¨è¨ˆ
ãƒªãƒ³ã‚¯
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬23å›žã€€æŠ¼ã•ãˆã¦ãŠããŸã„ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢ã®ãƒã‚¤ãƒ³ãƒˆ
ã‚ˆãï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é‹ç”¨ã«é–¢ã™ã‚‹ç›¸è«‡ã®ä¸ã§ã¯ï¼Œãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨å¯ç”¨æ€§(ã‚¢ãƒ™ã‚¤ãƒ©ãƒ“ãƒªãƒ†ã‚£)ã‚’æ··åŒã—ã¦ã„å ´åˆãŒã‚ã‚‹ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ï¼Œã‚ã‚‹çž¬é–“ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã“ã¨ãŒç›®çš„ã§ã‚ã‚‹ã€‚éšœå®³ãŒç™ºç”Ÿã—ãŸéš›ã«ä¿å˜ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’å†ç¾ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šï¼Œå¾©å…ƒã‚’ãŠã“ãªã†ã€‚ å¯ç”¨æ€§ã¯ï¼Œéšœå®³å¯¾ç–ã¨ã—ã¦ï¼Œã§ãã‚‹ã ã‘æ¢ã‚ãšã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é‹ç”¨ã™ã‚‹ã“ã¨ã‚’ç›®çš„ã¨ã—ã¦ã„ã‚‹ã€‚ã‚‚ã—ï¼Œæ¢ã‚ã‚‹å ´åˆã«ã‚‚æœ€å°é™ã®æ™‚é–“ã§ï¼Œå¾©æ—§ã™ã‚‹ã“ã¨ã‚’ç›®çš„ã¨ã—ã¦ã„ã‚‹ã€‚ éšœå®³ãŒç™ºç”Ÿã—ãŸå ´åˆã«ï¼Œé€Ÿã‚„ã‹ã«å¾©æ—§ã™ã‚‹ã“ã¨ã¯ï¼Œéžå¸¸ã«é‡è¦ãªã“ã¨ã§ã‚ã‚‹ã€‚ãã®ãŸã‚ï¼Œã€Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã‚’ä½¿ç”¨ã™ã‚Œã°ä¸‡å…¨ã€ã¨è€ƒãˆã‚‹ã®ã¯ï¼Œé–“é•ã„ã§ã‚ã‚‹ã€‚ã‚‚ã—ï¼Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°è‡ªèº«ã«éšœå®³ãŒç™ºç”Ÿã™ã‚Œã°ï¼Œå¿…ãšãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ã‚¿ã«ã‚ˆã£ã¦ï¼Œå¾©æ—§ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ã¾ãŸï¼Œèª¤ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ›´æ–°ã‚’å®Ÿè¡Œã—ãŸå ´åˆï¼Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã¯ï¼Œã™ã¹ã¦ã®ã‚µãƒ¼ãƒãƒ¼ãŒå³åº§ã«æ›´æ–°ã‚’å®Ÿè¡Œã™ã‚‹ã€‚ãã®ãŸ
webmarksjp 2008/07/13
MySQL

tips

é–‹ç™º

db

backup

sql
ãƒªãƒ³ã‚¯
ãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ - ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼
ãŠã‚‰! ã‚ªãƒ©! Oracle - ã©ã£ã·ã‚Šæ¤œè¨¼ç”Ÿæ´» ãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ç™»éŒ²/è§£é™¤ ã“ã®ãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã‚’è³¼èªã•ã‚Œã‚‹æ–¹ã€ã¾ãŸã¯è³¼èªã‚’è§£é™¤ã•ã‚Œã‚‹æ–¹ã¯ã€ç”»é¢å·¦ã®ç™»éŒ²/è§£é™¤ãƒ•ã‚©ãƒ¼ãƒ ã«ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’å…¥åŠ›ã—ã¦ä¸‹ã•ã„ã€‚ â€»ã“ã®ãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã¯ã¾ãã¾ãã‹ã‚‰ã®é…ä¿¡ã¨ãªã‚Šã¾ã™ã€‚ ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼
webmarksjp 2008/07/13
oracle

database

sql

db

tips
ãƒªãƒ³ã‚¯
ã€MySQLã‚¦ã‚©ãƒƒãƒã€‘ç¬¬8å›ž MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼šITpro
SlowLogã®è¨å®š ç’°å¢ƒè¨å®šãƒ•ã‚¡ã‚¤ãƒ«(Windowsã§ã¯my.iniï¼ŒLinuxã§ã¯my.cnf)ã«æ¬¡ã®ã‚ˆã†ãªè¨å®šã‚’åŠ ãˆã‚‹ã¨SlowLogãŒæœ‰åŠ¹ã«ãªã‚‹ã€‚ log-slow-queries SlowLogã®æœ‰åŠ¹åŒ–(ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«åã‚’æŒ‡å®šå¯èƒ½) long-query-time=2 SlowLogã«è¨˜éŒ²ã™ã‚‹å‡¦ç†æ™‚é–“ã®ä¸Šé™ log-long-format ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ãªã„SQLæ–‡ã®è¨˜éŒ² long-query-timeãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ï¼ŒSlowLogã«è¨˜éŒ²ã™ã‚‹ã—ãã„å€¤ã‚’ç§’å˜ä½ã§è¨å®šã™ã‚‹ã€‚ã“ã®å ´åˆã«ã¯ï¼Œ2ç§’è¶…ãˆã‚‹å‡¦ç†æ™‚é–“ã‚’è²»ã‚„ã—ãŸSQLæ–‡ã‚’è¨˜éŒ²ã™ã‚‹ã€‚ã¾ãŸï¼Œlog-long-formatã‚’æŒ‡å®šã™ã‚‹ã¨ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ãªã„SQLæ–‡ã‚‚SlowLogã«è¨˜éŒ²ã™ã‚‹ã€‚ SlowLogã®ç¢ºèª SlowLogãŒå‹•ä½œã—ã¦ã„ã‚‹ã‹ã©ã†ã‹ã¯ï¼Œæ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã§ç¢ºèªã§ãã‚‹ã€‚log_slow_queriesãŒONã§ã‚ã‚Œã°æœ‰åŠ¹ã¨
webmarksjp 2008/07/12
database

mysql

tips

performance

sql

tunning
ãƒªãƒ³ã‚¯
Let'sãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
Let'sãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã§ã¯åˆå¿ƒè€…ã®æ–¹ã‚’å¯¾è±¡ã«Javaã‚„Pythonã€PHPã€Rubyãªã©è‰²ã€…ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®è§£èª¬ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ Java Javaå…¥é–€ ã“ã‚Œã‹ã‚‰Javaã‚’ä½¿ã£ãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®ç¿’å¾—ã‚’ç›®æŒ‡ã—ã¦ã„ã‚‹æ–¹ã‚’å¯¾è±¡ã¨ã—ãŸãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã§ã™ ã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆ(Servlet) / JSPå…¥é–€ ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã§å‹•ä½œã™ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œæˆæ–¹æ³• Androidãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ ãƒ¢ãƒã‚¤ãƒ«å‘ã‘ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ Android ã§å‹•ãã‚¢ãƒ—ãƒªã®ä½œæˆ Swingã‚’ä½¿ã£ã¦ã¿ã‚ˆã† GUIã‚’ä½¿ã£ãŸJavaã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œæˆã§ä½¿ç”¨ã™ã‚‹Swingå…¥é–€ã§ã™
webmarksjp 2008/07/12
database

mysql

Oracle

postgreSQL

SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

*ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
http://neta.ywcafe.net/000520.html
webmarksjp 2008/07/12
*web

ã¦) tips

ã¡) çŸ¥è˜

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

ITæ¥ç•Œ

SQL

tips

postgresql

programming

security
ãƒªãƒ³ã‚¯
1