[B! mysql] chlonoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

chlono id:chlono

mysqlã«é–¢ã™ã‚‹chlonoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (84)

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

Adminer â€“ é«˜é€Ÿå‹•ä½œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ãƒ„ãƒ¼ãƒ«ã‚’WordPressç®¡ç†ç”»é¢ä¸Šã§åˆ©ç”¨ã§ãã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ | ãƒã‚¿ãƒ¯ãƒ³
Adminerã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ãƒ„ãƒ¼ãƒ«ã®ã€ŒAdminerã€ã‚’WordPressç®¡ç†ç”»é¢ä¸Šã§åˆ©ç”¨ã§ãã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã™ã€‚phpMyAdmin ã«æ¯”ã¹ã€é«˜é€Ÿã«å‹•ä½œã™ã‚‹ã®ãŒã‚¦ãƒªã§ã™ã€‚ WordPressãŒåˆ©ç”¨ã—ã¦ã„ã‚‹ MySQL ã®ç®¡ç†ãƒ„ãƒ¼ãƒ«ã¨è¨€ãˆã°ã€phpMyAdmin ãŒä¸€ç•ªæœ‰åã§åˆ©ç”¨è€…ãŒå¤šã„ã§ã™ãŒã€ã—ã‹ã—ã€phpMyAdmin ã‚‚å®Œç’§ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚Adminerã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒ æœ¬ä½“ãŒ1ã¤ã®PHPãƒ•ã‚¡ã‚¤ãƒ«ã§å‹•ä½œã—ã€phpMyAdmin ã«æ¯”ã¹ã¦é«˜é€Ÿã«å‹•ä½œã—ã¾ã™ã€‚æ›´ã«æ©Ÿèƒ½ã‚‚é€²åŒ–ã—ã¦ã„ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ç”»é¢ãŒã‚µã‚¯ã‚µã‚¯è¡¨ç¤ºã•ã‚Œã€DBã®ç®¡ç†ä½œæ¥ãŒæ—ã‚Šã¾ã™ã€‚ ã¡ãªã¿ã«ã€ã“ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¯ã€åˆå¿ƒè€…å‘ã‘ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã®çŸ¥è˜ã¨ãƒŽã‚¦ãƒã‚¦ãŒã‚ã‚‹äººã®ã¿åˆ©ç”¨ã—ã¦ä¸‹ã•ã„ã€‚é–“é•ã£ã¦åˆ©ç”¨ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å£Šã—ã¦ã—ã¾ã†æã‚ŒãŒã‚ã‚Šã¾ã™ã€‚ ã¯ã˜ã‚ã« ã“ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ãŒå„ªã‚Œã¦ã„ã‚‹ç‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
chlono 2016/03/15
wordpress@ãƒ—ãƒ©ã‚°ã‚¤ãƒ³

mysql
ãƒªãƒ³ã‚¯
æ”¾ç½®ã•ã‚Œã¦ã„ãŸMySQLã®ãƒã‚°ã€ãƒã‚°å ±å‘Šã‹ã‚‰7å¹´ãŒçµŒã£ãŸã“ã¨ã‚’è¨˜å¿µã—ã¦ã‚±ãƒ¼ã‚ãŒè´ˆã‚‰ã‚Œã‚‹ | ã‚¹ãƒ©ãƒ‰ IT
2006å¹´6æœˆ29æ—¥ã«å ±å‘Šã•ã‚ŒãŸMySQLã®ãƒã‚°#20786ã¯ã€ä¿®æ£ã•ã‚Œãªã„ã¾ã¾æ”¾ç½®ã•ã‚Œã€ã¤ã„ã«7å¹´ãŒçµŒéŽã—ãŸã€‚ã“ã‚Œã‚’è¨˜å¿µã—ã¦ã€YouTubeã«MySQL Bug #20786 gets cakeãªã‚‹å‹•ç”»ãŒã‚¢ãƒƒãƒ—ã•ã‚ŒãŸã€‚ã€Œ7ã€ã®å½¢ã«ã‚ã†ããã‚’ç«‹ã¦ã‚‰ã‚ŒãŸã‚±ãƒ¼ã‚ãŒã€ã“ã®ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆã«æ§ã’ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ ãƒã‚°ã®å†…å®¹ã¯ã€mysqldumpã‚³ãƒžãƒ³ãƒ‰ã®ã€Œ--no-dataã€ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒæ„å›³ã—ãŸã¨ãŠã‚Šã«å‹•ä½œã—ã¦ã„ãªã„ã¨ã„ã†ã‚‚ã®ã€‚å‡ºåŠ›ã‚’sedã§æ•´å½¢ã™ã‚Œã°ã„ã„ã˜ã‚ƒã‚“ã¨ã„ã†ã“ã¨ã§ã€é‡è¦ã¨ã¯è¦‹ãªã•ã‚Œãšã«æ”¾ç½®ã•ã‚Œã¦ã„ãŸæ¨¡æ§˜ã€‚ã—ã‹ã‚‚ã€ã€Œä¿®æ£ã—ãŸã‚‰ã“ã‚Œã¾ã§ã¨ã®äº’æ›æ€§ãŒãªããªã‚‹ã€ã¨ã„ã†è©±ã¾ã§æŒ™ãŒã£ã¦ã„ã‚‹ã€‚ä¸å…·åˆã‚‚æ”¾ç½®ã™ã‚Œã°ä»•æ§˜ã«ãªã£ã¦ã—ã¾ã†ã¨ã„ã†ã“ã¨ã‹ã€‚
chlono 2013/07/02
ã€Œæ¡ƒæ —3å¹´ã€ãƒã‚°7å¹´ã€‚ãƒã‚°ã‚‚è‚²ã¦ã‚Šã‚ƒä»•æ§˜ã«æ˜‡æ ¼ã€‚ã€ï½—ï½—ï½—

