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

proto_jp id:proto_jp

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

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

å€‹äººã§WEBé–‹ç™ºã‚’ï¼‘ï¼•å¹´ãã‚‰ã„ã‚„ã£ã¦ã‚‹è€…ã§ã™ãŒ
ã“ã®è¨˜äº‹ã‚’è¦‹ã¦ã³ã£ãã‚Šã—ãŸã€‚ https://laiso.hatena blog.com/entry/nope-sql ã€Œå€‹äººé–‹ç™ºã®ã‚³ã‚¹ãƒˆã¯DBæ¬¡ç¬¬ã€ ã¾ãšãƒ“ãƒƒã‚¯ãƒªã—ãŸã®ã¯ã€ŒDBã£ã¦ãã‚“ãªã«ãŠé‡‘ã‹ã‹ã‚‹ï¼Ÿã€ã¨ã„ã†ç‚¹ã€‚ ã‚‚ã¡ã‚ã‚“DBãŒã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€CPUã€ãƒ¡ãƒ¢ãƒªã‚’é£Ÿã†ã®ã¯åˆ†ã‹ã‚‹ã€‚ ã§ã‚‚VPSãªã‚‰ãã‚“ãªã«ã‚³ã‚¹ãƒˆã‹ã‹ã‚‰ã‚“ã ã‚ã†ï¼Ÿ ä¿ºã¯ï¼‘æ—¥100ä¸‡PVã»ã©ã®ã‚¨ãƒã‚µã‚¤ãƒˆã‚’é‹å–¶ã—ã¦ã„ã‚‹ãŒã€WEBã‚µãƒ¼ãƒ1å°ã€DBã‚µãƒ¼ãƒ1å°ã€ç”»åƒã‚µãƒ¼ãƒ2å°ã§å‹•ã„ã¦ã„ã‚‹ãžï¼Ÿ VPS4å°ã§æœˆé¡6000å††ãã‚‰ã„ã€‚ æ¬¡ã«ãƒ“ãƒƒã‚¯ãƒªã—ãŸã®ã¯ã€å€‹äººé–‹ç™ºãªã®ã«é›£ã—ãã†ãªDBã‚µãƒ¼ãƒã‚’ä½¿ã£ã¦ã„ã‚‹äº‹ã€‚ ã€ŒCloud Firestoreã€ã€ŒAmazon DynamoDBã€ã€ŒMongo DB Atlasã€ â†‘ä¿ºã€å…¨éƒ¨çŸ¥ã‚‰ãªã„ã€‚ã€‚ã€‚ ã‚‚ã¡ã‚ã‚“ã€ã“ã†ã—ãŸDBã‚µãƒ¼ãƒã®å¿…è¦æ€§ã¯åˆ†ã‹ã‚‹ã®ã‚ˆã€‚ ç¨¼åƒçŽ‡ã€å®‰å®šæ€§ã€æ‹¡å¼µæ€§ãªã©ãªã©ã€‚ ã§ã‚‚ãã‚Œã£ã¦ã€å¤§è¦æ¨¡ã‚µã‚¤ãƒˆå‘ã‘ã˜ã‚ƒãªã„
proto_jp 2022/05/06
é–‹ç™º

vps

sql

db

web

