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

ghostbass id:ghostbass

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

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

Auroraãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã«ä¼´ã„æ”¹ã‚ã¦MySQL5.7ã®æŠ¼ã•ãˆã‚‹ã¹ããƒã‚¤ãƒ³ãƒˆã«ã¤ã„ã¦å‹‰å¼·ä¼šã‚’é–‹å‚¬ã—ã¾ã—ãŸï¼ - ANDPAD Tech Blog
ã“ã‚“ã«ã¡ã¯ï¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç¦é–“ï¼ˆfkm_yï¼‰ã§ã™ã€‚ å¼Šç¤¾ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æŠ€è¡“é¡§å•ã‚’ã—ã¦é ‚ã„ã¦ã„ã‚‹ä¸‰è°·ï¼ˆmita2ï¼‰ã•ã‚“ã«ã€MySQL5.7ã®è¿½åŠ æ©Ÿèƒ½ã«ã¤ã„ã¦ã®é–‹ç™ºéƒ¨å‘ã‘å‹‰å¼·ä¼šã‚’å®Ÿæ–½ã„ãŸã ãã¾ã—ãŸã®ã§ãã®ãƒ¬ãƒãƒ¼ãƒˆã‚’ãŠä¼ãˆã—ã¾ã™ã€‚ é–‹å‚¬èƒŒæ™¯ å¼Šç¤¾ã§ã¯ä¸‰è°·ã•ã‚“ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‹‰å¼·ä¼šã‚’å®šæœŸçš„ã«é–‹å‚¬ã—ã¦ãŠã‚Šã€3æœˆã«ã‚‚MySQLãƒãƒƒã‚¯ã®åŸºç¤Žç·¨ã®å‹‰å¼·ä¼šã‚’é–‹å‚¬ã—ã¾ã—ãŸã€‚ ANDPADã§ã¯ã€ä»Šå¹´ã®4æœˆã«Aurora MySQLã‚’Ver.1ï¼ˆMySQL5.6äº’æ›ï¼‰ã‹ã‚‰Ver.2ï¼ˆ5.7äº’æ›ï¼‰ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã‚’å®Ÿæ–½ã—ã¾ã—ãŸã€‚ tech.andpad.co.jp Aurora MySQL Ver.2 ã«ãªã‚‹ã“ã¨ã§ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã€MySQL5.7ã§è¿½åŠ ã•ã‚ŒãŸæ©Ÿèƒ½ã«ã¤ã„ã¦é–‹ç™ºè€…ã«çŸ¥ã£ã¦ã‚‚ã‚‰ã„ã€æ™®æ®µã®é–‹ç™ºã«å–ã‚Šå…¥ã‚Œã¦ã‚‚ã‚‰ã†ãŸã‚ã«MySQL5.7ã®å‹‰å¼·ä¼šã‚’é–‹å‚¬ã™ã‚‹ã“ã¨ã¨ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯è¿½åŠ ã•ã‚ŒãŸ150ä»¥ä¸Šã®æ–°æ©Ÿèƒ½
ghostbass 2022/08/03
ãˆã€ä»Š ï¼•ï¼Žï¼— ã«æ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã‚‹ã®ï¼Ÿ8ç³»åˆ—ã§ãªãï¼Ÿï¼Ÿ

mysql

programming
ãƒªãƒ³ã‚¯
CentOS7ã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦åˆæœŸè¨å®šã™ã‚‹ã¾ã§ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
ghostbass 2021/09/09
programming

mysql

database
ãƒªãƒ³ã‚¯
PHP5.6ã¨MySQL8ã§ã€ŒServer sent charset (255) unknown to the client.ã€ãƒãƒžã£ãŸâ€¦
å®Ÿè¨¼ç’°å¢ƒ Windows10 Apache2.4.10 PHP5.6.4 MySQL8.0.15 (æ—§)MySQL5.6.43 PHPã¯mod_phpã§Apacheã¨é€£æºã€MySQLã«ã¯PDOã§æŽ¥ç¶šã—ã¦ã„ã¾ã™ã€‚ çµŒç·¯ é–‹ç™ºç’°å¢ƒã§ä½¿ç”¨ã—ã¦ã„ãŸphp5.6.4ï¼‹MySQL5.6.43ã‚’MySQL8ã«ç§»è¡Œã—ã‚ˆã†ã¨ã—ã¾ã—ãŸã€‚ MySQL8.0.15ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã€æ—¢å˜ã®MySQL5.6.4ã‹ã‚‰å¿…è¦ãªDBã ã‘dumpã—ã¦ç§»è¡Œã™ã‚‹äºˆå®šã€‚ MySQL8.0.15ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«php5.6.4ã‹ã‚‰æŽ¥ç¶šç¢ºèªã‚’ã™ã‚‹æ™‚ã«ãƒãƒžã‚Šã¾ã—ãŸã€‚ ãƒ†ã‚¹ãƒˆDB MySQL8.0.15ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«ä¸‹è¨˜DBã¨TABLEã‚’ä½œæˆã€‚ ãƒ†ã‚¹ãƒˆç”¨ã®DB mysql> CREATE DATABASE test; ãƒ†ã‚¹ãƒˆç”¨ã®TABLE mysql> CREATE TABLE sample(id int,name text); ãƒ†
ghostbass 2021/09/07
å•é¡Œãªã®ã¯ php5.6ã®ã»ã†ã§ã—ã‚‡â€¦