mysql
ãƒªãƒ³ã‚¯
Cè¨€èªžã‚ˆã‚Šé«˜é€ŸãªJavaScriptã«ã‚ˆã‚‹ãƒã‚¤ãƒŠãƒªæ“ä½œãŒè©±é¡Œ
JavaScriptãªã©ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã¯å‹•ä½œãŒé…ãã€æœ€é©ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å¾—ã‚‹ã«ã¯C/C++ã§å®Ÿè£…ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã¨ã„ã†å¸¸è˜ã«æŒ‘ã‚“ã å…ˆé€²çš„ãªè¬›æ¼”ãŒè©±é¡Œã«ãªã£ã¦ã„ã¾ã™ã€‚ã“ã®è©±é¡Œã®ç™ºç«¯ã¯2012å¹´10æœˆ7æ—¥ã‹ã‚‰10æœˆ8æ—¥ã¾ã§ãƒ™ãƒ«ãƒªãƒ³ã§é–‹å‚¬ã•ã‚ŒãŸJSConf.euã§Felix GeisendÃ¶rferæ°ãŒè¡Œã£ãŸè¬›æ¼”ã§ã™ã€‚ å½¼ã®è¬›æ¼”ã®é¡Œæã¯node.jsã‹ã‚‰MySQLã«æŽ¥ç¶šã™ã‚‹ç‚ºã®ãƒã‚¤ãƒ³ãƒ‡ã‚£ãƒ³ã‚°ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ç€ç›®ã—ã¦ã„ã¾ã™ã€‚2010å¹´å½“æ™‚ã€node.jsã«ã¯MySQLã®ãƒã‚¤ãƒ³ãƒ‡ã‚£ãƒ³ã‚°ãŒå˜åœ¨ã—ã¦ãŠã‚‰ãšã€å¢—äº•ã•ã‚“ä½œã®node-mysqlãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒé–‹ç™ºä¸ã®çŠ¶æ…‹ã§ã—ãŸã€‚ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯JavaScriptã§ãƒã‚¤ãƒŠãƒªã‚’è§£æžã—ã¦ãŠã‚ŠJavaScriptã®ã¿ã§é–‹ç™ºã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ã“ã®çŠ¶æ³ã‚’å—ã‘ã¦Felixæ°ãŒæ–°ãŸã«node-mysqlãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’æ–°è¦ã«é–‹ç™ºã‚’å§‹ã‚ã¾ã—ãŸã€‚ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚‚JavaScri
chlono 2012/10/10
*ã“ã‚Œã¯ã™ã”ã„

javascript

mysql