development
ãƒªãƒ³ã‚¯
ã€Œæ–°å…¥ç¤¾å“¡ã®ãŸã‚ã®å¤§è¦æ¨¡ã‚²ãƒ¼ãƒ é–‹ç™ºå…¥é–€ ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ç·¨ã€ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’å…¬é–‹ã—ã¾ã—ãŸï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã€Œæ–°å…¥ç¤¾å“¡ã®ãŸã‚ã®å¤§è¦æ¨¡ã‚²ãƒ¼ãƒ é–‹ç™ºå…¥é–€ ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ç·¨ã€ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’å…¬é–‹ã—ã¾ã—ãŸ matsuiã§ã™ã€‚ å…ˆé€±æœ«ã®2014å¹´6æœˆ13æ—¥ï½ž14æ—¥ã«ã€æœå¹Œã§ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ 2014 HokkaidoãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ å¼Šç¤¾ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—ã‚‚ã‚¹ãƒãƒ³ã‚µãƒ¼ã¨ã—ã¦ã€ã‚»ãƒŸãƒŠãƒ¼ã®ç™ºè¡¨ã‚’1ã‚³ãƒžã¨ã€ãƒ–ãƒ¼ã‚¹ã‚’å‡ºã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ãã®éš›ã«ä½¿ç”¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰è³‡æ–™ã‚’å…¬é–‹ã—ã¾ã—ãŸã®ã§ã€ã©ã†ãžã”è¦§ä¸‹ã•ã„ã€‚ ãŠã‹ã’ã•ã¾ã§æº€å¸ã§ã—ãŸã€‚æ¥ã¦é ‚ã„ãŸæ–¹ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ è¬›å¸«ã®ä½ã€…æœ¨ã€ãªãœã‹ç™½è¡£ã§ã™ï¼ˆç†ç§‘ã®å…ˆç”Ÿã«æ†§ã‚Œã¦ã‚‹ã‚‰ã—ã„ï¼‰ã€‚ ãƒ–ãƒ¼ã‚¹ã¯ã“ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã™ã€‚ æ–°ä½œã‚²ãƒ¼ãƒ ã§ã‚ã‚‹ã€Œå‹‡è€…ã¨1000ã®é”çŽ‹ã€ã¨ã€Androidç”¨ã®ã‚¿ã‚¤ãƒ ã‚«ãƒ¼ãƒ‰ã‚¢ãƒ—ãƒªã§ã‚ã‚‹ã€Œã‹ã–ã—ã¦ã‚·ãƒ¥ã‚ãƒ¼ãƒ³ã€ã‚’å±•ç¤ºã—ã¾ã—ãŸã€‚ ãƒ„ã‚¤ãƒ¼ãƒˆ
proto_jp 2014/06/16
game

php

db

sql

mysql
ãƒªãƒ³ã‚¯
é€†å¼•ãSQLæ§‹æ–‡é›† - ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’å–å¾—ã™ã‚‹
ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’å–å¾—ã™ã‚‹ã«ã¯COUNTé–¢æ•°ã‚’ä½¿ç”¨ã—ã¾ã™ï¼Ž COUNT ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã®å–å¾— COUNTé–¢æ•°ã¯SELECTæ–‡ã«ã‚ˆã‚Šé¸æŠžã•ã‚ŒãŸãƒ¬ã‚³ãƒ¼ãƒ‰ã®ä»¶æ•°ã‚’è¿”ã—ã¾ã™ï¼Ž COUNTé–¢æ•°ã®å¼•æ•°ã«*(ã‚¢ã‚¹ã‚¿ãƒªã‚¹ã‚¯)ã‚’æŒ‡å®šã—ãŸå ´åˆã¯ã™ã¹ã¦ã®ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼Ž SELECT COUNT(*) FROM ãƒ†ãƒ¼ãƒ–ãƒ«å NULLã‚’å«ã¾ãªã„ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã®å–å¾— COUNTé–¢æ•°ã®å¼•æ•°ã«åˆ—åã‚’æŒ‡å®šã—ãŸå ´åˆã¯ï¼Œãã®åˆ—ã®å€¤ãŒNULLä»¥å¤–ã®ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’å–å¾—ã—ã¾ã™ï¼Ž SELECT COUNT(åˆ—å) FROM ãƒ†ãƒ¼ãƒ–ãƒ«å é‡è¤‡ã‚’å«ã¾ãªã„ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã®å–å¾— COUNTé–¢æ•°ã®å¼•æ•°ã§DISTINCTå¥ã‚’ä½¿ç”¨ã™ã‚‹ã¨ï¼Œé‡è¤‡ã—ãŸå€¤ã‚’1ã¤ã«ã¾ã¨ã‚ã¦ã‹ã‚‰ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼Ž SELECT COUNT(DISTINCT åˆ—å) FROM ãƒ†ãƒ¼ãƒ–ãƒ«å ã‚°ãƒ«ãƒ¼ãƒ—åŒ–ã—ã¦ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã‚’å–å¾— GROUP BYå¥ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§ï¼ŒåŒ
proto_jp 2012/03/28
mysql