programming

php

mysql
ãƒªãƒ³ã‚¯
MySQL :: Hash join in MySQL 8
The build phase The literature usually divides hash join in two pha ses; the build phase and the probe phase. In the build phase, the server builds an in-memory hash table where rows from one of the inputs are stored, using the join attribute(s) as the hash table key. This input is also known as the build input, and let us assume that â€˜countriesâ€™ is designated as the build input. Ideally, the serve
ghostbass 2019/11/23
ã“ã‚Œã¯ï¼

programming

mysql

rdb
ãƒªãƒ³ã‚¯
ã€MySQLã€‘å¤–éƒ¨ã‚ãƒ¼ã®åˆ¶ç´„ã‚’ç„¡è¦–ã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å‰Šé™¤ã™ã‚‹ | ãƒŸãƒ¼ãƒŸãƒ«ã®æ³¥æ³‰
foreign key ãŒå¤šã™ãŽã¦ãƒ†ãƒ¼ãƒ–ãƒ«ãŒæ¶ˆã›ãªã„ã‚ˆãƒžãƒžãƒ³â€¦ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹ã®é¬¼åã€‚ERDï¼ˆERå›³ï¼‰ã‚’æ›¸ãã¨ãã«ã‚ã‹ã‚Šã‚„ã™ããªã‚‹ã®ã§ã¤ã‘ã‚‹äººãŒå¤šã„ã ã‚ã†ã€‚ ç¢ºã‹ã«ã“ã‚ŒãŒã‚ã‚‹ã“ã¨ã§åˆ¶ç´„ãŒå®ˆã‚‰ã‚Œã¦å¥å…¨ãªæ§‹é€ ã«ãªã‚‹ã¨ã„ã†ã®ã¯åˆ†ã‹ã‚‹ã‚“ã ã‘ã©ã€ãã®é–¢ä¿‚æ€§ã‚’ï¼ˆã‚ãŸã‚Šã¾ãˆã ã‘ã©ï¼‰å¸¸ã«ä¿ã¤ãŸã‚ã¨ã«ã‹ããƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã—è¾›ããªã‚‹ã€‚ ç‰¹ã«é–‹ç™ºåˆæœŸã«ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã‚’é »ç¹ã«ä½œã‚Šæ›¿ãˆã‚‹ã¨ããªã©ã¯drop tableã‚‚ã¾ã¾ãªã‚‰ãªã„çŠ¶æ…‹ã«é™¥ã£ã¦ã€ã¤ã„drop databaseã—ã¦ã—ã¾ã†ã“ã¨ã‚‚ã—ã°ã—ã°ã ã‚ã†ã€‚ â€¦ã ã‚ˆãï¼Ÿ ã¨ã„ã†ã‚ã‘ã§ã€MySQLã§åˆ¶ç´„ã‚’ç„¡è¦–ã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å‰Šé™¤ã§ãã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚’ãƒ¡ãƒ¢ã€‚ å¯¾å¿œæ–¹æ³• MySQLã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’åˆ©ç”¨ã™ã‚‹ã¨åˆ¶å¾¡ã‚’ONãƒ»OFFã§ãã‚‹ã€‚ å¤–éƒ¨ã‚ãƒ¼ãŠã‚ˆã³ãã®ä»–ã®MySQLã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ ä½¿ã†ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯ä»¥ä¸‹ã€‚ FOREIGN_KEY_CHECKS åˆ¶ç´„ã‚’ç„¡åŠ¹ã«ã™ã‚‹ã¨ãã¯ S
ghostbass 2019/09/20
å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’ç„¡è¦–ã—ã¦drop table

mysql

database

programming
ãƒªãƒ³ã‚¯
å…è´¹é€å½©é‡‘å®˜æ–¹ç½‘ç«™-å…è´¹é«˜æ¸…å®Œæ•´ç‰ˆ
ghostbass 2019/05/10
å˜ç´”ã«æš—é»™ã®ã‚ãƒ£ã‚¹ãƒˆãŒç™ºç”Ÿã—ã¦ã„ã‚‹ã ã‘ãªã®ã§ã¯

programming

sql