node.js
ãƒªãƒ³ã‚¯
1å°ã‹ã‚‰500å°ã¾ã§ã®MySQLé‹ç”¨ MySQL Beginners
5. On-Demand WorkforceWorkforce On-Demand On-Demand Workforce On-Demand Workforce On-Demand Workforce Our Service (livedoor) Amazon MechanicalAmazon Mechanical Turk Mechanical Turk Amazon Mechanical Turk Mechanical Turk Turk Amazon Amazon t/ Workers Workers Requester Requester On-Demand WorkforceWorkforce On-Demand On-Demand Workforce On-Demand Workforce On-Demand Workforce Amazon MechanicalAmazon
chlono 2012/05/30
mysql
ãƒªãƒ³ã‚¯
Sequel Pro ï½° SSHçµŒç”±ã§ã‚‚æŽ¥ç¶šã§ãã‚‹GUIã®MySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
ã‚‚ã†2æœˆå¾ŒåŠãªã‚“ã§ã™ãŒã€5å¹´ä»¥ä¸Šä½¿ã£ã¦ããŸã‚³ãƒ¼ãƒˆãŒã„ã‚ã„ã‚ã»ã¤ã‚ŒãŸã‚Šãƒœã‚¿ãƒ³ã¨ã‚ŒãŸã‚Šã—ã¦ã ã¾ã—ã ã¾ã—ä½¿ã£ã¦ã‚‹çŠ¶æ…‹ã ã£ãŸã®ã§ã€è²·ã„ç›´ã—ãŸtanakaã§ã™ã€‚ã‚‚ã†ã‚·ãƒ¼ã‚ºãƒ³ã‚ªãƒ•ã«ãªã£ã¦ã‹ã‚‰æ¥å¹´ç”¨ã«å®‰ããªã£ãŸã‚‚ã®ã‚’è²·ãˆã°è‰¯ã„ã‚“ã˜ã‚ƒãªã„ã‹ã€ã¨ã‚‚ä¸€çž¬æ€ã„ã¾ã—ãŸãŒã€‚ ä»Šæ—¥ã¯ã‚ã‚‹ã‚µã‚¤ãƒˆã§çŸ¥ã£ãŸã€Macç”¨ã®MySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ Sequel Pro ãŒéžå¸¸ã«ä¾¿åˆ©ãªã®ã§ã€ç´¹ä»‹ã—ã¾ã™ã€‚ Sequel Proã®å…¥æ‰‹ã¨ç‰¹å¾´ æœ¬å®¶ã‚µã‚¤ãƒˆã‹ã‚‰dmgãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãã ã•ã„ã€‚ Sequel Pro ã„ã¾ã¾ã§ä½¿ã£ãŸã“ã¨ã®ã‚ã‚‹ãƒ„ãƒ¼ãƒ«(phpMyAdmin, IDEä»˜å±žã®MySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ)ã¨Sequel Proã‚’æ¯”ã¹ãŸã¨ãã®é•ã„ã€é•·æ‰€ã¯ SSHçµŒç”±ã§ãƒªãƒ¢ãƒ¼ãƒˆãƒ›ã‚¹ãƒˆã®MySQLã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šã§ãã‚‹ SQLå…¥åŠ›æ™‚ã®ã‚ªãƒ¼ãƒˆã‚³ãƒ³ãƒ—ãƒªãƒ¼ãƒˆ(ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åè£œå®Œæ©Ÿèƒ½)ãŒå¼·åŠ› ã®äºŒç‚¹ã§ã™ã€‚
chlono 2012/05/28
mysql

mac
ãƒªãƒ³ã‚¯
[MySQL] CSV ã‚’ä½¿ã£ã¦ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ»ã‚¤ãƒ³ãƒãƒ¼ãƒˆ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
ãƒ¯ãƒ¼ãƒ«ãƒ‰ã‚«ãƒƒãƒ—æ¥½ã—ã„ã€œã€œï¼ã“ã‚“ã«ã¡ã‚ nakamura ã§ã™ã€‚ ä»Šæ—¥ã¯ãƒ€ãƒ³ãƒ—ãƒ»ãƒªã‚¹ãƒˆã‚¢ã§ã¯ãªãã€CSV ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ã¦ MySQL ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ»ã‚¤ãƒ³ãƒãƒ¼ãƒˆã‚’ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚çŠ¶æ³ã«ã‚ˆã£ã¦ã¯ã¨ã¦ã‚‚æœ‰ç”¨ãªæ–¹æ³•ãªã®ã§è¦šãˆã¦ãŠãã¨ã¡ã‚‡ã£ã¨ä¾¿åˆ©ã§ã™ã‚ˆï¼ ã©ã‚“ãªæ™‚ã«ä¾¿åˆ©ãªã®ï¼Ÿ ä¾‹ãˆã°ãƒ‡ãƒ¼ã‚¿ã®æ•´å½¢ã‚’ã—ãŸä¸Šã§é•ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒªã‚¹ãƒˆã‚¢ã—ãŸã‚Šã€WHERE å¥ã§çµžã‚Šè¾¼ã‚“ã ãƒ‡ãƒ¼ã‚¿ã ã‘ã‚’ãƒªã‚¹ãƒˆã‚¢ã—ãŸã‚Šã€ç•°ãªã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³é–“ã§ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ãŸãƒªã‚¹ãƒˆã‚¢ãŒã©ã†ã«ã‚‚ã†ã¾ãã„ã‹ãªã„å ´åˆç‰ã« CSV ã§ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ»ã‚¤ãƒ³ãƒãƒ¼ãƒˆã¯æœ‰ç”¨ã§ã™ã€‚ SQL ã‚³ãƒžãƒ³ãƒ‰ä¾‹ ãã‚Œã§ã¯å®Ÿéš›ã«ã‚³ãƒžãƒ³ãƒ‰ä¾‹ã‚’è¦‹ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ã¨ã‚Šã‚ãˆãšä¸€èˆ¬çš„ãªã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ SELECT * FROM users ORDER BY id INTO OUTFILE "/tmp/users.csv" -- å‡ºåŠ›å…ˆã®ãƒ•ã‚¡ã‚¤ãƒ«å FIELDS TERM
chlono 2012/05/28
mysql
ãƒªãƒ³ã‚¯
ãªãœMySQLã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã¯é…ã„ã®ã‹ã€‚
ã‚ˆãMySQLã¯ã‚µãƒ–ã‚¯ã‚¨ãƒªãŒå¼±ã„ã¨è¨€ã‚ã‚Œã‚‹ãŒã€ã“ã‚Œã¯æœ¬å½“ã ã‚ã†ã‹ï¼ŸåŠåˆ†ã¯æœ¬å½“ã§åŠåˆ†ã¯å˜˜ã§ã‚ã‚‹ã€‚MySQLã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã ã£ã¦ãªã‚“ã§ã‚‚ã‹ã‚“ã§ã‚‚é…ã„ã‚ã‘ã§ã¯ãªã„ã€‚è½ã¨ã—ç©´ã‚’ã—ã£ã‹ã‚Šé¿ã‘ã€ä½¿ã„ã©ã“ã‚ã‚’é–“é•ãˆãªã‘ã‚Œã°ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚‚é«˜é€Ÿã«å®Ÿè¡Œã§ãã‚‹ã®ã§ã‚ã‚‹ã€‚ä»Šæ—¥ã¯MySQLãŒã©ã‚“ãªé¢¨ã«ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã€ã©ã®ã‚ˆã†ãªå ´åˆã«é…ã„ã®ã‹ã¨ã„ã†ã“ã¨ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã€‚ EXPLAINã§å®Ÿè¡Œè¨ˆç”»ã‚’èª¿ã¹ãŸéš›ã«ã€select_typeã«ã¯ã‚¯ã‚¨ãƒªã®ç¨®é¡žãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ã ãŒã€ä»£è¡¨çš„ãªã‚µãƒ–ã‚¯ã‚¨ãƒªã«ã¯æ¬¡ã®3ã¤ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚‹ã€‚ SUBQUERY DEPENDENT SUBQUERY DERIVED çµè«–ã‹ã‚‰è¨€ãŠã†ã€‚é…ã„ã®ã¯2ç•ªç›®ã€DEPENDENT SUBQUERYã§ã‚ã‚‹ã€‚DEPENDENT SUBQUERYã¨ã¯ã„ã‚ã‚†ã‚‹ç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ç›¸å½“ã™ã‚‹ã‚‚ã®ã§ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ãŠã„ã¦å¤–éƒ¨ã‚¯ã‚¨ãƒªã®ã‚«ãƒ©ãƒ ã‚’å‚ç…§ã—ã¦ã„ã‚‹ã‚µãƒ–ã‚¯ã‚¨ãƒªã®ã“ã¨ã§ã‚ã‚‹ã€‚ãã—
chlono 2012/04/09
ã€ŒSelect tables optimized awayï¼ˆä¸ç•¥ï¼‰ã“ã‚ŒãŒç¾ã‚ŒãŸã‚‰ã‚µãƒ–ã‚¯ã‚¨ãƒªã¯æœ€å¼·ã«æœ€é©åŒ–ã•ã‚Œã¾ãã£ã¦ã‚‹ã®ã§ã€ã“ã‚Œä»¥ä¸Šæ‰‹ã®å…¥ã‚Œã‚ˆã†ãŒãªã„ã¨ã„ã†ã“ã¨ã§ã‚ã‚‹ã€

