[B! db][tips] aki77ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

aki77 id:aki77

dbã¨tipsã«é–¢ã™ã‚‹aki77ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

Androidã®NFCæ©Ÿèƒ½ã§FeliCaã®èªã¿æ›¸ãã‚’ã™ã‚‹ | âˆ’ã‚†ã‚ãƒã‚°âˆ’ | ã‚†ã‚ã¿ã‚¹ã‚¿ãƒƒãƒ•ãƒ–ãƒã‚°
aki77 2010/05/18
opensocial
ãƒªãƒ³ã‚¯
æ–°è¦
ç›¾é›†åŸŸååœæ”¾æ˜¯å…¨çƒä¼˜è´¨è¡Œä¸šå¯¼èˆªå¤‡æ¡ˆç½‘ç«™é¢†å¯¼è€… ä¸ºä¸å°ä¼ä¸šæä¾›æ•°å—åŒ–ã€å¿«é€ŸåŒ–ã€è½»é‡åŒ–ã€ç²¾å‡†åŒ–çš„ç½‘ç«™é“¾æŽ¥æœåŠ¡ dns1.dopa.com,dns2.dopa.com ç‰ˆæƒæ‰€æœ‰ æœ¬ç«™å†…å®¹æœªç»ä¹¦é¢è®¸å¯,ç¦æ¢ä¸€åˆ‡å½¢å¼çš„è½¬è½½ Â© CopyRightÂ 2023 ç›¾é›†åŸŸååœæ”¾click.com.cnÂ Â Â Â æµ™ICPå¤‡20018420å·-2 æå·žç›¾é›†ç½‘ç»œæœ‰é™å…¬å¸
aki77 2007/04/23
ã€Œurlã®md5ã‚’ä½œã£ã¦ãã¡ã‚‰ã‚’è¦‹ã‚‹ã®ãŒå¸¸è˜ã€

db

tips
ãƒªãƒ³ã‚¯
æ–°è¦
ç›¾é›†åŸŸååœæ”¾æ˜¯å…¨çƒä¼˜è´¨è¡Œä¸šå¯¼èˆªå¤‡æ¡ˆç½‘ç«™é¢†å¯¼è€… ä¸ºä¸å°ä¼ä¸šæä¾›æ•°å—åŒ–ã€å¿«é€ŸåŒ–ã€è½»é‡åŒ–ã€ç²¾å‡†åŒ–çš„ç½‘ç«™é“¾æŽ¥æœåŠ¡ dns1.dopa.com,dns2.dopa.com ç‰ˆæƒæ‰€æœ‰ æœ¬ç«™å†…å®¹æœªç»ä¹¦é¢è®¸å¯,ç¦æ¢ä¸€åˆ‡å½¢å¼çš„è½¬è½½ Â© CopyRightÂ 2023 ç›¾é›†åŸŸååœæ”¾click.com.cnÂ Â Â Â æµ™ICPå¤‡20018420å·-2 æå·žç›¾é›†ç½‘ç»œæœ‰é™å…¬å¸
aki77 2007/04/21
ã€Œã‚¢ã‚¯ã‚»ã‚¹æ•°ã‚’è¨˜éŒ²ã™ã‚‹ã¨ã“ã‚ã§æ¯Žå›ž+1ã‚’UPDATEã™ã‚‹ã¨é‡ã„ã®ã§5å›žã«1å›žã€5å¢—ã‚„ã™ã€

programming