mysql
ãƒªãƒ³ã‚¯
Oracleã‹ã‚‰MySQLã¸ç§»è¡Œã™ã‚‹ãŸã‚ã®æŠ€è¡“çš„ãªè¦ç´ ã¨å…·ä½“çš„ãªæ–¹æ³•ã‚’ã¾ã¨ã‚ãŸç„¡æ–™ã®é›»åæ›¸ç±ï¼šäººæ°—é€£è¼‰ã¾ã¨ã‚èªã¿ï¼ ï¼ IT eBookï¼ˆ42ï¼‰ - ï¼ IT
2016å¹´1æœˆã€Oracle Databaseã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ä½“ç³»ãŒå¤‰æ›´ã•ã‚Œã€æœ€ã‚‚å®‰ä¾¡ã ã£ãŸä¸å°è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®ã€ŒOracle Database Standard Edition Oneï¼ˆä»¥ä¸‹ã€SE1ï¼‰ã€ãŒå»ƒæ¢ã€‚å¾“æ¥ã®ã€ŒOracle Database Standard Editionï¼ˆä»¥ä¸‹ã€SEï¼‰ã€ã®å†…å®¹ã‚’å¤‰æ›´ã—ãŸæ–°ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§ã‚ã‚‹ã€ŒOracle Database Standard Edition 2ï¼ˆSE2ï¼‰ã€ã«ä¸€æœ¬åŒ–ã•ã‚Œã¾ã—ãŸã€‚ ä¾‹ãˆã°ã€ç´„70ä¸‡å††ã ã£ãŸSE1ã®æœ€ä½Žä¾¡æ ¼ã¯ã€SE2ã§ã¯210ä¸‡å††ã‹ã‚‰ã¨é«˜é¡ã«ãªã‚Šã¾ã™ï¼ˆ2016å¹´11æœˆç¾åœ¨ã€ä»¥ä¸‹åŒï¼‰ã€‚ã¾ãŸã€SEã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã—ã¦ã‚‚ã€ç‰©ç†ã‚µãƒ¼ãƒå˜ä½ã®æœ€å¤§æè¼‰CPUã‚½ã‚±ãƒƒãƒˆæ•°ãŒã€SEã®4ã‚½ã‚±ãƒƒãƒˆã‹ã‚‰ã€SE2ã§ã¯2ã‚½ã‚±ãƒƒãƒˆã«æ¸›ã‚‹ã“ã¨ã‹ã‚‰ã€ã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒã«ã‚ˆã£ã¦ã¯ã€ã‚ˆã‚Šä¸Šä½ã§570ä¸‡å††ã‹ã‚‰ã¨ãªã‚‹ã€ŒOracle Database Enterprise Ed
ghostbass 2018/07/25
æ—¢ã«æŒ‡æ‘˜å¤šæ•°ã ã‘ã©ç§»è¡Œå…ˆã¯postgresã˜ã‚ƒãªã„ã®â€¦

Oracle

MySQL

programming
ãƒªãƒ³ã‚¯
MySQL 8.0ç™»å ´ï¼ç«‹ã¡æ¢ã¾ã‚‹ã“ã¨ã‚’çŸ¥ã‚‰ãªã„é€²åŒ–ã¯ã“ã‚Œã‹ã‚‰ã‚‚ç¶šãã€‚
ã‚´ãƒ¼ãƒ«ãƒ‡ãƒ³ã‚¦ã‚£ãƒ¼ã‚¯ã¯ã„ã‹ãŒãŠéŽã”ã—ã•ã‚ŒãŸã ã‚ã†ã‹ã€‚ä»Šå¹´ã¯å¤©æ°—ã‚‚è‰¯ãã€è¡Œæ¥½æ—¥å’ŒãŒç¶šã„ãŸã‚ˆã†ã«æ€ã†ã€‚ ã•ã¦ã€å…ˆæ—¥MySQL 8.0ãŒæ£å¼ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚å°‘ã—æ™‚é–“ãŒçµŒã£ã¦ã—ã¾ã£ãŸãŒã€ä»Šå›žã¯MySQL 8.0ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã€‚ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç‰ˆã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰ã‹ã‚‰å¯èƒ½ã ã€‚ ã²ã¨ã¤å‰ã®æ£å¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯MySQL 5.7ã ã£ãŸã®ã ãŒã€MySQL 8.0ã¯éžå¸¸ã«å¤§ããªãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ãŒå«ã¾ã‚Œã¦ãŠã‚Šã€5.xå°ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’æ¨ã¦åŽ»ã‚ã†ã¨ã„ã†è©±ãŒã‚ã£ãŸã€‚ãã“ã§ã€æ¬¡ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯æœ€åˆã®æ¡ã‚’å¢—ã‚„ã™ã¨ã„ã†ã“ã¨ã«ãªã£ãŸã®ã ãŒã€MySQL 6.0ã¯éŽåŽ»ã«æ—¢ã«å˜åœ¨ã—ã€è²·åŽãªã©ã®é¨’ãŽã§é–‹ç™ºãŒé “æŒ«ã—ã¦ã—ã¾ã£ãŸçµŒç·¯ãŒã‚ã‚‹ã€‚7.xã¯MySQL NDB Clusterã¨è¢«ã£ã¦ã„ã‚‹ã€‚ã¨ã„ã†ã‚ã‘ã§ã€5.7ã®7ã®éƒ¨åˆ†ã®æ¬¡ã¨ã„ã†æ„å‘³åˆã„ã‚‚ã‚ã£ã¦ã€8.0ã¨ã„ã†ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’å¼•ã£ã•ã’ã€æº€ã‚’æŒã—ã¦ã®ç™»å ´ã¨ãªã£ãŸã€‚ãã®
ghostbass 2018/05/07
å†å¸°çš„CTEãŒä½¿ãˆã‚‹ã£ã¦ã“ã¨ã¯å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«ã‚‚ç”¨æ¸ˆã¿ã«ãªã‚‹ã£ã¦ã“ã¨ã‹

