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

dreammind id:dreammind

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

${{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ã€‘å¤§é‡ãƒ‡ãƒ¼ã‚¿ã§ LIMIT ã¨ OFFSET ã‚’ä½¿ã†ã¨é…ã„ - pospomeã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æ—¥è¨˜
1000ä¸‡ä»¶ãã‚‰ã„ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã£ã¦ã€ ãã“ã‹ã‚‰ LIMIT OFFSET ã§ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹ã‚“ã ã‘ã©ã€ OFFSET ã®å€¤ãŒå¤§ãã‘ã‚Œã°å¤§ãã„ã»ã©ã€é…ããªã‚‹ã€‚ ãªãœé…ã„ã®ã‹? ã¨æ€ã£ã¦ EXPLAIN ã‚’å®Ÿè¡Œã—ãŸã¨ã“ã‚ã€ LIMIT OFFSET ã¯ ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ•ãƒ«ã‚¹ã‚ãƒ£ãƒ³(ALL) ã ã£ãŸãƒ»ãƒ»ãƒ»ã€‚ ãªã‚“ã¨ãªãã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒåŠ¹ã„ã¦ã„ã‚‹ã‚‚ã®ã ã¨æ€ã£ã¦ãŸãŒã€ ãã†ã§ã‚‚ãªã‹ã£ãŸã€‚ --- è¿½è¨˜ 2014/11/10 --- ã‚³ãƒ¡ãƒ³ãƒˆã«ã¦ ã€ŒALLã«ãªã‚‹ã®ã¯ã€ä½•ã‚‰ã‹ã®ã‚ãƒ¼ã§ã‚½ãƒ¼ãƒˆã—ãªã„ã¨ALLã«ãªã‚Šã¾ã™ã€ ã¨ã®ã”æŒ‡æ‘˜ã‚’ã„ãŸã ãã¾ã—ãŸã€‚ ---------------------- --- è¿½è¨˜ 2014/06/13 --- ãªãœã‹ã“ã®è¨˜äº‹ã®é–²è¦§æ•°ãŒå¢—ãˆã¦ã„ãŸã®ã§å†…å®¹ã‚’å†ç¢ºèªã—ã¦ã¿ã¾ã—ãŸã€‚ ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒå¤šããªã‚‹ã¨ LIMIT OFFSET ãŒé…ã„ã¨ã„ã†ã®ã¯é–“é•ã„ãªã„ã¨æ€ã†ã€‚ ãŸã ã€ä¸Šè¨˜ã®ã€ŒLIMIT
dreammind 2015/05/07
mysql
ãƒªãƒ³ã‚¯
DBãŒå˜åœ¨ã—ãªã„ã¨ãã«DBã‚’ä½œæˆã™ã‚‹Chefãƒ¬ã‚·ãƒ”ã‚’ä½œã£ãŸã¨ãã®è©¦è¡ŒéŒ¯èª¤ãƒ¡ãƒ¢
é–‹ç™ºã‚µãƒ¼ãƒç”¨ã®cookbookã‚’ä½œã‚‹éš›ã«ã€MySQLã®DBãŒå˜åœ¨ã—ãªã„ã¨ãã«DBã‚’ä½œæˆã—ãŸã‹ã£ãŸã¨ãã®è©¦è¡ŒéŒ¯èª¤ãƒ¡ãƒ¢ opscode-cookbooks/wordpressã®DBä½œæˆéƒ¨åˆ†ã‚’å‚è€ƒã«ã¨ã„ã†ã‹ã»ã¼ãã®ã¾ã¾æµç”¨ ä½¿ç”¨ã—ãŸboxã¯ http://developer.nrel.gov/downloads/vagrant-boxes/CentOS-6.4-i386-v20130731.box ã‚„ã‚ŠãŸã„ã“ã¨ MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨èµ·å‹• DBãƒ¦ãƒ¼ã‚¶ã®ä½œæˆ DBã®ä½œæˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆ 1.MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨èµ·å‹• package "mysql-server" do action :install end service "mysqld" do action [ :enable, :start ] supports :status => true, :restart => true, :
dreammind 2014/02/22
[chef]

mysql
ãƒªãƒ³ã‚¯
Google Mapsã¨MySQLã®é€£æº
ã“ã‚“ã«ã¡ã¯ã€ã‚¢ã‚·ã‚¢ãƒ«ã®ä¸å·ã§ã™ã€‚ Google Mapsã«è¡¨ç¤ºã™ã‚‹æƒ…å ±ã‚’MySQLã®geometryåž‹ã§æ‰±ã†æ–¹æ³•ã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ Google Mapsã®ã‚ã‚‹åœ°ç‚¹ã«ãƒžãƒ¼ã‚«ãƒ¼ã‚’è¡¨ç¤ºã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒã‚ã‚‹å ´åˆã€ ç·¯åº¦ãƒ»çµŒåº¦ã®æƒ…å ±ã§åœ°ç‚¹ã«è¡¨ç¤ºã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ãŒã€ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã“ã®æƒ…å ±ã‚’ä¿å˜ã™ã‚‹å ´åˆã€lat(float), lng(float)ã¨ãã‚Œãžã‚Œã‚«ãƒ©ãƒ ã«ä¿å˜ã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚‹ã®ã§ã™ãŒã€ã“ã®æ–¹æ³•ã§ã¯å„ãƒ‡ãƒ¼ã‚¿ã®ä½ç½®ã®é–¢ä¿‚ãŒéžå¸¸ã«æ‰±ã„ã«ãããªã‚Šã¾ã™ã€‚ Google Mapsã§è¡¨ç¤ºã•ã‚Œã¦ã„ã‚‹ç¯„å›²å†…ã®ãƒ‡ãƒ¼ã‚¿ã®ã¿å–å¾—ã—ãŸã„å ´åˆã‚„ã€ ã‚ã‚‹åœ°ç‚¹ã‹ã‚‰è¿‘ã„é †ã«å–å¾—ã™ã‚‹å ´åˆãªã©ã«é¢å€’ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ãã“ã§ã€MySQL4.1ä»¥é™ã§ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ç©ºé–“æƒ…å ±ã‚’æ‰±ã†æ©Ÿèƒ½ã®ã€Œgeometryã€åž‹ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ã€ŒMySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 10 MySQL ã«ãŠã‘ã‚‹ç©ºé–“æƒ…å ±ã®æ©Ÿèƒ½(æ—¥æœ¬èªž)ã€ ã€Œ
dreammind 2013/02/06
mysql
ãƒªãƒ³ã‚¯
MySQLã§Oracleã®SQLã‚’æ¨¡å€£1ã€€ï¼ˆé›†åˆæ¼”ç®—ç·¨ï¼‰
ã¯ã˜ã‚ã« ã€ŒMySQLã§åˆ†æžé–¢æ•°ã‚’æ¨¡å€£ã€ã‚·ãƒªãƒ¼ã‚ºã«ç¶šã„ã¦ã€MySQLã§Oracleã®SQLã‚’æ¨¡å€£ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚æœ¬ç¨¿ã§ã¯ã€minusã€intersectã€å®Œå…¨å¤–éƒ¨çµåˆã€ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³åŒ–ã•ã‚ŒãŸå¤–éƒ¨çµåˆã¨åŒã˜çµæžœã‚’å–å¾—ã™ã‚‹SQLã‚’æ‰±ã„ã¾ã™ã€‚ å¯¾è±¡èªè€… MySQLã§ã€Oracleã®SQLã¨åŒã˜çµæžœã‚’å–å¾—ã™ã‚‹SQLã‚’æ›¸ããŸã„æ–¹ Oracleã®SQLã®ç†è§£ã‚’æ·±ã‚ãŸã„æ–¹ å¿…è¦ãªç’°å¢ƒ æœ¬ç¨¿ã§æ‰±ã†SQLã¯ã€MySQL 5.1.28ã§å‹•ä½œç¢ºèªã—ã¾ã—ãŸã€‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯Oracle 10.2.0.1.0ã§ã‚‚å‹•ä½œç¢ºèªã—ã¾ã—ãŸã€‚ãã®ä»–ã€æ¬¡ã®ç’°å¢ƒã§ã‚‚å¿œç”¨ãŒå¯èƒ½ã§ã™ã€‚ PostgreSQL SQL Server DB2 1. minus minusã¯ã€å·®é›†åˆæ¼”ç®—ã‚’è¡Œã„ã¾ã™ã€‚Oracleä»¥å¤–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã€exceptã§å®Ÿè£…ã•ã‚Œã¦ã„ã¾ã™ï¼ˆæ¨™æº–SQLã§exceptã¨ã—ã¦å®šç¾©ã•ã‚Œã¦ã„ã‚‹ãŸã‚ï¼‰ã€‚ MySQL
dreammind 2009/10/14
é›†åˆæ¼”ç®—

mysql
ãƒªãƒ³ã‚¯
MySQLå„ç¨®Tips
ã“ã“ã§ã¯ã€MySQLã«é–¢ã™ã‚‹äº‹ã‚’æ›¸ã„ã¦ã„ãã¾ã™ã€‚ æ–°ã—ãæ›¸ã„ãŸã‚‚ã®ãŒä¸Šã«ãªã‚‹ã‚ˆã†ã«ä¸¦ã¹ã¦ã‚ã‚Šã¾ã™ã€‚ MySQL5ã§ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’ä½¿ã† ã¤ã„ã«MySQL5ã«ãŠã„ã¦å¿µé¡˜ã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ã¾ã æ£å¼ãƒªãƒªãƒ¼ã‚¹ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€æ—©é€Ÿãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦è©¦ã—ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã™ã€‚ MySQLã§ã¯ã€SQL:2003 ã¨ã„ã†è¦æ ¼ãŒæŽ¡ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã‚Œã¯IBMã®DB2ç‰ã§ã‚‚ä½¿ã‚ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚Oracleã®10ã§ã‚‚ä½¿ã‚ã‚Œã‚‹ã¨ã‹ä½¿ã‚ã‚Œãªã„ã¨ã‹ã€‚ ä»¥å‰ã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨äº’æ›æ€§ã¯ã‚ã‚‹ã‚‰ã—ã„ã®ã§ã€ Oracleã®PL/SQLç‰ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹äººãªã‚‰ã°ç°¡å˜ã«ç§»è¡Œã§ãã‚‹ã§ã—ã‚‡ã†ã€‚ ãªãŠã€ä»¥ä¸‹ã®å†…å®¹ã¯ã»ã¼MySQLã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«è¼‰ã£ã¦ã„ã‚‹ã“ã¨ã‚’æ—¥æœ¬èªžã§èª¬æ˜Žã—ã¦ã„ã‚‹ã«éŽãŽã¾ã›ã‚“ã€‚ ã‚ã‹ã‚‰ãªã„äº‹ãŒã‚ã£ãŸã‚‰ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«åŽŸæ–‡ã‚’èªã‚€ã“ã¨ã‚’ãŠå‹§ã‚ã—ã¾ã™ã€‚ ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’å®£è¨€ã™ã‚‹ CRE
dreammind 2009/07/05
mysql

ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£
ãƒªãƒ³ã‚¯
mysql:12071ã€€éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†
From: zen kishimoto <zen kishimoto <zen@xxxxxxxxxx>> Date: Sat, 03 Sep 2005 09:24:15 -0700 Subject: [mysql 12071] éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†ã€€ï¼ˆManaging Hierarchical Data in MySQLï¼‰ http://dev.mysql.com/tech-resources/articles/hierarchical-data.html ï¼ˆå›³ã¯ã“ã®ã‚µã‚¤ãƒˆã‚’å‚ç…§ã®ã“ã¨ï¼‰ Mike Hillyerè‘— åˆã‚ã« å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ä¸€å›žãã‚‰ã„ã¯SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã§ã€éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ æ‰±ã£ãŸã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã®ã¨ãã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ç”¨ã«é–‹ç™ºã•ã‚Œãªã‹ã£ãŸã¨è€ƒãˆãŸã¨æ€ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯éšŽå±¤åŒ–ã•ã‚Œã¦ãŠã‚‰ãš
dreammind 2009/07/05
mysql

éšŽå±¤
ãƒªãƒ³ã‚¯
mysqlã«ç‹¬è‡ªé–¢æ•°ã‚’çµ„ã¿è¾¼ã‚€ï¼ˆUDFï¼‰ - download_takeshiâ€™s diary
mysqlã«ã¯ç‹¬è‡ªã®ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°ã‚’çµ„ã¿è¾¼ã‚€ã“ã¨ãŒã§ãã‚‹ã€ŒUDFã€ï¼ˆUser Defined Functionï¼‰ã£ã¦æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ ä¾‹ãˆã°sennaã®snippetãªã©ã‚‚UDFã¨ã—ã¦æ›¸ã‹ã‚Œã¦ã‚‹ã¿ãŸã„ã§ã™ã€‚ mysqlã«è©³ã—ã„æ–¹ã€…ã®é–“ã§ã¯çµæ§‹ãƒ¡ã‚¸ãƒ£ãƒ¼ãªã‚‚ã®ã®ã‚ˆã†ã§ã™ãŒã€å®Ÿéš›ã«ä½¿ã£ã¦ã¿ãŸã“ã¨ãŒãªã‹ã£ãŸã®ã§ã€ã¡ã‚‡ã£ã¨è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ ä½œã£ã¦ã¿ã‚‹é–¢æ•° mysqlã«ã¯ç¾åœ¨æ™‚åˆ»ã‚’ãƒŸãƒªç§’ã¾ã§è¡¨ç¤ºã—ã¦ãã‚Œã‚‹æ©Ÿèƒ½ãŒãªã„ã‚ˆã†ãªã®ã§ã€ãã‚Œã‚’ä½œã‚Šã¾ã™ã€‚ ã¨ã„ã†ã“ã¨ã§ç¾åœ¨æ™‚åˆ»ã‚’ãƒŸãƒªç§’ã¾ã§è¡¨ç¤ºã™ã‚‹é–¢æ•°ã‚’UDF(User Defined Function)ã¨ã—ã¦çµ„ã¿è¾¼ã‚“ã§ã¿ã¾ã™ã€‚ é–¢æ•°åã¯ã€ŒãƒŸãƒªç§’ã€ã‚’ã‚ã‚‰ã‚ã™ç›´æ„Ÿçš„ãªãƒ•ãƒ¬ãƒ¼ã‚ºã§ã€Œmsecã€ã¨ã—ã¾ã—ãŸã€‚ ã‚´ãƒ¼ãƒ«ã‚¤ãƒ¡ãƒ¼ã‚¸ select msec();ã€€ã¨ã™ã‚‹ã¨ç¾åœ¨æ™‚åˆ»ã‚’ãƒŸãƒªç§’ã¾ã§è¡¨ç¤ºã€‚ select msec("epoch"); ã¨ã™ã‚‹ã¨unix timeã‚’ãƒŸãƒªç§’ã¾ã§è¡¨ç¤º
dreammind 2009/04/25
mysql

udf

C
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.1 Reference Manual :: 14.4.3.7 Using the MySQL memcached UDFs
Section Navigation Â Â Â Â Â [Toggle] 14.4.3 memcached Interfaces14.4.3.1 Using libmemcached 14.4.3.2 Using MySQL and memcached with Perl 14.4.3.3 Using MySQL and memcached with Python 14.4.3.4 Using MySQL and memcached with PHP 14.4.3.5 Using MySQL and memcached with Ruby 14.4.3.6 Using MySQL and memcached with Java 14.4.3.7 Using the MySQL memcached UDFs The memcached MySQL User Defined Functions (UD
dreammind 2009/04/25
mysql

memcached
ãƒªãƒ³ã‚¯
1