sql
ãƒªãƒ³ã‚¯
MySQLã®INSERTæ–‡ï¼ˆæ–¹æ³•ã”ã¨ã®å‡¦ç†æ™‚é–“æ¯”è¼ƒï¼‰
å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã™ã‚‹å ´é¢ãŒã‚ã£ã¦ãªã‚“ã¨ã‹é«˜é€ŸåŒ–ã§ããªã„ã‹ã¨æ€ã£ã¦ã€ ä»¥ä¸‹ã®æ‰‹æ³•ã‚’æ¯”è¼ƒã—ã¦ã¿ãŸã€‚ 1ä»¶ãšã¤INSERTã™ã‚‹ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹ 1ã‚¯ã‚¨ãƒªã§ã¾ã¨ã‚ã¦INSERTã™ã‚‹ ãƒ†ã‚¹ãƒˆç’°å¢ƒã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ MySQL 5.1 ãƒ†ãƒ¼ãƒ–ãƒ«ã¯InnoDBã€AUTO_INCREMENTä»˜ãï¼ˆinnodb_autoinc_lock_mode=1ï¼‰ PHP 5.3.6 1000ä»¶ã€3000ä»¶ã€5000ä»¶ã€10000ä»¶ã¨ä»¶æ•°ã‚’å¢—ã‚„ã—ãªãŒã‚‰ãã‚Œãžã‚Œ5å›žãšã¤è©¦è¡Œã—ã¦å¹³å‡ã‚’å–ã£ã¦ã„ã‚‹ã€‚ ä½¿ç”¨ã—ãŸã‚³ãƒ¼ãƒ‰ã¯æœ€å¾Œã«ã€‚ çµæžœ æ‰‹æ³• 1,000ä»¶ 3,000ä»¶ 5,000ä»¶ 10,000ä»¶ 1ä»¶ãšã¤INSERTã™ã‚‹
proto_jp 2012/03/12
mysql

sql

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

mysql

php
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è³ªå• å†™çœŸå…±æœ‰ã‚µã‚¤ãƒˆã¨ã‹ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã¨ã‹ãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ã§ã¯ã€ï¼‘ã¤ã®å†™çœŸï¼ˆãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã€è¨˜äº‹ï¼‰ã”ã¨ã«ã‚¿ã‚°ã‚’ä»˜ã‘ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªâ€¦
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è³ªå• å†™çœŸå…±æœ‰ã‚µã‚¤ãƒˆã¨ã‹ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã¨ã‹ãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ã§ã¯ã€ï¼‘ã¤ã®å†™çœŸï¼ˆãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã€è¨˜äº‹ï¼‰ã”ã¨ã«ã‚¿ã‚°ã‚’ä»˜ã‘ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã‚ˆãã€‚ ã€Œäººæ°—ã®ã‚¿ã‚°ã€ã‚„ã€Œæ³¨ç›®ã®ã‚¿ã‚°ã€ã¿ãŸã„ãªæ„Ÿã˜ã§æ¤œç´¢ã‚‚ã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã‚ˆãã€‚ ã“ã®ã‚¿ã‚°ã¨ã„ã†ã®ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã©ã®ã‚ˆã†ãªå½¢ã§ãƒ‡ãƒ¼ã‚¿ã‚’æŒã£ã¦ã„ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ä¾‹ãˆã°å†™çœŸå…±æœ‰ã‚µã‚¤ãƒˆã‚’ä½œã‚‹ã¨ã—ã¦ã€ï¼‘ã¤ã®å†™çœŸã”ã¨ã«ä»¥ä¸‹ã®å†…å®¹ã‚’ç™»éŒ²ã—ã¦ã‚‚ã‚‰ã†ã“ã¨ã«ã—ã¾ã™ã€‚ ãƒ»å†™çœŸã‚¿ã‚¤ãƒˆãƒ« ãƒ»ãƒ•ã‚¡ã‚¤ãƒ«å ãƒ»æ’®å½±è€…ï¼ˆåˆ©ç”¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ï¼‰ ãƒ»ã‚¿ã‚°ï¼ˆè¤‡æ•°ã‚¿ã‚°ã®ç™»éŒ²å¯ï¼‰ ã“ã®å ´åˆã€ã©ã®ã‚ˆã†ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Œã°ã„ã„ã®ã§ã—ã‚‡ã†ï¼Ÿ ï¼ˆï¼‘ã¤ã®å†™çœŸã‚„è¨˜äº‹ã«å¯¾ã—ã¦è¤‡æ•°ã®ã‚¿ã‚°ãŒå…¥ã‚Œã‚‹ã“ã¨ãŒã§ãã¦ã€ãã‚Œã‚‰ã®ã‚¿ã‚°ã‚’ã‚ãƒ¼ã«ã—ã¦æ¤œç´¢ã‚„ã‚¿ã‚°ã®é›†è¨ˆã‚’ã©ã†ã‚„ã£ã¦ã„ã‚‹ã®ã‹ã‚’çŸ¥ã‚ŠãŸã„ã§ã™ã€‚ï¼‰
proto_jp 2010/11/07
websit