MySQL

programming

database
ãƒªãƒ³ã‚¯
mysql_*ãŒéžæŽ¨å¥¨ã«ãªã‚Šã€ãã®å¾Œå»ƒæ¢ã•ã‚ŒãŸç†ç”±ã¨ã¯ï¼Ÿ
SQL(Structured Query Language)ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ (RDBMS)ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨€èªžã§ã™ã€‚å¤§ããåˆ†ã‘ã¦ã€ãƒ‡ãƒ¼ã‚¿å®šç¾©è¨€èªž(DDL)ã€ãƒ‡ãƒ¼ã‚¿æ“ä½œè¨€èªž(DML)ã€ãƒ‡ãƒ¼ã‚¿åˆ¶å¾¡è¨€èªž(DCL)ã®3ã¤ã§æ§‹æˆã•ã‚Œã¦ãŠã‚Šã€ãƒ—ãƒã‚°ãƒ©ãƒ ä¸Šã§SQLæ–‡ã‚’ç”Ÿæˆã—ã¦ã€RDBMSã«å‘½ä»¤ã‚’å‡ºã—ã€RDBã«å¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã§ãã¾ã™ã€‚ã¾ãŸã€æ ¼ç´ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’å¼•ãå‡ºã™ã“ã¨ã‚‚å¯èƒ½ã§ã™ã€‚ PHPã¯ã€Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã«ç‰¹åŒ–ã—ã¦é–‹ç™ºã•ã‚ŒãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã™ã€‚å¤§ããªç‰¹å¾´ã®ã²ã¨ã¤ã¯ã€HTMLã«ç›´æŽ¥ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’åŸ‹ã‚è¾¼ã‚€ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ç‚¹ã§ã™ã€‚PHPã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã€HTMLã‚’å‹•çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¨ã—ã¦å‡ºåŠ›ã§ãã¾ã™ã€‚HTMLãŒãã®ã¾ã¾ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ã®ã«å¯¾ã—ã€PHPãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã‚µãƒ¼ãƒå´ã§å®Ÿè¡Œã•ã‚ŒãŸçµæžœãŒãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ãŸã‚ã€PHPã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã€Œã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚¹ã‚¯ãƒªãƒ—ãƒˆã€ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚
ghostbass 2016/12/30
ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®å•é¡Œã¯ãªã„ã®ï¼Ÿ

programming

php

mysql
ãƒªãƒ³ã‚¯
Redmine3.1ã‚’CentOS7.1ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€æ—¢å˜ã®Redmine1.2ã®ãƒ‡ãƒ¼ã‚¿ã®ç§»è¡Œã‚’è¡Œã†æ‰‹é † - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
ghostbass 2015/12/17
ã‚„ã‚ŠãŸã‹ã£ãŸã“ã¨ãªã®ã§åŠ©ã‹ã‚‹

redmine

BTS

CentOS

MySQL

ruby on rails
ãƒªãƒ³ã‚¯
ï¼»é€Ÿå ±ï¼½Amazon Auroraç™ºè¡¨ã€‚MySQLäº’æ›ã§æ€§èƒ½5å€ã€å•†ç”¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨åŒç‰ã®æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ãƒžãƒãƒ¼ã‚¸ãƒ‰ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€‚AWS re:Invent 2014
ï¼»é€Ÿå ±ï¼½Amazon Auroraç™ºè¡¨ã€‚MySQLäº’æ›ã§æ€§èƒ½5å€ã€å•†ç”¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨åŒç‰ã®æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ãƒžãƒãƒ¼ã‚¸ãƒ‰ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€‚AWS re:Invent 2014 Amazonã‚¯ãƒ©ã‚¦ãƒ‰ã‚’æä¾›ã™ã‚‹Amazon Web Servicesã¯ã€åŒç¤¾ã®å¹´æ¬¡ã‚¤ãƒ™ãƒ³ãƒˆã€ŒAWS re:Inventã€ã‚’ç±³ãƒ©ã‚¹ãƒ™ã‚¬ã‚¹ã§é–‹å‚¬ã—ã¦ã„ã¾ã™ã€‚ åˆæ—¥ã®åŸºèª¿è¬›æ¼”ã§ã¯ã€ã‚¯ãƒ©ã‚¦ãƒ‰ãŒã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºITã«ãŠã‘ã‚‹ãƒ‹ãƒ¥ãƒ¼ãƒŽãƒ¼ãƒžãƒ«ï¼ˆæ–°ã—ã„æ™®é€šï¼‰ã§ã‚ã‚‹ã“ã¨ã‚’å¼·èª¿ã€‚æ–°ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã€MySQLäº’æ›ã§ã‚ã‚Šã¤ã¤å•†ç”¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸¦ã®æ€§èƒ½ã¨æ©Ÿèƒ½ã‚’å®Ÿç¾ã—ãŸã¨ã„ã†ã€ŒAmazon Auroraã€ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ MySQLã¨ãƒ•ãƒ«äº’æ›ã§ã‚ã‚ŠãªãŒã‚‰5å€ã®æ€§èƒ½ Amazon Web Servicesã‚·ãƒ‹ã‚¢ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆ Andy Jassyæ°ã€‚ æ—¢å˜ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã®ã¯é«˜ä¾¡ã§ã€ãƒ—ãƒãƒ—ãƒ©ã‚¤ã‚¨ã‚¿ãƒªã§
ghostbass 2014/11/13
5å€ä»¥ä¸Šã®ã‚¨ãƒãƒ«ã‚®ãƒ¼ã‚²ã‚¤ãƒ³ãŒ