mysql
ãƒªãƒ³ã‚¯
Loading...
chlono 2012/03/09
mysql
ãƒªãƒ³ã‚¯
MySQL5.5.3-m3ã®DATETIMEåž‹ã®ãƒã‚°ã€‚ã‚ã¨MySQLã® DATETIMEåž‹ã¯æœ¬å½“ã«é…ã„ã®ã‹æ¤œè¨¼ã—ã¦ã¿ãŸ - 2010-04-30 - å°é‡Žãƒžãƒˆãƒšã®æ¥å‹™æ—¥èªŒ(ã‚¢ãƒ‹ãƒ¡åˆ¶ä½œã—ã¦ãªã„ç¯‡)
ãƒã‚°ã®è©± è¿‘ã€…ãµãã¼ã£ãŸãƒ¼DBã®InnoDBåŒ–ã‚’ä¼ã¦ã¦ã„ã‚‹ã®ã§ã€ãã‚Œã«ä¼´ã„MySQL5.0.67(Tritonn)ã‹ã‚‰ã€å…ˆæ—¥ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã°ã‹ã‚Šã®MySQL5.5.3-m3ã«ä¹—ã‚Šæ›ãˆã¦ã¿ãŸã€‚RC(ãƒªãƒªãƒ¼ã‚¹å€™è£œ)ç‰ˆã¨ã„ã†ã“ã¨ã§ã€GAç‰ˆã¨ã»ã¼å¤‰ã‚ã‚‰ãªã„å“è³ªã¨èžã„ãŸã®ã§ã€å‰²ã¨è»½ã„æ°—æŒã¡ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚“ã ã‘ã©ã€ã„ããªã‚Šãƒã‚°ã«ãƒãƒžã£ãŸã€‚ ãƒã‚°ã¨ã¯ã€DATETIME, TIMESTAMP, DATE, TIMEåž‹ã¨æ–‡å—åˆ—å®šæ•°ã¨ã®çµåˆã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œãªã„ã€ã¨ã„ã†ã‚‚ã®ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ãªã€date(DATEåž‹)ã®çµåˆã—ã‹ã—ã¦ã„ãªã„ã‚¯ã‚¨ãƒªã§ã‚‚ã€dateã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œãšæ˜‡é †ãƒ•ãƒ«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã•ã‚Œã€20ç§’ãã‚‰ã„æŽ›ã‹ã£ãŸã€‚ select date from STATUS force index(date) where date='2010-01-19' limit 10; ã“ã®ç¾è±¡ã¯ã€5.5.3,5
chlono 2012/03/09
mysql
ãƒªãƒ³ã‚¯
KLab
ã”æŒ‡å®šã®ãƒšãƒ¼ã‚¸ãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“ã§ã—ãŸ URLã®å¤‰æ›´ã€ã‚‚ã—ãã¯ãƒšãƒ¼ã‚¸ãŒå‰Šé™¤ã•ã‚ŒãŸå¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ãŠæ‰‹æ•°ã§ã™ãŒã€ä»¥ä¸‹ã®ãƒªãƒ³ã‚¯ã‹ã‚‰ç›®çš„ã®ãƒšãƒ¼ã‚¸ã‚’ãŠæŽ¢ã—ãã ã•ã„ã€‚
chlono 2012/01/26
FEDERATED