idea
ãƒªãƒ³ã‚¯
ç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã§è¡Œã¨è¡Œã‚’æ¯”è¼ƒã™ã‚‹ï¼šCodeZine
ã¯ã˜ã‚ã«ã€€SQLã§ã¯ã€åŒã˜è¡Œå†…ã®åˆ—åŒå£«ã‚’æ¯”è¼ƒã™ã‚‹ã“ã¨ã¯ç°¡å˜ã«ã§ãã¾ã™ã€‚æ™®é€šã«WHEREå¥ã«ã€Œcol_1 = col_2ã€ã®ã‚ˆã†ã«æ›¸ã‘ã°ã‚ˆã„ã ã‘ã§ã™ã‹ã‚‰ã€‚ä¸€æ–¹ã€ç•°ãªã‚‹è¡Œã®é–“ã§åˆ—åŒå£«ã‚’æ¯”è¼ƒã™ã‚‹ã“ã¨ã¯ã€ãã‚Œã»ã©ç°¡å˜ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã§ã™ãŒãã‚Œã¯ã€SQLã§è¡Œé–“æ¯”è¼ƒãŒã§ããªã„ã¨ã„ã†ã“ã¨ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚æ‰‹ç¶šãåž‹è¨€èªžã¨ã¯ã‹ãªã‚Šç•°ãªã‚‹ç™ºæƒ³ã«åŸºã¥ã„ã¦ã„ã¾ã™ãŒã€SQLã§ã‚‚ãã†ã—ãŸå‡¦ç†ã‚’è¨˜è¿°ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ã€€SQLã§è¡Œé–“æ¯”è¼ƒã‚’ã™ã‚‹éš›ã«å¨åŠ›ã‚’ç™ºæ®ã™ã‚‹ã®ãŒç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã€ç‰¹ã«è‡ªå·±çµåˆã¨çµ„ã¿åˆã‚ã›ãŸã€Œè‡ªå·±ç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã€ã§ã™ã€‚æœ¬ç¨¿ã§ã¯ã€ã“ã®æŠ€è¡“ã‚’ä½¿ã£ãŸè¡Œé–“æ¯”è¼ƒã®å¿œç”¨æ–¹æ³•ã‚’ã€å…·ä½“ä¾‹ã‚’é€šã—ã¦è§£èª¬ã—ã¾ã™ã€‚ç¨¼åƒç’°å¢ƒOracle SQL ServerDB2PostgreSQL MySQLï¼ˆãƒãƒ¼ã‚¸ãƒ§ãƒ³4.1ä»¥ä¸Šï¼‰ å¯¾è±¡èªè€…ã€€ç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã‚’çŸ¥ã£ã¦ã„ã‚‹æ–¹ã€‚CASEå¼ã€è‡ªå·±çµåˆã€ã‚¹ã‚«ãƒ©ãƒ»ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ã¤ã„ã¦ã®çŸ¥è˜ãŒã‚ã‚‹ã¨
aki77 2007/02/14
db

sql

tips
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: PHPã§æ›¸ã‹ã‚ŒãŸwebã‚µãƒ¼ãƒ“ã‚¹ã‚’é«˜é€ŸåŒ–ã™ã‚‹2
å‰å›žã®ã‚¨ãƒ³ãƒˆãƒªPHPã§æ›¸ã‹ã‚ŒãŸwebã‚µãƒ¼ãƒ“ã‚¹ã‚’é«˜é€ŸåŒ–ã™ã‚‹ã§ã¯é«˜é€ŸåŒ–ã®ãƒ¬ãƒ™ãƒ«ã®ã†ã¡ã€æœ€åˆã®2æ®µéšŽã€Œãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã«ã‚ˆã‚‹é«˜é€ŸåŒ–ã€ã€Œã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«ã‚ˆã‚‹é«˜é€ŸåŒ–ã€ã«ã¤ã„ã¦æ›¸ãã¾ã—ãŸã€‚ ä»Šå›žã¯ç¬¬2å¼¾ã¨ã—ã¦ã€Œãƒ—ãƒã‚°ãƒ©ãƒ ã®å·¥å¤«ã«ã‚ˆã‚‹é«˜é€ŸåŒ–ã€ã«ã¤ã„ã¦æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ - DBã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã¯è‡ªåˆ†ã§æŠ½è±¡åŒ–ã™ã‚‹ DBã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’é«˜é€ŸåŒ–ã™ã‚‹ãŸã‚ã«ã¯ã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã£ãŸã‚Šè¤‡æ•°å°æ§‹æˆã«ã™ã‚‹ã‚ã‘ã§ã™ãŒã€ åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹Pear::DBã¨ã‹adodbã¯è¤‡æ•°å°æ§‹æˆã®DBã«æŽ¥ç¶šã™ã‚‹ã“ã¨ã‚’è€ƒæ…®ã•ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ Pear::DBã‚„adodbã¯ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã«ä½¿ã£ã¦ã€ãƒ©ãƒƒãƒ‘ãƒ¼ã‚¯ãƒ©ã‚¹ã‚’ä½œã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ - æ›´æ–°ç³»ã‚¯ã‚¨ãƒªã¨èªã¿å‡ºã—ç³»ã‚¯ã‚¨ãƒªã®ãƒ¦ãƒ¼ã‚¶ã‚’åˆ†ã‘ã‚‹ ã“ã‚Œã¯é«˜é€ŸåŒ–ã¨ã¯é–¢ä¿‚ãªã„ã‚“ã§ã™ãŒã€ãœã²å®Ÿè¡Œã—ã¦ã‚‚ã‚‰ã„ãŸã„ã®ã§æ›¸ãã¾ã—ãŸã€‚ è¤‡æ•°å°æ§‹æˆã®ã‚µãƒ¼ãƒã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã¨ãã¯æ›´æ–°ç³»ã‚¯ã‚¨ãƒªã¯ãƒžã‚¹ã‚¿ãƒ¼ã«ç™ºè¡Œã—ã¦ã€ èªã¿å‡ºã—ç³»ã‚¯ã‚¨
aki77 2006/06/07
php

db

tips

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

sql

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

db

sql

tips
ãƒªãƒ³ã‚¯
1