programming

mysql
ãƒªãƒ³ã‚¯
MySQLã®Limitã¯Offsetã®ã¿ã®å€¤ã‚’å—ã‘ä»˜ã‘ãªã„ | PHPã®ç¨® ãƒ–ãƒã‚°
Zend Frameworkã§MySQLã‚’ä½¿ã£ã¦ã„ã¦ã€LimitãŒNullã ã¨OffsetãŒåŠ¹ã‹ãªã„ç—‡çŠ¶ãŒå‡ºãŸã®ã§èª¿ã¹ã¦ã¿ãŸã‚‰ã€MySQLãŒãã†ãªã‚“ã§ã™ãã€‚ MySQLã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’è¦‹ã‚‹ã¨ã€è¼‰ã£ã¦ã„ã¾ã™ã€‚ LIMIT æ¡é …ã¯ SELECT ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã«è¿”ã•ã‚ŒãŸè¡Œæ•°ã‚’åˆ¶é™ã™ã‚‹ã®ã«åˆ©ç”¨ã™ã‚‹äº‹ãŒã§ãã¾ã™ã€‚LIMIT ã¯ã€è² æ•°ä»¥å¤–ã®æ•´æ•°å®šæ•°ã§ãªã‘ã‚Œã°ã„ã‘ãªã„ã€ï¼‘ã¤ã‹2ã¤ã®æ•°å€¤å¼•æ•°ã‚’å–ã‚Šã¾ã™ã€‚(æº–å‚™ã•ã‚ŒãŸã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹æ™‚ä»¥å¤–) ãã®2ã¤ã®å¼•æ•°ã®ã†ã¡ã€æœ€åˆã®ç‰©ã¯è¿”ã•ã‚Œã‚‹æœ€åˆã®è¡Œã®ã‚ªãƒ•ã‚»ãƒƒãƒˆã‚’æŒ‡å®šã—ã€2ã¤ã‚ã®ç‰©ã¯è¿”ã•ã‚Œã‚‹è¡Œã®æœ€é«˜æ•°ã‚’æŒ‡å®šã—ã¾ã™ã€‚å†’é ã®è¡Œã®ã‚ªãƒ•ã‚»ãƒƒãƒˆã¯0ã§ã™ã€‚ï¼ˆ1ã§ã¯ã‚ã‚Šã¾ã›ã‚“ï¼‰ SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15 å…¨ã¦ã®è¡Œã‚’ä¸€å®šã®ã‚ªãƒ•ã‚»ãƒƒãƒˆã‹ã‚‰çµæžœã‚»ãƒƒãƒˆã®æœ€å¾Œã¾ã§æ¤œç´¢ã™ã‚‹ã«ã¯ã€2ã¤ã‚ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«å¤§ãã„
ghostbass 2014/01/30
ãã†ã„ã†å‡¦ç†ã¯å¿…è¦ï¼Ÿ