webservice

tag

database

php

sql

mysql

@php

db
ãƒªãƒ³ã‚¯
MySQL/PostgreSQLãªã©ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¦ç¿’ãªã‚‰DBOnline
MySQL ã¯ã€ä¸–ç•Œã§æœ€ã‚‚åºƒãåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã®ä¸€ã¤ã§ã™ã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦é–‹ç™ºã•ã‚Œã€ç¾åœ¨ã¯ã‚ªãƒ©ã‚¯ãƒ«ç¤¾ã«ã‚ˆã£ã¦ç®¡ç†ãƒ»æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ MySQL ã¯ã€ãã®é«˜ã„æ€§èƒ½ã€ä½¿ã„ã‚„ã™ã•ã€æŸ”è»Ÿæ€§ã‹ã‚‰ã€å€‹äººã® Web ã‚µã‚¤ãƒˆã‹ã‚‰ä¼æ¥ã®å¤§è¦æ¨¡ãªã‚·ã‚¹ãƒ†ãƒ ã¾ã§ã€è¦æ¨¡ã‚’å•ã‚ãšåºƒãåˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ MySQL ã®æœ€å¤§ã®ç‰¹å¾´ã¯ã€è»½é‡ã‹ã¤é«˜é€Ÿãªå‡¦ç†æ€§èƒ½ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã®èªã¿æ›¸ããŒé€Ÿãã€å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’åŠ¹çŽ‡çš„ã«ç®¡ç†ã§ãã‚‹ãŸã‚ã€Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã€eã‚³ãƒžãƒ¼ã‚¹ã‚µã‚¤ãƒˆãªã©ã€å¤šãã®ã‚·ã‚¹ãƒ†ãƒ ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æŽ¡ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ã¾ãŸ MySQL ã¯ SQL ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ã®è¿½åŠ ã€æ›´æ–°ã€å‰Šé™¤ã€æ¤œç´¢ãªã©ã‚’ç°¡å˜ã«è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚„ãƒ¦ãƒ¼ã‚¶ãƒ¼æ¨©é™ã®ç®¡ç†ã€ãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ãªã©ã‚‚å‚™ãˆã¦ãŠã‚Šã€å®‰å…¨æ€§ã¨å®‰å®šæ€§ã«ã‚‚å„ªã‚Œã¦ã„ã¾ã™ã€‚ My
proto_jp 2010/08/31
mysql

@php

sql
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 8 æœ€é©åŒ–
ã“ã®ç« ã§ã¯ã€MySQL ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æœ€é©åŒ–ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã€ä¾‹ã‚’ç¤ºã—ã¾ã™ã€‚ æœ€é©åŒ–ã«ã¯ã€ã„ãã¤ã‹ã®ãƒ¬ãƒ™ãƒ«ã§ã®æ§‹æˆã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ãŠã‚ˆã³ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®æ¸¬å®šãŒå«ã¾ã‚Œã¾ã™ã€‚ æ¥å‹™ã®å½¹å‰² (é–‹ç™ºè€…ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ã€ã¾ãŸã¯ä¸¡æ–¹ã®çµ„ã¿åˆã‚ã›) ã«å¿œã˜ã¦ã€å€‹ã€…ã® SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…¨ä½“ã€å˜ä¸€ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã€ã¾ãŸã¯è¤‡æ•°ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æŽ¥ç¶šã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã®ãƒ¬ãƒ™ãƒ«ã§æœ€é©åŒ–ã§ãã¾ã™ã€‚ ãƒ—ãƒã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’äº‹å‰ã«è¨ˆç”»ã™ã‚‹å ´åˆã‚„ã€ã¾ãŸã¯å•é¡Œã®ç™ºç”Ÿå¾Œã«ã€æ§‹æˆã‚„ã‚³ãƒ¼ãƒ‰ã®å•é¡Œã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚’è¡Œã†å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ CPU ã‚„ãƒ¡ãƒ¢ãƒªãƒ¼ã®ä½¿ç”¨ã‚’æœ€é©åŒ–ã™ã‚‹ã“ã¨ã§ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ãƒ¼ã‚’å‘ä¸Šã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½Žä¸‹ã•ã›ãšã€ã‚ˆã‚Šå¤šãã®è² è·ã‚’å‡¦ç†ã•ã›ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚
proto_jp 2010/08/29
mysql