mysql
ãƒªãƒ³ã‚¯
Using filesort
åŽ»å¹´ã‚½ãƒ¼ãƒˆã«é–¢ã™ã‚‹è¨˜äº‹ã‚’æ›¸ã„ãŸãŒã€ä»Šæ—¥ã¯ãã®ç¶šãã§ã‚ã‚‹ã€‚ MySQLã§EXPLAIN SELECT...ã‚’å®Ÿè¡Œã™ã‚‹ã¨Extraãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã§ã‚ˆãè¦‹ã‹ã‘ã‚‹ã€ŒUsing filesortã€ã¨ã„ã†æ–‡å—åˆ—ã€‚Filesortã£ã¦ä¸€ä½“ãªã‚“ã ã‚ã†ï¼Ÿã¨æ€ã£ãŸã“ã¨ã¯ãªã„ã ã‚ã†ã‹ã€‚å˜åˆ€ç›´å…¥ã«è¨€ã£ã¦Filesortã®æ£ä½“ã¯ã‚¯ã‚¤ãƒƒã‚¯ã‚½ãƒ¼ãƒˆã§ã‚ã‚‹ã€‚ ã‚¯ã‚¨ãƒªã«ORDER BYãŒå«ã¾ã‚Œã‚‹å ´åˆã€MySQLã¯ã‚ã‚‹ç¨‹åº¦ã®å¤§ãã•ã¾ã§ã¯å…¨ã¦ãƒ¡ãƒ¢ãƒªå†…ã§ã‚¯ã‚¤ãƒƒã‚¯ã‚½ãƒ¼ãƒˆã‚’å‡¦ç†ã™ã‚‹ã€‚ã‚ã‚‹ç¨‹åº¦ã®å¤§ãã•ã¨ã¯sort_buffer_sizeã§ã‚ã‚Šã€ã“ã‚Œã¯ã‚»ãƒƒã‚·ãƒ§ãƒ³ã”ã¨ã«å¤‰æ›´å¯èƒ½ã§ã‚ã‚‹ã€‚ã‚½ãƒ¼ãƒˆã«å¿…è¦ãªãƒ¡ãƒ¢ãƒªãŒsort_buffer_sizeã‚ˆã‚Šå¤§ãããªã‚‹ã¨ã€ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆãƒ†ãƒ³ãƒãƒ©ãƒªãƒ†ãƒ¼ãƒ–ãƒ«ã§ã¯ãªã„ï¼‰ãŒä½œæˆã•ã‚Œã€ãƒ¡ãƒ¢ãƒªã¨ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½µç”¨ã—ã¦ã‚¯ã‚¤ãƒƒã‚¯ã‚½ãƒ¼ãƒˆãŒå®Ÿè¡Œã•ã‚Œã‚‹ã€‚ Filesortã¯å…¨ã¦ã®ã‚½ãƒ¼ãƒˆå‡¦ç†ã«ãŠã„ã¦å®Ÿè¡Œã•ã‚Œã‚‹ã‚ã‘ã§ã¯ãªã„ã€‚å‰å›žã®è¨˜äº‹
chlono 2012/01/26
ã‚µãƒ–ã‚¯ã‚¨ãƒªã—ãŸæ–¹ãŒæ—©ã„ã“ã¨ã‚‚ã‚ã‚‹ã®ã‹