mysql
ãƒªãƒ³ã‚¯
Windowsã§localhostã¸ã®æŽ¥ç¶šãŒé…ã„(è§£æ±ºæ–¹æ³•)
Windowsã§Apache+PHP+MySQLã§å‹•ä½œã™ã‚‹WEBã‚¢ãƒ—ãƒªã‚’ä½œæˆã—ã¦ã„ã¦æ°—ãŒã¤ã„ãŸã®ã ãŒã€ ã©ã†ã‚„ã‚‰ã€localhostã«æŽ¥ç¶šã™ã‚‹ã®ãŒé…ã„ã‚±ãƒ¼ã‚¹ãŒã‚ã‚‹ã‚ˆã†ã ã€‚ ãƒ†ã‚¹ãƒˆç’°å¢ƒã¯æ¬¡ã®é€šã‚Šã€‚ OS å Microsoft Windows 7 Professional ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 6.1.7600 ãƒ“ãƒ«ãƒ‰ 7600 ã‚·ã‚¹ãƒ†ãƒ ã®ç¨®é¡ž x64-ãƒ™ãƒ¼ã‚¹ PC ãƒ—ãƒã‚»ãƒƒã‚µ Intel(R) Core(TM) i5 CPU 660 @ 3.33GHzã€3334 Mhzã€2 å€‹ã®ã‚³ã‚¢ã€4 å€‹ã®ãƒã‚¸ã‚«ãƒ« ãƒ—ãƒã‚»ãƒƒã‚µ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ã®ç‰©ç†ãƒ¡ãƒ¢ãƒª (RAM) 12.00 GB Apache 2.2.16 MySQL Server 5.1 64bit PHP Version 5.3.9 CakePHPã®ãƒ–ãƒã‚°ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã«è¼‰ã£ã¦ã„ã‚‹å˜ç´”ãªæ–¹æ³•ã‚’è©¦ã—ã¦ã„ã‚‹ã¨ã€ 5ä»¶ã—ã‹ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ã¦ã„ãªã„Tableã®è¡¨ç¤º
ghostbass 2013/01/21
ããã€ã“ã‚Œå¿˜ã‚Œã¦ãŸã€‚

mysql

windows
ãƒªãƒ³ã‚¯
php5.4ç³»ã®æœ€æ–°ç‰ˆã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹Â |Â ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ãƒ»è‡ªå®…ã‚µãƒ¼ãƒãƒ¼è¨å®šãƒ»æ§‹ç¯‰ã®ãƒ’ãƒ³ãƒˆ
php5.4ç³»ã®æœ€æ–°ç‰ˆã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹
ghostbass 2012/11/13
PHPã¨MySql 2012æœ€æ–°ç’°å¢ƒã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

php

CentOS

mysql
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2012/08/21/20120818oracle-makes-more-moves-to-kill-open-source-mysql/
ghostbass 2012/08/21
ãã†ã„ã†ç¥žè¨—ãŒç™ºã›ã‚‰ã‚ŒãŸã€ã¨ã€‚ã“ã‚Œã‹ã‚‰ã¯è–å‡¦å¥³ã«ç¥ˆã‚Šã‚’ã•ã•ã’ã‚‹ã¹ã—

programming

database

oracle

mysql

opensource
ãƒªãƒ³ã‚¯
ibdata1ã®ã‚µã‚¤ã‚ºã‚’æ¸›ã‚‰ã™æ–¹æ³• - ä¸»å¤«ã¨ãã©ããƒ—ãƒã‚°ãƒ©ãƒž
mysqlã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚©ãƒ«ãƒ€ãŒå¤§ãããªã£ã¦ã„ã‚‹ã€‚ã©ã†ã‚‚ibdata1ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ãŒè‚¥å¤§åŒ–ã—ã¦ã„ã‚‹ã€‚èª¿ã¹ã¦ã¿ã‚‹ã¨ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã§InnoDbã‚’é•·æœŸé–“ä½¿ã£ã¦ã„ã‚‹ã¨ã€ãã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã§ã‚ã‚‹ibdata1ãŒå®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ã‚ˆã‚Šã‚‚å¤§ãã„ãƒ•ã‚¡ã‚¤ãƒ«ã«ãªã£ã¦ã—ã¾ã†ã€‚ã—ã‹ã‚‚ã“ã®ibdata1ã¯å…¨ã¦ã®InnoDbãŒå…±é€šã§ä½¿ã†ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚ˆã†ã ã€‚ ã“ã‚Œã¯ã„ã‹ã‚“ã€ã¨ã„ã†ã“ã¨ã§ibdata1ã®ã‚µã‚¤ã‚ºã‚’æ¸›ã‚‰ã—ã€tableã”ã¨ã«ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã™ã‚‹æ–¹æ³•ã®ã¾ã¨ã‚ã€‚ 1.databaseã‚’ã™ã¹ã¦ãƒ€ãƒ³ãƒ— DBã«ç™»éŒ²ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ã™ã¹ã¦ãƒ€ãƒ³ãƒ—ã—ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¤ãã‚Šã¾ã™ã€‚--single-transaction ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ã¤ã‘ã‚‹ã“ã¨ã§ã€ãƒ€ãƒ³ãƒ—ä¸ã®ãƒ‡ãƒ¼ã‚¿å¤‰æ›´ã‚’ç¦æ¢ã—ã¾ã™ã€‚ # mysqldump -u root -p --all-database --single-transaction > /tmp/all-da
ghostbass 2012/06/27
ã‚ã¨ã§ã‚„ã‚‹

database

mysql