sql
ãƒªãƒ³ã‚¯
MySQLã®EXPLAINã‚’å¾¹åº•è§£èª¬!!
ä»¥å‰ã€MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†æŠ•ç¨¿ã§ã€ŒEXPLAINã®è¦‹æ–¹ã«ã¤ã„ã¦ã¯ã„ãšã‚Œè§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€ã¨æ›¸ã„ã¦ã—ã¾ã£ãŸã®ã§ã€ä»Šæ—¥ã¯ãã®å…¬ç´„ï¼Ÿã‚’æžœãŸãã†ã¨æ€ã†ã€‚ MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§æœ€ã‚‚å¤§åˆ‡ãªã®ã¯ã€ã‚¯ã‚¨ãƒªã¨ã‚¹ã‚ãƒ¼ãƒžã®æœ€é©åŒ–ã§ã‚ã‚‹ã€‚ã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆã¯ä¸€åº¦æ±ºã‚ã¦ã—ã¾ã†ã¨ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹å…¨ã¦ã®ã‚¯ã‚¨ãƒªã«å½±éŸ¿ã—ã¦ã—ã¾ã†ãŸã‚ãªã‹ãªã‹å¤‰æ›´ã™ã‚‹ã“ã¨ã¯å‡ºæ¥ãªã„ãŒã€ã‚¯ã‚¨ãƒªã¯ãã®ã‚¯ã‚¨ãƒªã ã‘ã‚’æ›¸ãç›´ã›ã°è‰¯ã„ã®ã§å¤‰æ›´ã®æ•·å±…ã¯ä½Žã„ã€‚ãã—ã¦é…ã„ã‚¯ã‚¨ãƒªã‚’ãªãã™ã“ã¨ã¯ã€æ€§èƒ½ã‚’å¤§å¹…ã«å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®æœ€ã‚‚æœ‰åŠ¹ãªæ‰‹æ®µã§ã‚ã‚‹ã€‚å¾“ã£ã¦ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ€§èƒ½ã‚’å‘ä¸Šã•ã›ãŸã„ãªã‚‰ã€ã¾ãšæœ€åˆã«ã‚¯ã‚¨ãƒªã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’æ¤œè¨Žã™ã‚‹ã¹ããªã®ã§ã‚ã‚‹ã€‚ æœ€é©åŒ–ã™ã‚‹ã¹ãã‚¯ã‚¨ãƒªã¯ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚„ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§è¦‹ä»˜ã‘ã‚‰ã‚Œã‚‹ãŒã€ã§ã¯ãã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªãŒè¦‹ã¤ã‹ã£ãŸå ´åˆã«ã¯ã©ã®ã‚ˆã†ã«æœ€é©åŒ–ã™ã‚Œã°ã„ã„ã®ã‹ï¼Ÿãã®ãŸã‚ã«ã¯ã¾ãšç¾åœ¨ã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•
proto_jp 2010/08/29
mysql

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

mysql

database

db

@reference

reference