mysql
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸé«˜é€ŸåŒ–ã«ã¤ã„ã¦(ORDERD BYã«ã‚¤ãƒ³ãƒ‡ã‚¯ã‚¹ãŒä½¿ã‚ã‚Œãªã„ä¾‹) - LukeSilviaâ€™s diary
ä»Šå›žã¯ã€MySQLã®é«˜é€ŸåŒ–ã®ãƒ¡ãƒ¢ - @luke_silvia.diaryã®æ–¹æ³•ã«å¾“ã£ã¦ã‚¯ã‚¨ãƒªã®é«˜é€ŸåŒ–ã‚’ã—ãŸéš›ã«ã€MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ãŸã“ã¨ã‚’æ›¸ã„ã¦ãŠãã¾ã™ã€‚ é«˜é€ŸåŒ–å¯¾è±¡ã®ã‚¯ã‚¨ãƒª ä»Šå›žé«˜é€ŸåŒ–ã—ãŸã„ã‚¯ã‚¨ãƒªã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã€‚ SELECT users.*, students.school, workers.school FROM users LEFT JOIN students ON users.id = students.user_id LEFT JOIN workers ON users.id = workers.user_id WHERE (users.status= 1 AND ((kind = 0 AND students.school = 'test') OR (kind = 1 AND workers.school = 'test'))) ORDER BY
chlono 2012/01/26
mysql
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 12.7 æ—¥ä»˜ãŠã‚ˆã³æ™‚é–“é–¢æ•°
æ¬¡ã«ã€æ—¥ä»˜é–¢æ•°ã®ä½¿ç”¨ä¾‹ã‚’ç¤ºã—ã¾ã™ã€‚ æ¬¡ã®ã‚¯ã‚¨ãƒªãƒ¼ã¯ã€éŽåŽ» 30 æ—¥ä»¥å†…ã® date_col å€¤ã‚’å«ã‚€ã™ã¹ã¦ã®è¡Œã‚’é¸æŠžã—ã¾ã™ã€‚ mysql> SELECT something FROM tbl_name -> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col; ã“ã®ã‚¯ã‚¨ãƒªãƒ¼ã¯ã€å°†æ¥ã®æ—¥ä»˜ã‚’æŒã¤è¡Œã‚‚é¸æŠžã—ã¾ã™ã€‚ é€šå¸¸ã€æ—¥ä»˜å€¤ãŒè¦æ±‚ã•ã‚Œã‚‹é–¢æ•°ã§ã¯ã€æ—¥ä»˜æ™‚é–“å€¤ãŒå—ã‘å…¥ã‚Œã‚‰ã‚Œã€æ™‚é–“ã®éƒ¨åˆ†ã¯ç„¡è¦–ã•ã‚Œã¾ã™ã€‚ é€šå¸¸ã€æ™‚é–“å€¤ãŒè¦æ±‚ã•ã‚Œã‚‹é–¢æ•°ã§ã¯ã€æ—¥ä»˜æ™‚é–“å€¤ãŒå—ã‘å…¥ã‚Œã‚‰ã‚Œã€æ—¥ä»˜ã®éƒ¨åˆ†ã¯ç„¡è¦–ã•ã‚Œã¾ã™ã€‚ ç¾åœ¨ã®æ—¥ä»˜ã¾ãŸã¯æ™‚é–“ã‚’ãã‚Œãžã‚Œè¿”ã™é–¢æ•°ã¯ã€ã‚¯ã‚¨ãƒªãƒ¼å®Ÿè¡Œã®é–‹å§‹æ™‚ã«ã‚¯ã‚¨ãƒªãƒ¼ã”ã¨ã« 1 å›žã ã‘è©•ä¾¡ã•ã‚Œã¾ã™ã€‚ ã¤ã¾ã‚Šã€NOW() ãªã©ã®é–¢æ•°ãŒå˜ä¸€ã‚¯ã‚¨ãƒªãƒ¼å†…ã§è¤‡æ•°å›žå‚ç…§ã•ã‚Œã¦ã‚‚ã€å¸¸ã«åŒã˜çµæžœãŒç”Ÿæˆã•ã‚Œã¾ã™ã€‚ (è¨è¨ˆä¸Šã€å˜ä¸€ã‚¯ã‚¨ãƒªãƒ¼ã«ã¯ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚°ãƒ©ãƒ (ã‚¹ãƒˆ
chlono 2011/12/15
addtimeã¹ã‚“ã‚Š

mysql
ãƒªãƒ³ã‚¯
ã‚µã‚¤ã‚ªãƒ³ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚ºæ ªå¼ä¼šç¤¾ â€” æ²–ç¸„çœŒã§ã®ã‚³ãƒ¼ãƒ«ã‚»ãƒ³ã‚¿ãƒ¼ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º Â» ç¬¬21å›ž MySQLã¨PHPã«ãŠã‘ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã«ã¤ã„ã¦
ã‚„æ£è¦è¡¨ç¾ã‚’ä½¿ã£ãŸé–¢æ•°ç‰ã‚’ä½¿ç”¨ã™ã‚‹ã¨ä¾¿åˆ©ã§ã™ã€‚ã§ã¯å°‘ã—ä½¿ã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ <?php $num = 28; $str = "28"; $float = 28.0; $mb_str = "SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³"; print "check1:"; if (is_numeric($num)) { print "true n"; } else { print "false n"; } print "check2:"; if (is_numeric($str)) { print "true n"; } else { print "false n"; } print "check3:"; if (is_int($num)) { print "true n"; } else { print "false n"; } print
chlono 2011/12/14
php

mysql

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
ä»Šå¤œåˆ†ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç– â€• ï¼ IT
ã€é–¢é€£è¨˜äº‹ã€‘ æœ¬å†…å®¹ã«ã¤ã„ã¦ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆè¨˜äº‹ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ã‚ã‚ã›ã¦ã”ç¢ºèªãã ã•ã„ï¼ˆç·¨é›†éƒ¨ï¼‰ Security&Trustã‚¦ã‚©ãƒƒãƒï¼ˆ60ï¼‰ ä»Šå¤œã“ãã‚ã‹ã‚‹å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ ï½ž é«˜æœ¨æµ©å…‰æ°ã«èžã„ã¦ã¿ãŸ http://www.atmarkit.co.jp/fsecurity/column/ueno/60.html Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾ã™ã‚‹æ”»æ’ƒæ‰‹æ³•ã®1ã¤ã§ã‚ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®å˜åœ¨ã¯ã€ã‹ãªã‚ŠåºƒãçŸ¥ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ã—ã‹ã—ã€ãã®å¯¾ç–ã¯ã¾ã æœ¬å½“ã«ç†è§£ã•ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ€ãˆã‚‹ã€‚ãƒ•ã‚©ãƒ¼ãƒ ã‹ã‚‰æ¸¡ã•ã‚ŒãŸå€¤ã®ç‰¹æ®Šæ–‡å—ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãŸã‚Šã€PHPã®magic_quotes_gpcã¨ã„ã£ãŸè‡ªå‹•ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ©Ÿèƒ½ã‚’ã‚ªãƒ³ã«ã™ã‚‹ã ã‘ã§å¯¾ç–ã—ãŸã¤ã‚‚ã‚Šã«ãªã£ã¦ã„ãªã„ã ã‚ã†ã‹ã€‚ åŸºæœ¬ã¯ã‚‚ã¡ã‚ã‚“ã€ã‚»ã‚«ãƒ³ãƒ‰ã‚ªãƒ¼ãƒ€ãƒ¼SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚„ãƒžãƒ«ãƒãƒã‚¤ãƒˆæ–‡å—ã‚’åˆ©ç”¨ã—ãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ”»æ’ƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚„ã€ãã®å¯¾
chlono 2011/12/14
ãµã‚‹ã¼ã£ã“ã«ã•ã‚Œã¦ã¾ã™ãŒ http://takagi-hiromitsu.jp/diary/20061104.html

php

mysql

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
PHPé€†å¼•ããƒ¬ã‚·ãƒ”ã¯æ¦‚ãè‰¯ã„ãŒã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«é–¢ã—ã¦ã¯æ®‹å¿µãªã“ã¨ã« - ockeghem's blog
404æ–¹é¢ã§ã‚‚çµ¶è³›ã•ã‚Œã¦ã„ãŸPHPé€†å¼•ããƒ¬ã‚·ãƒ”ã‚’è³¼å…¥ã—ãŸã€‚æœ¬æ›¸ã¯ã¨ã¦ã‚‚ä¸å¯§ãªä»•äº‹ã§ç´ æ™´ã‚‰ã—ã„ã¨æ€ã£ãŸãŒã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã«é–¢ã—ã¦ã¯è‹¥å¹²æ®‹å¿µãªæ€ã„ã‚’ã—ãŸã®ã§ã€ãã‚Œã‚’æ›¸ã“ã†ã¨æ€ã†ã€‚ ç›®æ¬¡ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚ ç¬¬1ç« ã€€æº–å‚™ ç¬¬2ç« ã€€PHPã®åŸºæœ¬æ§‹æ–‡ ç¬¬3ç« ã€€PHPã®åŸºæœ¬ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ ç¬¬4ç« ã€€ãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒª ç¬¬5ç« ã€€PEARã¨Smarty ç¬¬6ç« ã€€Webãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° ç¬¬7ç« ã€€ã‚¯ãƒ©ã‚¹ã¨ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ ç¬¬8ç« ã€€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ 8.1ã€€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ã®åŸºæœ¬ 8.2ã€€PHPã®è¨å®š 8.3ã€€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç– ç¬¬9ç« ã€€ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚° ç¬¬10ç« ã€€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç·¨ PHPé€†å¼•ããƒ¬ã‚·ãƒ” ã‚ªãƒ•ã‚£ã‚·ãƒ£ãƒ«ã‚µãƒãƒ¼ãƒˆ æœ¬æ›¸ã¯ã€ã‚¿ã‚¤ãƒˆãƒ«ã®ç¤ºã™ã‚ˆã†ã«ã€ã‚³ãƒ¬ã‚³ãƒ¬ã—ãŸã„ã¨ã„ã†ç›®çš„ã”ã¨ã«PHPã§ã®æ›¸ãæ–¹ãŒæ›¸ã‹ã‚Œã¦ã„ã‚‹ã€‚ã‚ˆãã‚ã‚‹é€†å¼•ãè¾žå…¸ã‚¿ã‚¤ãƒ—ã®æœ¬ã ãŒã€é¡žæ›¸ã«æ¯”ã¹ã¦ä¸å¯§ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹å°è±¡ã‚’å—ã‘ãŸã€‚ç§ãŒæ„Ÿå¿ƒã—ãŸã®ã¯ã€PH
chlono 2011/12/14
php

mysql

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
layer8.sh
This domain may be for sale!
chlono 2011/12/07
mysql
ãƒªãƒ³ã‚¯
ãƒ“ãƒƒãƒˆæ¼”ç®—ã‚’ä½¿ã£ã¦ã‚¹ãƒžãƒ¼ãƒˆãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ï¼ˆMySQL&PHPï¼‰ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®IDåˆ—ã«ã¡ã‚‡ã£ã¨ã—ãŸæ„å‘³ã‚’æŒãŸã›ã€ãƒ“ãƒƒãƒˆæ¼”ç®—ã‚’ä½¿ã£ã¦ã™ã£ãã‚Šã¨æ¡ä»¶æŠ½å‡ºã‚’ã™ã‚‹å°æŠ€ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ä¾‹é¡Œã¨ã—ã¦ã€æ¬¡ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è€ƒãˆã¾ã™ã€‚ ãƒ¦ãƒ¼ã‚¶æƒ…å ±ã¨ã‚µãƒ¼ãƒ“ã‚¹æƒ…å ±ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚Šã€ãƒ¦ãƒ¼ã‚¶æƒ…å ±ã«ã¯å„ã€…ã®åˆ©ç”¨ã‚µãƒ¼ãƒ“ã‚¹æƒ…å ±ãŒç™»éŒ²ã•ã‚Œã¦ã„ã‚‹ã€‚ ã‚µãƒ¼ãƒ“ã‚¹ã¯3ã‚¿ã‚¤ãƒ—ï¼ˆAã€Bã€Cï¼‰Ã—3æœŸé–“ã®è¨ˆ9ç¨®é¡žãŒå˜åœ¨ã™ã‚‹ã€‚ ä¸€èˆ¬çš„ãªè¨è¨ˆæ–¹æ³• é€šå¸¸ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®IDåˆ—ã‚’æ•´æ•°åž‹ã«ã—ã€1ã‹ã‚‰é †ã«ä¸€æ„ã®IDç•ªå·ã‚’æŒ¯ã£ã¦ã„ãã‚ˆã†ã«ã™ã‚‹ã®ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®åŸºæœ¬ã§ã‚ã‚Šã€ã‚‚ã£ã¨ã‚‚ç°¡å˜ãªæ–¹æ³•ã«ãªã‚Šã¾ã™ã€‚ ãƒ¦ãƒ¼ã‚¶æƒ…å ±ãƒ†ãƒ¼ãƒ–ãƒ« users +----+-----------------------+ | id | name | service_id | +----+-----------------------+ | 1 | sakai | 1 | | 2 | kimoto | 2 | | 3 | ish
chlono 2011/11/01
php

mysql
ãƒªãƒ³ã‚¯
2php : MySQLã®ãƒ‡ãƒ¼ã‚¿ã®è¡¨ç¤º(SHOW)
SHOW DATABASES SHOW DATABASESæ–‡ã¯ã™ã§ã«å˜åœ¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€è¦§ã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | tamayaDB | | test | +----------+ 3 rows in set (0.00 sec) SHOW TABLES SHOW TABLESæ–‡ã¯ã™ã§ã«å˜åœ¨ã—ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ã“ã®ã‚³ãƒžãƒ³ãƒ‰ã¯USEæ–‡ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é¸æŠžã—ã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é¸æŠžã—ã¦ã„ãªã„å ´åˆã¯ã€ã€ŽSHOW TABLES FROM [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å]ã€ã®æ§˜ã«åˆ©ç”¨ã—ã¾ã™ã€‚ mysql> SHOW TABLES; +--------------------+ | Tables_in_tamayaDB | +-------
chlono 2011/10/31
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã‚°ãƒ¼ã‚°ãƒ«ã€ã€ŒGoogle Cloud SQLã€ã‚’ç™ºè¡¨ã€‚Google App Engineã«MySQLã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«DBã‚’è¿½åŠ
ã‚°ãƒ¼ã‚°ãƒ«ã¯åŒç¤¾ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ©Ÿèƒ½ã‚’åˆ©ç”¨ã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã€ŒGoogle Cloud SQLã€ã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚Google Labsã®æ‰±ã„ã§ã€é™å®šãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ã‚°ãƒ¼ã‚°ãƒ«ã¯Google Cloud SQLã‚’æ¬¡ã®ã‚ˆã†ã«ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ By offering the capabilities of a MySQL database, the service enables you to easily move your data, applications, and services into and out of the cloud. ï¼ˆç•¥ï¼‰ To ensure that your critical applications and services are always running, Google Cloud SQL replicates data to
chlono 2011/10/07
google

mysql
ãƒªãƒ³ã‚¯
1 2 3 4 5 æ¬¡ã®ãƒšãƒ¼ã‚¸