ç®¡ç†
ãƒªãƒ³ã‚¯
MySQLã®ibdataãƒ•ã‚¡ã‚¤ãƒ«ã‚’è¤‡æ•°è¡¨é ˜åŸŸã«å¤‰æ›´ã™ã‚‹ â€“ OpenGroove
InnoDBã®ibdataãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã¯ã€æ”¾ã£ã¦ãŠãã¨ç›¸å½“è‚¥å¤§åŒ–ã—ã¦ã—ã¾ã†ã€‚10Gã€20Gãªã‚“ã¦ãƒ•ãƒ„ãƒ¼ã«ã„ã£ã¦ã—ã¾ã†ã€‚30Gãã‚‰ã„ã«ãªã‚‹ä¾‹ã‚‚ã‚ã‚‹ã€‚ã‚‚ã£ã¨å¤§ãããªã‚ã†ã¨æ€ãˆã°ãªã‚Œã‚‹ã‚“ã ã‚ã†ã€‚ã¾ã£ãŸãæ€ªç‰©ã¿ãŸã„ãªãƒ¤ãƒ„ã ãªãƒ»ãƒ»ãƒ»ã€‚ ã¨ã€ã„ã†ã‚ã‘ã§ã€é€šå¸¸ã®ibdataãƒ•ã‚¡ã‚¤ãƒ«ã‚’è¤‡æ•°è¡¨é ˜åŸŸã«ã—ã¦ã¿ã‚‹ã€‚è¤‡æ•°è¡¨é ˜åŸŸã«ã™ã‚‹ã¨ãã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯innodb_file_per_tableã€‚é€šå¸¸ã®ibdataãƒ•ã‚¡ã‚¤ãƒ«ã§DBãŒç¨¼åƒã—ã¦ã„ã‚‹çŠ¶æ…‹ã‹ã‚‰ã€è¤‡æ•°è¡¨é ˜åŸŸã«å¤‰æ›´ã™ã‚‹ã¨ãã®æ‰‹é †ãƒ¡ãƒ¢ã€‚è©³ã—ã„ä»•æ§˜ã®è©±ã¯å‰²æ„›ã•ã›ã¦ã„ãŸã ãã€‚æ—©ãå¯ãŸã„ã®ã§ã€‚ ä»¥ä¸‹ã€my.cnfã®è¨˜è¿°ä¾‹ä¸€éƒ¨ã€‚è¤‡æ•°è¡¨é ˜åŸŸã«å¤‰æ›´ã—ã¦ã‚‚ibdataãƒ•ã‚¡ã‚¤ãƒ«ã¯æ¶ˆãˆãªã„ã€‚autoextend:max:4096Mãªã©ã¨è¨˜è¿°ã™ã‚‹ã“ã¨ã§ã‚µã‚¤ã‚ºã‚’åˆ¶é™ã—ã¦ãŠãã€‚ innodb_data_file_path = ibdata1:100M:autoextend:max:409
ghostbass 2012/06/27
ã‚ã¨ã§ã‚„ã‚‹

database

mysql

ç®¡ç†
ãƒªãƒ³ã‚¯
MySQLã«ãŠã‘ã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é…å»¶ã®å‚¾å‘ã¨å¯¾ç–
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã§æœ€ã‚‚ã‚ˆãä½¿ã‚ã‚Œã‚‹æ©Ÿèƒ½ã®ã²ã¨ã¤ã ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯åŸºæœ¬çš„ã«éžåŒæœŸã§ãƒ‡ãƒ¼ã‚¿ã®è¤‡è£½ã‚’è¡Œã†ä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹ã®ã ãŒã€éžåŒæœŸæ•…ã«ã©ã†ã—ã¦ã‚‚é€ƒã‚Œã‚‰ã‚Œãªã„å•é¡ŒãŒã‚ã‚‹ã€‚ãã®ã²ã¨ã¤ãŒä»Šå›žã®ãƒ†ãƒ¼ãƒžã€é…å»¶ã§ã‚ã‚‹ã€‚ã¨ã„ã†ã¨ã€MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã™ãã«é…å»¶ãŒç”Ÿã˜ã¦ã—ã¾ã†ã‚ˆã†ã«æ„Ÿã˜ã¦ã—ã¾ã†ã‹ã‚‚çŸ¥ã‚Œãªã„ãŒã€ãã®ã‚ˆã†ãªã“ã¨ã¯ãªã„ã€‚ã»ã¨ã‚“ã©ã®å ´åˆã¯å³åº§ã«ã‚¹ãƒ¬ãƒ¼ãƒ–ã®æ›´æ–°ãŒè¡Œã‚ã‚Œã‚‹ã€‚ ãªãœé…å»¶ã¯ç™ºç”Ÿã™ã‚‹ã®ã‹ã€ã©ã®ã‚ˆã†ã«é…å»¶ãŒèµ·ãã¦ã„ã‚‹ã“ã¨ã‚’èª¿ã¹ã‚‹ã®ã‹ã€ã©ã®ã‚ˆã†ã«å›žé¿ã™ã‚‹ã®ã‹ã¨ã„ã†ã“ã¨ã‚’æœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã¯è§£èª¬ã—ãŸã„ã€‚ã†ã¾ãé…å»¶ã¨ä»˜ãåˆã£ã¦ã€MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚ˆã‚Šå¿«é©ã«é‹ç”¨ã—ã¦ã‚‚ã‚‰ãˆã‚Œã°ã¨æ€ã†ã€‚ ãã‚‚ãã‚‚é…å»¶ã¨ã¯ä½•ã‹MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžåŒæœŸã§è¡Œã‚ã‚Œã‚‹ã€‚ã“ã‚Œã¯æº–åŒæœŸã§ã‚‚åŒã˜ã§ã‚ã‚Šã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ãŠã„ã¦æ›´æ–°ãŒèµ·ãã‚‹ã®ã¯ãƒžã‚¹ã‚¿ãƒ¼ã‚ˆã‚Šã‚‚ä¸€çž¬é…ã‚Œã¦ã—ã¾ã†ã€‚ã“ã‚Œã¯éžåŒæœŸã§ã‚ã‚‹ãŒæ•…ã«é€ƒã‚Œ
ghostbass 2011/12/14
database

