[B! MySQL] s_yasueã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

s_yasue id:s_yasue

MySQLã«é–¢ã™ã‚‹s_yasueã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (14)

${{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ã«ãŠã‘ã‚‹ã€Geohashã¨Geometryåž‹ã«ã‚ˆã‚‹æ¤œç´¢ã®æ¯”è¼ƒ - Pixel Pedals of Tomakomai
å…ˆæ—¥ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãŒå¤±æ•—ã ã£ãŸã®ã§ã€æ”¹ã‚ã¦è‡ªå‰ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ãƒ™ãƒ³ãƒã¨ã‚Šã¾ã—ãŸã€‚ å¾Œã€id:kokogiko ã•ã‚“ã«Geometryåž‹ Ã— SPATIAL ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã©ãƒ¼ã‚ˆã£ã¦ãƒ„ãƒƒã‚³ãƒŸã‚’ã‚‚ã‚‰ã£ãŸã®ã§ã€ãã¡ã‚‰ã‚‚ä¸€ç·’ã«ãƒ™ãƒ³ãƒã‚’ã¨ã‚Šã¾ã™ã€‚ Geometryåž‹ã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾© å‰å›žã®Geohashã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä¸€ã¤ã€‚SPATIALã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯MyISAMå°‚ç”¨ãªã®ã§ã€ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä¸€ã¤ã€‚å¾Œã€InnoDBã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è²¼ã£ã¦ã„ãªã„ç‰©ã‚’ç”¨æ„ã—ã¾ã—ãŸã€‚InnoDBã§no-SPATIALãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å¼µã£ãŸç‰©ã‚‚è©¦ã—ãŸã‹ã£ãŸã‚“ã§ã™ãŒã€æ‰‹å…ƒã®ç’°å¢ƒã ã¨MySQLãŒè½ã¡ã¦ã—ã¾ã†ã£ã½ã„ã®ã§ä»Šå›žã¯çœç•¥ã—ã¾ã—ãŸã€‚ CREATE TABLE location ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, geohash VARCHAR(10) NOT NULL
s_yasue 2016/01/28
MySQL

*Map
ãƒªãƒ³ã‚¯
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes : sonots:blog
s_yasue 2015/03/13
MySQL

*DB
ãƒªãƒ³ã‚¯
MySQL ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—é–¢é€£ - ã¨ã¿ãžãƒ¼ãƒŽãƒ¼ãƒˆ
MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«é–¢ã™ã‚‹ãƒ¡ãƒ¢æ›¸ãã€‚ 1.ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã®æ³¨æ„ (1) rootã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã™ã‚‹ã€‚ (2) åŒ¿åãƒ¦ãƒ¼ã‚¶ã‚’å‰Šé™¤ã™ã‚‹ã€‚ åŒ¿åãƒ¦ãƒ¼ã‚¶ã¯test*ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦ã—ã‹ã€æ“ä½œã‚’ã§ããªã„ãŒä¸€å¿œå‰Šé™¤ã—ã¦ãŠã„ãŸæ–¹ãŒã‚ˆã„ã€‚ mysql> DELETE FROM mysql.user WHERE user=''; 2.ãƒ‡ãƒ¼ãƒ¢ãƒ³èµ·å‹•ã¨åœæ¢ [èµ·å‹•] # mysqld_safe --user=mysql & ä¸Šè¨˜ã¯mysqlã¨ã„ã†Unixãƒ¦ãƒ¼ã‚¶ã§ãƒ‡ãƒ¼ãƒ¢ãƒ³ã‚’èµ·å‹•ã™ã‚‹(ãªã‚“ã§ã‚‚ã‚ˆã„ãŒã€rootã ã¨ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ä¸Šã¾ãšã„ã®ã§ã€mysqlç”¨ã«ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ç”¨æ„ã™ã‚‹ã®ãŒã‚ˆã„)ã€‚èµ·å‹•ã§ããªã„å ´åˆã¯ã€ã‚¨ãƒ©ãƒ¼ãƒã‚°ã‚’èª¿æŸ»ã™ã‚‹ã€‚ ã‚¨ãƒ©ãƒ¼ãƒã‚°ã®æ ¼ç´å ´æ‰€ã¯my.cnfã‚„èµ·å‹•æ™‚ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³(--log)ã§æŒ‡å®šã§ãã‚‹ã€‚æŒ‡å®šã—ã¦ã„ãªã„å ´åˆã¯ã€ mysql-data-dir/<ãƒ›ã‚¹ãƒˆå>.err ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã€‚è‡ª
s_yasue 2014/06/17
MySQL
ãƒªãƒ³ã‚¯
ã€ŒphpMyBackupProã€ã§DBã‚’å®šæœŸçš„ã«è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
ç‹¬è‡ªã§ä½œã£ãŸWEBã‚µã‚¤ãƒˆã‚„WEBã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚‚ã¡ã‚ã‚“ã®ã“ã¨ã€Word Pressã‚„MTã§ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†æ©Ÿä¼šãŒã‚ã‚Šã¾ã™ã€‚ HTMLã‚„PHPãªã©ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯è‡ªèº«ã§ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã™ã‚‹ã®ã§ã€æ¯”è¼ƒçš„ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚Šã‚„ã™ã„ã€‚ ã—ã‹ã—DBã¨ãªã‚‹ã¨ã€ã‚„ã‚Šæ–¹ãŒã‚ã‹ã‚‰ãªã‹ã£ãŸã‚Šã€ãã‚‚ãã‚‚å˜åœ¨ã‚’æ„è˜ã—ã¦ã„ãªã„äººã‚‚ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ å®Ÿéš›ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒéšœå®³ã§å¹ã£é£›ã‚“ã å ´åˆã€å…¨ã¦ã®è¨˜äº‹ãŒç„¡ããªã£ã¦ã—ã¾ã†ã“ã¨ã«ãªã‚Šã€ãã®å½±éŸ¿ã¯è¨ˆã‚ŠçŸ¥ã‚Œã¾ã›ã‚“ã€‚ æœ‰äº‹ã«å‚™ãˆã¦ã€è‡ªèº«ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã£ã¦ãŠãã“ã¨ã‚’è–¦ã‚ã¾ã™ã€‚ å¤§äº‹ã«è‡³ã‚‹ã¨çŸ¥ã‚Šã¤ã¤ã‚‚ã€è‡ªåˆ†ãŒæ‰‹å‹•ã§ã‚„ã‚‹ã«ã¯ãƒãƒˆè¾›ã„ã€‚(ç¬‘) ãã“ã§ä¾¿åˆ©ãªã®ãŒã€ã€ŒphpMyBackupProã€ã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ãƒ„ãƒ¼ãƒ«ã¨ã„ã£ã¦ã‚‚PHPã§æ›¸ã‹ã‚ŒãŸãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚Šã€ã”è‡ªèº«ã®ã‚µãƒ¼ãƒã¸æ ¼ç´ã—ã¦ä½¿ç”¨ã—ã¾ã™ã€‚ ã‚ˆã£ã¦ã€å€Ÿã‚Šã¦ã„ã‚‹ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã§ã€PHP4.3ä»¥ä¸ŠãŒä½¿ãˆã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ä»Šã©ã
s_yasue 2013/04/30
MySQL

*Serverç®¡ç†
ãƒªãƒ³ã‚¯
yoko_netã€€Blog : çµåˆã—ãŸSELECTçµæžœã§UPDATEã™ã‚‹Tipsï¼ˆfor MySQLï¼‰
2010å¹´12æœˆ20æ—¥15:55 ã‚«ãƒ†ã‚´ãƒªæŠ€è¡“é–¢é€£ITé–¢é€£ çµåˆã—ãŸSELECTçµæžœã§UPDATEã™ã‚‹Tipsï¼ˆfor MySQLï¼‰ å¤šç”¨ã™ã‚‹å‰²ã«è‰¯ãå¿˜ã‚Œã‚‹ã®ã§æ›¸ã„ã¦ãŠãã¾ã™ã€‚ SQLserverï¼ˆTransact-SQLï¼‰ãªã‚“ã‹ã ã¨ã€ã‹ãªã‚Šç›´æ„Ÿçš„ã«æ›¸ã‘ã‚‹ã‚¤ãƒ¡ãƒ¼ã‚¸ãªã®ã§ã™ãŒMySQLã®æ›¸ãæ–¹ã¯ã‚¤ãƒžã‚¤ãƒæ…£ã‚Œã¾ã›ã‚“ã€‚ å‡„ãå˜ç´”ãªä¾‹ã‚’æ›¸ãã¨ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ UPDATE order_detail OD, product PD SET OD.name = PD.it em_name WHERE PD.it em_code = 10001 AND OD.order_id = 112233; å—æ³¨æ˜Žç´°112233ç•ªã®å•†å“åç§°ã‚’ã€è£½å“ãƒ†ãƒ¼ãƒ–ãƒ«ï¼ˆproductï¼‰ã®å•†å“åç§°ã§ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ã¦ã„ã‚‹ã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã™ã€‚ å®Ÿéš›ã«ã¯ã“ã‚“ãªä½¿ã„æ–¹ã¯ã—ãªã„ã¨æ€ã„ã¾ã™ãŒã€ã‚ãã¾ã§æ§‹æ–‡ä¾‹ã¨ã„ã†ã“ã¨ã§ã€‚ ã§ã¯ã€10001å•†å“ã®å
s_yasue 2013/04/25
MySQL
ãƒªãƒ³ã‚¯
GROUP_CONCATé–¢æ•°ã®ä¾¿åˆ©ã•ã¯ç•°å¸¸ - é–‹ç™ºã®é¢¨æ™¯ã€€ã€œKKZã®SEæ—¥è¨˜ã€œ
http://dev.mysql.com/doc/refman/5.1/ja/group-by-functions.html GROUP_CONCAT(expr) ã“ã®é–¢æ•°ã¯ã€ã‚°ãƒ«ãƒ¼ãƒ—ã‹ã‚‰ã®é€£çµã•ã‚ŒãŸéž NULL å€¤ã‚’ä¼´ã†ã‚¹ãƒˆãƒªãƒ³ã‚°çµæžœã‚’æˆ»ã—ã¾ã™ã€‚éžNULL å€¤ãŒãªã„å ´åˆã¯ NULL ã‚’æˆ»ã—ã¾ã™ã€‚MySQL ã§ã¯ã€å¼ã®ã‚³ãƒ³ãƒ“ãƒãƒ¼ã‚·ãƒ§ãƒ³ã®é€£çµã•ã‚ŒãŸå€¤ã‚’å¾—ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚DISTINCT ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§ã€é‡è¤‡ã—ãŸå€¤ã‚’é™¤ãã“ã¨ãŒå¯èƒ½ã§ã™ã€‚çµæžœã®å€¤ã‚’ã‚½ãƒ¼ãƒˆã—ãŸã„å ´åˆã¯ã€ORDER BY å¥ã‚’ä½¿ç”¨ã—ã¦ãã ã•ã„ã€‚é€†é †ã§ã‚½ãƒ¼ãƒˆã™ã‚‹ã«ã¯ã€DESC ( é™é † ) ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚’ã€ORDER BY å¥ã®ã‚½ãƒ¼ãƒˆã™ã‚‹ã‚«ãƒ©ãƒ ã®åå‰ã«åŠ ãˆã¦ãã ã•ã„ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯æ˜‡é †ã«ãªã£ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯ã€ASC ã‚’ä½¿ã†ã“ã¨ã§æ˜Žç¤ºçš„ã«æŒ‡å®šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚SEPARATOR ã®å¾Œã«ã¯ã€çµæžœã®å€¤ã®é–“ã«æŒ¿å…¥ã•ã‚Œã‚‹ã¹ãã‚¹ãƒˆãƒªãƒ³ã‚°å€¤ãŒç¶š
s_yasue 2013/02/28
MySQL

*DB
ãƒªãƒ³ã‚¯
ã¡ã‚‡ã£ã¨ä½¿ãˆã‚‹MySQLã®å°æŠ€5ã¤+1
ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ã‚¬ã‚¹ã‚’æ¢ã‚ã‚‰ã‚Œæ¸©ã‚‚ã‚Šã®ç„¡ã„ç”Ÿæ´»ã‚’é€ã£ã¦ã„ã‚‹æ¾ç”°ã§ã™ã€‚ ä»Šå›žã¯æœ€è¿‘è‡ªåˆ†ãŒçŸ¥ã£ãŸMySQLã®å°æŠ€ã‚’ã„ãã¤ã‹æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ã‚“ãªã‚‚ã‚“å¸¸è˜ã ã‚ï¼ã£ã¦ãƒã‚¿ãŒã‚ã£ã¦ã‚‚å„ªã—ãè¦‹å®ˆã£ã¦ã‚ã’ã¦ãã ã•ã„ã€‚ ã¾ãšä»Šå›žã®å®Ÿè¡Œã‚µãƒ³ãƒ—ãƒ«ã«ã¯ä»¥ä¸‹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã£ã¦ã¾ã™ã€‚ mysql>Â SELECTÂ *Â FROMÂ user_m; +---------+----------+---------------------+ |Â user_idÂ |Â nameÂ Â Â Â Â |Â create_datetimeÂ Â Â Â Â | +---------+----------+---------------------+ |Â Â Â Â Â Â Â 1Â |Â atsushiÂ Â |Â 2007-05-17Â 21:53:40Â | |Â Â Â Â Â Â Â 2Â |Â joeÂ Â Â Â Â Â |Â 2007-05-17Â 21:53:59Â | |Â Â Â Â Â Â Â 3Â |Â masah
s_yasue 2013/02/28
MySQL

*DB
ãƒªãƒ³ã‚¯
MySQL: æ–‡å—åˆ—ã®çµåˆã«||ï¼ˆãƒ‘ã‚¤ãƒ—ï¼‰ã‚’åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹æ–¹æ³• | QK
MySQLã§æ–‡å—åˆ—çµåˆã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã€concaté–¢æ•°ã—ã‹ä½¿ãˆãªã„ã¨æ€ã£ã¦ãŠã‚Šã¾ã—ãŸãŒã€ä»–è€…DBMSã®ã‚ˆã†ã«ã€ãƒ‘ã‚¤ãƒ—(||ï¼‰ã§è¡¨ç¾ã™ã‚‹ã“ã¨ãŒå¯èƒ½ãªã“ã¨ã‚’ç™ºè¦‹ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ çŸ¥ã‚‰ãªã‹ã£ãŸãƒ»ãƒ»ã€‚ IBM DB2ãªã©ã§æ–‡å—åˆ—çµåˆã™ã‚‹ã‚ˆã†ãªSQLã‚’ç™ºè¡Œã™ã‚‹å ´åˆã€åŸºæœ¬çš„ã«ã¯æ–‡å—åˆ—ã®çµåˆã¯ã€|| ï¼ˆãƒ‘ã‚¤ãƒ—ï¼‰ã‚’åˆ©ç”¨ã—ã¾ã™ã€‚ ãŸã¨ãˆã°ã“ã‚“ãªæ„Ÿã˜ã§æ›¸ãã¨æ€ã„ã¾ã™ã€‚ db2 => SELECT 'TABLE NAME' || ' is ' || TABNAME from syscat.tables fetch first 10 rows only 1 ------------------------------------------------------------------------------------ TABLE NAME is ATTRIBUTES TABLE NAME is BUFFE
s_yasue 2013/02/28
MySQL

*DB
ãƒªãƒ³ã‚¯
çŸ¥ã£ã¦ãŠãã¨ä¾¿åˆ©ãªMySQLé–¢æ•°
ã“ã‚“ã«ã¡ã¯ã€åˆå¤ãªã®ã«ã‚‚ã†å¤ãƒãƒ†æ°—å‘³ã®inoueã§ã™ã€‚ä»Šæ—¥ã‚‚ã‚ªã‚¯ãƒ©è²·ã£ã¦å¸°ã‚ã†ã£ã¨ã€‚ ã•ã¦ã€çŸ¥ã£ã¦ãŠãã¨ä¾¿åˆ©ãªMySQLé–¢æ•° FIND_IN_SET ã®ãŠè©±ã§ã™ã€‚ åŸºæœ¬çš„ã«ã¯æ¨™æº–SQLã§ã‚¯ã‚¨ãƒªã¯æ›¸ã„ãŸã»ã†ãŒã„ã„ã®ã§ã™ãŒã€MySQLå›ºæœ‰ã®é–¢æ•°ãªã©ã‚‚çŠ¶æ³ã«å¿œã˜ã¦åˆ©ç”¨ã™ã‚‹ã¨ ä½œæ¥åŠ¹çŽ‡ãŒã‚¢ãƒƒãƒ—ã™ã‚‹ã®ã§ã€ãã‚“ãªä¸€ä¾‹ã‚’ä»Šå›žã”ç´¹ä»‹ã—ã¾ã™ã€‚ http://dev.mysql.com/doc/refman/5.1/ja/string-functions.html ã‚ˆã‚Šå¼•ç”¨ï¼š FIND_IN_SET(str,strlist) ã‚¹ãƒˆãƒªãƒ³ã‚° str ãŒ N ã‚µãƒ–ã‚¹ãƒˆãƒªãƒ³ã‚°ã§æ§‹æˆã•ã‚Œã‚‹ã‚¹ãƒˆãƒªãƒ³ã‚° ãƒªã‚¹ãƒˆ strlist å†…ã«ã‚ã‚‹å ´åˆã¯ã€1 ã‹ã‚‰ N ã®ç¯„å›²ã®å€¤ã‚’æˆ»ã—ã¾ã™ã€‚ ã‚¹ãƒˆãƒªãƒ³ã‚° ãƒªã‚¹ãƒˆã¯ã€â€˜,â€™ æ–‡å—ã§åŒºåˆ‡ã‚‰ã‚ŒãŸã‚µãƒ–ã‚¹ãƒˆãƒªãƒ³ã‚°ã§æ§‹æˆã•ã‚ŒãŸã‚¹ãƒˆãƒªãƒ³ã‚°ã§ã™ã€‚ idtypes
s_yasue 2013/02/28
MySQL

*DB
ãƒªãƒ³ã‚¯
ä»–DBãƒ¦ãƒ¼ã‚¶ãŒMySQLã‚’ä½¿ã†ã¨ãã€ãƒã‚§ãƒƒã‚¯ã—ãŸã„8ã®ãƒã‚¤ãƒ³ãƒˆ - é›»åçš„é›ªã‹ãç”Ÿæ´»
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã€RDBMSã¯Oracleã€MySQLã€PostgreSQLã€DB2â€¦ã¨è‰²ã€…ã‚ã‚Šã¾ã™ãŒã€ãã‚Œãžã‚Œæ©Ÿèƒ½ã‚‚å†…éƒ¨çš„ãªä»•çµ„ã¿ã‚‚ã ã„ã¶é•ã„ã¾ã™ã€‚ ã“ã®ãŸã‚ã€æ¨™æº–SQLã—ã‹çŸ¥ã‚‰ãªã„ã¨ã‹ã€ä»–RDBMSã—ã‹ä½¿ã£ãŸã“ã¨ãŒãªã„ã€ã¨ã„ã†äººã®ã®è¨è¨ˆãƒ»å®Ÿè£…ã‚’è¦‹ã‚‹ã¨ã€MySQLã§ã¯ã“ã“ã¯ç›´ã—ãŸã»ã†ãŒã„ã„ã‹ã‚‚ãƒ¼ã€ã¨æ€ã†ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ç‰¹ã«æ°—ã«ãªã‚‹ã®ã¯ã€ã€ŒçŸ¥ã‚‰ãªã„ã¾ã¾ã§ã‚‚ä¸€è¦‹å‹•ãã‚‚ã®ã¯ä½œã‚Œã‚‹ã‚“ã ã‘ã‚Œã©ã€å¾Œã‹ã‚‰ä¸å…·åˆã«ç¹‹ãŒã‚Šã‹ããªã„éƒ¨åˆ†ã€ã€‚ é »ç¹ã«å‡ºã¦ãã‚‹ãƒã‚¤ãƒ³ãƒˆã¯æ±ºã¾ã£ã¦ã„ã‚‹ã¯ãšãªã®ã§ãƒã‚§ãƒƒã‚¯ãƒªã‚¹ãƒˆã§ã‚‚ã‚ã‚Œã°ã„ã„ã®ã«ã€ã¨æ€ã†ã®ã§ã™ãŒè¦‹ãŸã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ã¨ã„ã†ã“ã¨ã§ã€è‡ªåˆ†ãªã‚‰ã“ã®è¾ºã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚‹ã‹ãªã€ã¨æ€ã†ãƒã‚¤ãƒ³ãƒˆ8ã¤ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ [2015/01/08æ›´æ–°]ã€€ã‚ã‚Šã¨ã‚¢ã‚¯ã‚»ã‚¹ã„ãŸã ã„ã¦ã„ã‚‹è¨˜äº‹ãªã®ã§ã€æœ€è¿‘ã®mysqläº‹æƒ…ã‚’çŸ¥ã£ã¦ã„ã‚‹ç¯„å›²ã§å°‘ã—åæ˜ ã—ã¾ã—ãŸã€‚ [2017/0
s_yasue 2013/02/28
MySQL

*DB
ãƒªãƒ³ã‚¯
MySQLã§ã¯INå¥ã¨ã‚µãƒ–ã‚¯ã‚¨ãƒªã®çµ„ã¿åˆã‚ã›ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒåŠ¹ã‹ãªã„ï¼ï¼Ÿ
ãªã€ãªã‚“ã¨ person_diaryã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒé©ç”¨ã•ã‚Œãšã«ãƒ•ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã•ã‚Œï¼ˆï¼‘è¡Œç›®ã®keyãŒNULLï¼‰ é€†ã«personã¯idåˆ—ã«è¨å®šã—ã¦ã‚ã‚‹ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ãŒé©ç”¨ã•ã‚Œã‚‹(2è¡Œç›®ã®keyãŒPRIMARY) ã¨ã„ã†äºŒã¤ã®è¬Žãªç¾è±¡ãŒç™ºç”Ÿã—ã¾ã—ãŸã€‚ ãã‚‚ãã‚‚personã¯nameã‚«ãƒ©ãƒ ã«å¯¾ã—ã¦LIKEæ¤œç´¢ã—ã¦ã„ã‚‹ã®ã«ã€idåˆ—ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ãŒåŠ¹ã„ã¡ã‚ƒã†ã®ã¯å…¨ãç´å¾—ã„ãã¾ã›ã‚“ã€‚ãªãœã€ã©ã†ã—ã¦ã“ã‚“ãªã“ã¨ãŒèµ·ã“ã‚‹ã®ã§ã—ã‚‡ã†ï¼Ÿ åŽŸå› ç§ãŒMySQLã«æœŸå¾…ã—ã¦ã„ãŸå‹•ãã¨ã—ã¦ã¯ â‘ ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¦person.idã®ãƒªã‚¹ãƒˆã‚’ãƒ¡ãƒ¢ãƒªä¸ã«ä½œæˆ â‘¡person.person_idã«å¼µã‚‰ã‚Œã¦ã„ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦æ¤œç´¢ ã¨ã„ã†ã¨ã“ã‚ã§ã—ãŸã€‚ æœŸå¾…é€šã‚Šã«å‹•ã„ã¦ãã‚Œãªã‹ã£ãŸã®ã«ã¯äºŒã¤ã®MySQLã®ç‰¹æ€§ãŒé–¢ä¿‚ã—ã¦ã„ã¾ã—ãŸã€‚ ç‰¹æ€§â‘ ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å«ã‚€SQLã¯å¤–å´ã‹ã‚‰å…ˆã«å®Ÿè¡Œã•ã‚Œã‚‹ MySQLã®å ´åˆã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å«ã‚€
s_yasue 2013/02/28
MySQL

*DB
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ãã®ï¼’ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚11ã‚¤ãƒ³ãƒMacBook AirãŒæ¬²ã—ãã¦ãŸã¾ã‚‰ãªã„iwanagaã§ã™ã€‚ å‰å›žã®è¨˜äº‹ ãŒå¹¸ã„ã«ã‚‚ã”å¥½è©•ã‚’é ‚ã‘ãŸæ§˜ã§éžå¸¸ã«ã†ã‚Œã—ã„ã§ã™ã€‚å¬‰ã—ããªã£ã¦ã€ã¤ã„ãŒã‚“ã°ã£ã¦ç¬¬ï¼’å¼¾ã‚’æ›¸ã„ã¦ã—ã¾ã„ã¾ã—ãŸã€‚å¼•ãç¶šãã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã§ã‚ˆãä½¿ã‚ã‚Œã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ—æ¯Žã«ã¡ã‚‡ã£ã¨ã—ãŸãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ ä»Šå›žã¯ã¡ã‚‡ã£ã¨ãƒ©ã‚¤ãƒˆãªæ„Ÿã˜ï¼†èªã¿ç‰©ã«ãªã£ã¦ã—ã¾ã£ã¦ã„ã¾ã™ãŒã€Œãƒ¦ãƒ¼ã‚¶IDå˜ä½ã§1ã¤ã ã‘æŒã¤ãƒ‡ãƒ¼ã‚¿ã€ã¨ã€Œãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãªã©ã®ãƒžã‚¹ã‚¿ãƒ¼ãƒ‡ãƒ¼ã‚¿ã€ã«ã¤ã„ã¦ã”èª¬æ˜Žã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ã¡ãªã¿ã«æ¬¡å›žã¯InnoDBã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã®ç°¡å˜ãªèª¬æ˜Žã¨è¤‡åˆãƒ—ãƒ©ã‚¤ãƒžãƒªãƒ¼ã‚ãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ãã®æ¬¡ã§ç´¹ä»‹ã—æããŸã¡ã‚‡ã£ã¨ãƒžãƒ‹ã‚¢ãƒƒã‚¯ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚„æ€§èƒ½ç®¡ç†ã®ãŸã‚ã®æ‰‹æ³•ã‚’ç´¹ä»‹ã™ã‚‹ã“ã¨ã‚’äºˆå®šã—ã¦ã„ã¾ã™ã€‚ ãã®å‰ã«ã€‚ã€‚ã€‚ å…ˆæ—¥è¡Œã‚ã‚ŒãŸ JAPAN INNOVATION LEADERS SUMMIT ã§å¼Šç¤¾æ¾ä¿¡ãŒã€Œã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®
s_yasue 2011/02/18
ã‚ãƒ£ãƒƒã‚·ãƒ¥ã®è©±

MySQL
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
s_yasue 2011/02/18
ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ãŒå‚è€ƒã«ãªã£ãŸ

MySQL
ãƒªãƒ³ã‚¯
PHPé–‹ç™ºè€…ã®MySQLã®é–“é•ã„ãƒˆãƒƒãƒ—ï¼‘ï¼:phpspoté–‹ç™ºæ—¥èªŒ
Windowsã‚¢ãƒ—ãƒªã®ãƒ„ãƒªãƒ¼ãƒ“ãƒ¥ãƒ¼ã£ã½ã„UIã‚’WEBä¸Šã§ç°¡å˜å®Ÿè£…ã§ãã‚‹jQueryãƒ—ãƒ©... æ¬¡ã®è¨˜äº‹ â‰«ï¼šã‚·ãƒ³ãƒ—ãƒ«ã•ãŒã„ã„æ„Ÿã˜ã®ï¼‘ï¼•ï¼”ç¨®é¡žã®ã‚¢ã‚¤ã‚³ãƒ³ã‚»ãƒƒãƒˆ Top 10 MySQL Mistakes Made by PHP Developers PHPé–‹ç™ºè€…ã®MySQLã®é–“é•ã„ãƒˆãƒƒãƒ—ï¼‘ï¼ã€‚ æ‰‹æ…£ã‚Œã¦ã„ã‚‹äººã«ã¨ã£ã¦ã¯çŸ¥ã£ã¦ã‚‹ã“ã¨ã‚‚å¤šã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€åˆå¿ƒè€…ãŒå½¹ç«‹ã£ãŸã‚Šã€çŸ¥ã‚‰ãªã„éƒ¨åˆ†ã®ã‚«ãƒãƒ¼ã¨ã—ã¦ãƒ¡ãƒ¢ã¨ã—ã¦æ›¸ã„ã¦ã¿ã¾ã™ MyISAMã‚’ä½¿ã£ã¦ã„ã‚‹ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«MyISAMã ã‘ã©InnoDBã‚’ä½¿ãŠã† ãƒªã‚«ãƒãƒªå¯èƒ½ã§ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã€å¤–éƒ¨ã‚ãƒ¼åˆ©ç”¨å¯èƒ½ãªInnoDBãŠã™ã™ã‚ è©³ç´°ï¼šOpen database life: MyISAMã¨InnoDBã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹ PHPã®MySQLé–¢æ•°ã‚’ä½¿ã£ã¦ã„ã‚‹ mysql_* é–¢æ•°ã‚’ä½¿ã‚ãšã€PDOç‰ã§ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸å¤‰æ›´ã«å¯¾å¿œã—ã‚ˆã†
s_yasue 2010/11/25
MySQL
ãƒªãƒ³ã‚¯
1