[B! mysql] mas-higaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mas-higa id:mas-higa

mysqlã«é–¢ã™ã‚‹mas-higaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

GitHubã€Ruby on Railså‘ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ€ãƒ—ã‚¿ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
mas-higa 2022/08/31
ruby

mysql
ãƒªãƒ³ã‚¯
PDOã®ã‚µãƒ³ãƒ—ãƒ«ã§æ•°å€¤ã‚’ãƒã‚¤ãƒ³ãƒ‰ã™ã‚‹éš›ã«intã«ã‚ãƒ£ã‚¹ãƒˆã—ã¦ã„ã‚‹ç†ç”±
å…ˆæ—¥PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹åŒ—æµ·é“2016ã«ã¦ã€Œã€Žä¾‹ãˆã°ã€PHPã‚’é¿ã‘ã‚‹ã€ä»¥é™PHPã¯ã©ã‚Œã ã‘å®‰å…¨ã«ãªã£ãŸã‹ã€ã¨é¡Œã—ã¦åŸºèª¿è¬›æ¼”ã‚’æ‹…å½“è‡´ã—ã¾ã—ãŸã€‚ãã®éš›ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã¯ã“ã¡ã‚‰ã€‚ ãã†ã—ãŸã¨ã“ã‚ã€ä»¥ä¸‹ã®ã”æŒ‡æ‘˜ã‚’ã„ãŸã ãã¾ã—ãŸã€‚ @ockeghem ã‚¹ãƒ©ã‚¤ãƒ‰æ‹è¦‹ã—ã¾ã—ãŸã€‚39ç•ªç›®ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã™ãŒã€ãƒã‚¤ãƒ³ãƒ‰ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§intã«ã‚ãƒ£ã‚¹ãƒˆã™ã‚‹ã®ã¯ã¡ã‚‡ã£ã¨ä¾‹ã¨ã—ã¦è‰¯ããªã„æ°—ãŒã—ã¾ã™ã€‚æ„å›³çš„ã«ã‚ªãƒ¼ãƒãƒ¼ãƒ•ãƒãƒ¼ã‚’èµ·ã“ã™ã“ã¨ã§æƒ³å®šå¤–ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã®å–å¾—ã‚’è¨±ã—ã¦ã—ã¾ã„ãã†ã§ã™ã€‚ã‚ãƒ£ã‚¹ãƒˆã—ãªã„æ–¹ãŒã¾ã å®‰å…¨ã ã¨æ€ã†ã®ã§ã™ãŒã€‚ SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€intåž‹ã‚ˆã‚Šã‚‚å¤§ããªæ¡æ•°ã‚’æ‰±ãˆã‚‹å ´åˆãŒã‚ã‚‹ã®ã§ã€intã¸ã®ã‚ãƒ£ã‚¹ãƒˆã‚’é¿ã‘ãŸæ–¹ãŒã‚ˆã„ã¨ã„ã†æŒ‡æ‘˜ã¯ä¸€èˆ¬è«–ã¨ã—ã¦ã¯ã‚‚ã£ã¨ã‚‚ãªã‚‚ã®ã ã¨è€ƒãˆã¾ã™ã€‚PHPã®å ´åˆã€9223372036854775807ã‚’è¶Šãˆã‚‹æ•°å—æ–‡å—åˆ—ã‚’intåž‹ã«ã‚ãƒ£ã‚¹ãƒˆã™ã‚‹ã¨ã€9223372036854775807ãŒè¿”ã‚Šã¾ã™(
mas-higa 2016/04/21
PHP ã¨ MySQL ã®ä»•äº‹ã‚’ã—ã¦ãªãã¦æœ¬å½“ã«ã‚ˆã‹ã£ãŸ

php

mysql
ãƒªãƒ³ã‚¯
MySQL ã¨å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
MySQL ã¨ Unicode Collation Algorithm (UCA) - ã‹ã¿ã½ã‚ãƒ¼ã‚‹ ã«é–¢é€£ã™ã‚‹ãƒˆãƒ”ãƒƒã‚¯ã§ã€ MySQL ã«ã¯å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œã¨ã„ã†ã®ãŒã‚ã‚‹ã€‚ å¯¿å¸ãƒ“ãƒ¼ãƒ«å•é¡Œã©ã£ã‹ã§è©³ã—ããŠè©±ã‚’èžãã¹ãã ã‚ˆãªãã€‚ã€‚ã€‚â€” RKajiyama (@RKajiyama) March 18, 2015 ã“ã‚Œã¯ã©ã†ã„ã†å•é¡Œã‹ã¨ã„ã†ã¨ã€ MySQL ã® Unicode ã§ã¯ binary collation ã«ã—ã¦ã‚³ãƒ¼ãƒ‰ãƒã‚¤ãƒ³ãƒˆã§æ¯”è¼ƒã—ãªã„ã¨ðŸ£ã¨ðŸºã«é™ã‚‰ãšçµµæ–‡å—ãŒåŒå€¤åˆ¤å®šã•ã‚Œã‚‹ã¨ã„ã†å•é¡Œã§ã™ã€‚ ã‚ã‚Œï¼Ÿ MySQL ã® utf8mb4 charset ã£ã¦ã€4ãƒã‚¤ãƒˆæ–‡å—åŒå£«ã‚’æ¯”è¼ƒã™ã‚‹ã¨åŒã˜æ–‡å—æ‰±ã„ã•ã‚Œã‚‹ï¼Ÿ SELECT 'ðŸ£'='ðŸº' â†’ 1 MySQLçš„ã«ã¯å¯¿å¸ã¨ãƒ“ãƒ¼ãƒ«ã¯åŒã˜æ‰±ã„ã€‚â€” ã¨ã¿ãŸã¾ã•ã²ã‚ (@tmtms) December 22, 2014 MySQLã§ select
mas-higa 2016/01/12
mysql

sushi

beer

problem
ãƒªãƒ³ã‚¯
ActiveRecordã§binaryåž‹ã‚’blobä»¥å¤–ã®åž‹ã«ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
mas-higa 2013/10/22
"ãã“ã¯ã¡ã‚ƒã‚“ã¨Modelã«Validationå‡¦ç†ã‚’æ›¸ã‹ãªã„ã¨ãƒ€ãƒ¡ã‹ãª" ãã‚Œãªã‚‰ 64kb ã§ validation ã™ã‚Œã°ã‚ˆã‹ã£ãŸã‚“ã˜ã‚ƒâ€¦

rails

mysql

blob
ãƒªãƒ³ã‚¯
pryã‚’MySQLã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®ã‚ˆã†ã«ãƒ†ãƒ¼ãƒ–ãƒ«è¡¨ç¤ºã™ã‚‹ | Act as Professional
pryã¯ã„ã–ã¨ã„ã†ã¨ãã€ä¾¿åˆ©ã ãªã¨æ€ã†@HIROCASTERã§ã”ã–ã„ã¾ã›ã†ã€‚ hirb-unicodeã‚’ä½¿ã£ã¦ã€pryæ“ä½œä¸ã®ActiveRecordã®çµæžœã‚’SQLã®çµæžœã£ã½ãè¡¨ç¤ºã—ã¾ã™ã€‚ é€šå¸¸ã¯ä»¥ä¸‹ã®æ§˜ãªè¡¨ç¤ºã«ãªã‚Šã¾ã™ã€‚ ã¡ã‚‡ã£ã¨ã€ã‚ˆãè¦‹ãªã„ã¨ã‚ã‹ã‚Šã¥ã‚‰ã„ã§ã™ã‚ˆãã€‚ ãã‚ŒãŒ hirb-unicode ã«ã‚ˆã£ã¦ã€ ã“ã®æ§˜ã«ãƒ†ãƒ¼ãƒ–ãƒ«è¡¨ç¤ºã—ã¦ãã‚Œã¾ã™ã€‚ä»¶æ•°ãŒå¤šãã‚ã‚‹ã¨ã€é€šå¸¸é€šã‚Šã®è¡¨ç¤ºã«æ¯”ã¹ã¦ã€ã¨ã¦ã‚‚è¦‹ã‚„ã™ããªã‚Šã¾ã™ã€‚ ã¾ãŸã€æ–‡å—ãŒå¤šãã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã®æ¨ªå¹…ãŒè¶³ã‚‰ãªã‘ã‚Œã°ã€è‡ªå‹•çš„ã« ã“ã®æ§˜ã«è¡¨ç¤ºã—ã¾ã™ã€‚MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹äººã«ã¯ãŠãªã˜ã¿ã®è¡¨ç¤ºã§ã™ã€‚ å°Žå…¥æ–¹æ³• pryã‚„pry-raisã‚’å°Žå…¥ã—ã¦ã„ã‚‹ã“ã¨ã‚’å‰æã¨ã—ã¾ã™ã€‚ Gemfileã« gem 'hirb-unicode' ã¨ã€è¨˜è¿°ã—ã¦ã€ $ bundle install ãªã©ã‚’ã—ã¦gemã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ æ¬¡ã« .pryrc ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã—
mas-higa 2013/03/01
Struct ã¨ã‹ Hash ã® Array ã‚’æ¸¡ã™ã¨é©å½“ã«æ•´å½¢ã—ã¦å‡ºåŠ›ã—ã¦ãã‚Œã‚‹ gem ã¨ã‹ã‚ã‚‹ã‚“ã§ã™ã‹ãã€‚

pry

mysql
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
mas-higa 2012/12/11
RDBMS

postgresql

mysql
ãƒªãƒ³ã‚¯
FOSS License Exception
MySQLã«ã¯FOSS License Exceptionã¨ã„ã†åˆ¶åº¦ãŒã‚ã‚‹ã€‚ãã®ã‚ˆã†ãªåˆ¶åº¦ãŒã‚ã‚‹ã“ã¨ã¯ã‚ã¾ã‚ŠçŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã—ã€åå‰ã‚’çŸ¥ã£ã¦ã„ã¦ã‚‚å†…å®¹ã¯ã‚ˆãçŸ¥ã‚‰ãªã„ã€ã¾ãŸã¯èª¤è§£ã—ã¦ã„ã‚‹ã¨ã„ã†äººãŒçµæ§‹å±…ã‚‹ã€‚ãã“ã§ã€FOSS License Exceptionã«ã¤ã„ã¦æ”¹ã‚ã¦ã“ã“ã§ç´¹ä»‹ã—ãŸã„ã€‚ MySQL FOSS License Exception http://www.mysql.com/about/legal/licensing/foss-exception/ çŸ¥ã£ã¦ã®é€šã‚Šã€MySQLã¯ãƒ‡ãƒ¥ã‚¢ãƒ«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã ã€‚ç„¡æ–™ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹MySQL Community Serverã¯GPLv2ã§ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ãŠã‚Šã€ãã®ä»–ã«æœ‰æ–™ã®ã‚³ãƒžãƒ¼ã‚·ãƒ£ãƒ«ãƒ»ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ç‰ˆãŒå˜åœ¨ã™ã‚‹ã€‚ã‚³ãƒžãƒ¼ã‚·ãƒ£ãƒ«ãƒ»ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ç‰ˆã¯ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’å…¬é–‹ã—ãŸããªã„ãƒ¦ãƒ¼ã‚¶ãƒ¼å‘ã‘ã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§ã€ä¿—ã«OEMç‰ˆã¨ã‚‚å‘¼ã°ã‚Œã‚‹ã€‚ ã•ã¦ã€FOSS Lice
mas-higa 2012/10/09
ã‚¯ãƒãƒ¼ã‚ºãƒ‰ã«ã—ãŸã‘ã‚Œã°é‡‘æ‰•ãˆ

mysql

license
ãƒªãƒ³ã‚¯
1