mysql

programming
ãƒªãƒ³ã‚¯
é«˜æ©Ÿèƒ½ã§è»½å¿«ãªMySQLãƒ»SQLiteã®ç®¡ç†ãƒ„ãƒ¼ãƒ«SQL Buddy Â» ã¨ã‚Šã‚ãˆãš9JP
phpMyAdminã®ä»£ã‚ã‚Šã«ä½¿ãˆãã†ãªã€MySQLç®¡ç†ãƒ„ãƒ¼ãƒ«ã€SQL Buddyã‚’ä½¿ã£ã¦ã¿ãŸã®ã§ãƒ¡ãƒ¢ã—ã¦ã¿ã‚‹ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯æ¥µã€…ç°¡å˜ã§ã€SQL Buddyã®ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦è§£å‡å¾Œã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã™ã‚‹ã ã‘ã€‚ ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã¨ã€ä»¥ä¸‹ã®ã‚ˆã†ãªãƒšãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ phpMyAdminåŒæ§˜è‡ªãƒ›ã‚¹ãƒˆä»¥å¤–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ã‚‚å¯èƒ½ãªæ¨¡æ§˜ã€‚ ã“ã®SQLBuddyã€æ“ä½œå¯èƒ½ãªæ©Ÿèƒ½ã®é¢ã§ã¯ã€phpMyAdminã«è‹¥å¹²åŠ£ã‚‹ã‚‚ã®ã®ã€æ“ä½œæ€§ã¨ã„ã†ã‹ã€ç®¡ç†ãƒ‘ãƒãƒ«ã®ã‚·ãƒ³ãƒ—ãƒ«ã•ã¨ã„ã†ç‚¹ã§ã¯ã€phpMyAdminã‚ˆã‚Šã‚‚å„ªã‚Œã¦ã„ã‚‹ã¨æ€ã†ã€‚ ã¾ãŸã€å‹•ä½œãã®ã‚‚ã®ã‚‚phpMyAdminã‚ˆã‚Šè»½å¿«ãªæ°—ãŒã™ã‚‹ã€‚ ä»¥ä¸‹ã¯ãƒ¦ãƒ¼ã‚¶ç®¡ç†ç”»é¢ã®ä¾‹ ã‚ã¨ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦æ°—ã¥ã„ãŸã®ã ã‘ã©â€¦ ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã§SQLiteã‚’é¸æŠžã™ã‚‹ã¨SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚ç®¡ç†å¯èƒ½ãªæ¨¡æ§˜ã€‚ ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«DBãƒ•ã‚¡ã‚¤
ghostbass 2011/03/02
SQLiteã®é…ç½®ã®ä»•æ–¹ã‹ã‚‰ã™ã‚‹ã¨â€¦ã©ã†ã ã‚ã†

sqlite

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†
ãƒªãƒ³ã‚¯
ã¼ããŒPDOã‚’æŽ¡ç”¨ã—ãªã‹ã£ãŸã‚ã‘(Shift_JISã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³)
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2010å¹´7æœˆ1æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š PHPã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ©ã‚¤ãƒ–ãƒ©ãƒªPDOã¯ã€DBæŽ¥ç¶šæ™‚ã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°æŒ‡å®šãŒã§ããªã„ãŸã‚ã€æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®é¸æŠžã«ã‚ˆã£ã¦ã¯ã€ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã£ã¦ã„ã¦ã‚‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ãŒç™ºç”Ÿã—ã¾ã™ã€‚ è¿½è¨˜(2011/06/19) ã“ã“ã«æ¥ã¦æ€¥ã«ãƒ–ã‚¯ãƒžãŒè¿½åŠ ã•ã‚Œã¯ã˜ã‚ã¦ã„ã¾ã™ãŒã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ã‹ã‚‰çŠ¶æ³ãŒæ”¹å–„ã—ã¦ã„ã¾ã™ã€‚PHP5.3.6(2011/03/17)ã«ã¦ã€PDOã§ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’æŒ‡å®šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã“ã®ç‰ˆã§ã€UNIXç‰ˆã®PHPã§ã¯è§£æ±ºã—ã¾ã—ãŸãŒã€Win
ghostbass 2010/07/01
security

mysql

php

programming
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