tips
ãƒªãƒ³ã‚¯
SQLã®åŸºç¤Ž ã€ŒSELECTã€æ–‡ã‚’è¦šãˆã‚ˆã†
æœ¬è¨˜äº‹ã®ãŠã‚‚ãªå†…å®¹ ã„ã‚ã„ã‚ã‚ã‚‹SQLã®è¦æ ¼ ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã—ã¦ã¿ã‚‹ SELECTæ–‡ã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ WHEREå¥ã®ä½¿ã„æ–¹ æ¡ä»¶ã®æŒ‡å®šæ–¹æ³• ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã‚‚ã€ä»Šã‚„ã€ã‚·ã‚¹ãƒ†ãƒ ã®æ§‹ç¯‰ã«ã¯ä¸å¯æ¬ ãªã‚‚ã®ã¨ãªã‚Šã¾ã—ãŸã€‚çš†ã•ã‚“ãŒç›®ã«ã—ã¦ã„ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚„ã€ç®¡ç†ã—ã¦ã„ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã§ã‚‚ã€RDBMSãŒä½¿ã‚ã‚Œã¦ã„ãªã„ã‚·ã‚¹ãƒ†ãƒ ã‚’æŽ¢ã™ã»ã†ãŒå¤§å¤‰ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚RDBMSã®æ™®åŠã«ã¨ã‚‚ãªã„ã€RDBMSã¸ã®ã‚¢ã‚¯ã‚»ã‚¹æ‰‹æ®µã§ã‚ã‚‹SQLã‚‚ã€æ—¥å¸¸çš„ã«ã‚ˆãè¦‹ã‹ã‘ã‚‹ã‚‚ã®ã¨ãªã‚Šã¾ã—ãŸã€‚ ã“ã®SQLå®Ÿè·µè¬›åº§ã§ã¯ã€SQLã®åŠ¹çŽ‡çš„ãªä½¿ã„æ–¹ã‚’ã‚¨ãƒƒã‚»ãƒ³ã‚¹ã«ã—ã¦ãŠä¼ãˆã—ã¦ã„ã“ã†ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚SQLã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã™ã‚‹ãŸã‚ã«éžå¸¸ã«ç°¡å˜ãªæ§‹æ–‡ã§æ§‹æˆã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ã¨ã“ã‚ãŒã€å®Ÿéš›ã«ä½¿ã„è¾¼ã‚“ã§ã„ãã¨ã€ä¸€è¦‹ç°¡å˜ã«å–å¾—ã§ãã‚‹ã‚ˆã†ã«è¦‹ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãŒå–å¾—ã§ããªã„å ´é¢ã«ã¶ã¡å½“ãŸã‚‹ã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ã¾ãŸé€†ã«
proto_jp 2010/08/25
@php

sql

mysql
ãƒªãƒ³ã‚¯
é€£è¼‰è¨˜äº‹ ã€Œä»Šã‹ã‚‰å§‹ã‚ã‚‹ MySQLå…¥é–€ã€
MySQLï¼‹Apacheï¼‹PHPã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã‚ˆã† é€£è¼‰ï¼šä»Šã‹ã‚‰å§‹ã‚ã‚‹ MySQLå…¥é–€ï¼ˆ1ï¼‰ã€€MySQLã‚’ä½¿ã£ã¦Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã‚’å§‹ã‚ã¦ã¿ã¾ã›ã‚“ã‹ï¼Ÿ ä»Šå›žã¯ã€é–‹ç™ºç’°å¢ƒã®æº–å‚™ã¨å‹•ä½œç¢ºèªã¾ã§ã‚’è§£èª¬ã—ã¾ã™
proto_jp 2010/08/16
sql

db

database

php

@php

programming
ãƒªãƒ³ã‚¯
XMLHttpRequest ã§ PHP ã« POST ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ›´æ–°ã—ã¦çµæžœã‚’JavaScriptã«è¿”ã™ - Vosegus Sakura
ä½œæˆæ—¥ : 2009å¹´09æœˆ13æ—¥ æ›´æ–°æ—¥ : 2010å¹´05æœˆ30æ—¥ Vosegus Labs åŸºæœ¬è¨è¨ˆ SQLã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆ XMLã®è¨è¨ˆ HTML JavaScript PHP åŸºæœ¬è¨è¨ˆ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ç¾åœ¨ã®æƒ…å ±ã‚’GETã—è¡¨ç¤º æ›´æ–°ã¯form elementã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ› å…¥åŠ›ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’å…ƒã«ã—ã¦XMLHttpRequestã§PHPã«POSTã™ã‚‹ PHPãŒãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‹ã‚‰SQLã‚’ä½œæˆã—ã¦é€ä¿¡ ã‚¯ã‚¨ãƒªãŒé€šã£ãŸã‚‰ã€æ›´æ–°ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æƒ…å ±ã‚’å–å¾— æ›´æ–°ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æƒ…å ±ã‚’XMLå½¢å¼ã§JavaScriptã¸æ¸¡ã™ JavaScriptã¯å—ã‘å–ã£ãŸãƒ‡ãƒ¼ã‚¿ã‚’HTMLã§è¡¨ç¤º SQLã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆ CREATE TABLE rex( rex_id SMALLINT UNSIGNED AUTO_INCREMENT, rex_year YEAR, rex_month VARCHAR(2), re
proto_jp 2010/08/12
@php

@javascript

javascript

php

database

sql

mysql
ãƒªãƒ³ã‚¯
1