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

mactkg id:mactkg

mysqlã«é–¢ã™ã‚‹mactkgã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ç‰‡æ‰‹é–“MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æˆ¦ç•¥
Convert to study materialsBETATransf orm any presentation into ready-made study materialâ€”select from outputs like summaries, definitions, and practice questions. Convert
mactkg 2017/10/09
mysql
ãƒªãƒ³ã‚¯
æ–°æ©Ÿèƒ½ãŒã‚µãƒ¼ãƒ“ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«æ‚ªå½±éŸ¿ã‚’ä¸Žãˆãªã„ã‹ç´ æ—©ãæŽ¨å®šã™ã‚‹ - Hatena Developer Blog
ã“ã‚“ã«ã¡ã¯ã€ id:shiba_yu36 ã§ã™ã€‚ å…ˆæ—¥ã€æ–°ã—ã„æ©Ÿèƒ½ã‚„æ”¹å–„ã‚’åŠ ãˆã‚ˆã†ã¨ã™ã‚‹æ™‚ã«ã€ãã‚ŒãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦æ‚ªå½±éŸ¿ã‚’åŠã¼ã•ãªã„ã‹ã€ã©ã®ã‚ˆã†ã«æ¤œè¨¼ã™ã‚Œã°è‰¯ã„ã§ã™ã‹ã¨ã„ã†ç›¸è«‡ã‚’å—ã‘ã¾ã—ãŸã€‚ã¤ã¾ã‚Šã€æ–°ã—ãä½œã£ãŸæ©Ÿèƒ½ã‚’å°Žå…¥ã—ãŸçž¬é–“ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒé«˜è² è·ã«ãªã‚Šã‚µãƒ¼ãƒ“ã‚¹å…¨ä½“ã«å½±éŸ¿ã‚’ä¸ŽãˆãŸã‚Šã—ãªã„ã‹ä¸å®‰ã§ã‚ã‚‹ã¨ã„ã†ç›¸è«‡ã§ã™ã€‚ãã®ç›¸è«‡ã«å¯¾ã—ã¦åƒ•ã¯ã€ç°¡å˜ãªè¨ˆç®—å¼ã‚’ä½œã‚Šã€ãã®æ©Ÿèƒ½ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®å½±éŸ¿åº¦ã‚’ã–ã£ãã‚ŠæŽ¨å®šã™ã‚‹ã“ã¨ã§ã€ãƒªãƒªãƒ¼ã‚¹å‰ã«æ™‚é–“ã‚’ã‹ã‘ãšã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«æ‚ªå½±éŸ¿ã‚’ä¸Žãˆãªã„ã‹æŽ¨å®šã§ãã‚‹ã¨ã„ã†è©±ã‚’ã—ã¾ã—ãŸã€‚ ã“ã®è©±ã‚’ã—ã¦ã„ã¦ã€ã€Œãƒªãƒªãƒ¼ã‚¹ã™ã‚‹å‰ã«æ–°æ©Ÿèƒ½ã‚„æ”¹å–„ãŒã‚µãƒ¼ãƒ“ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«æ‚ªå½±éŸ¿ã‚’ä¸Žãˆãªã„ã‹ç´ æ—©ãæŽ¨å®šã™ã‚‹ã€ã“ã¨ã¯ã€çµŒé¨“ã®ã‚ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯è‡ªç„¶ã¨ã‚„ã£ã¦ã„ã‚‹ã‘ã‚Œã©ã€ã‚ã¾ã‚Šãƒ–ãƒã‚°ãªã©ã§è¨€èªžåŒ–ã•ã‚Œã¦ã„ãªã„ã¨æ„Ÿã˜ã¾ã—ãŸã€‚ãã“ã§ã€ä»Šå›žã¯ã“ã®ã“ã¨ã«ã¤ã„ã¦ãƒ–ãƒã‚°ã«æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ãªãœæ©Ÿèƒ½ã‚’ãƒªãƒªãƒ¼
mactkg 2017/03/23
ã‚ã¨ã§èªã‚€

db

mysql

hatena

performance
ãƒªãƒ³ã‚¯
Wagon
Weâ€™re excited to share that the Wagon team will be joining the Box family! We are thrilled to bring our data analytics and insights expertise to the Box enterprise platform. Wagon and Box believe that shared knowledge empowers individuals and unites teams. Box helps enterprises do more with their content and get their work done faster by acting as the central, modern content platform. Fortune 500
mactkg 2016/08/21
ä¾¿åˆ©ãã†

mysql

visualization
ãƒªãƒ³ã‚¯
Redirecting to https://sqlpad.github.io/sqlpad/#/
mactkg 2015/12/14
mysql

SQL

node
ãƒªãƒ³ã‚¯
äºŒåƒä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®alterã‚’ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¢ã‚ãšã«æµã™ | All Your Bugs Are Belong To Ass
â€»ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯MySQL Casual Advent Calendar 2015ã®5æ—¥ç›®ã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ openark-kit ã¨ã„ã†ã‚‚ã®ã«ã¤ã„ã¦ ã“ã“ã¾ã§èªã‚“ã§ã‚ã‹ã£ãŸæ–¹ã¯ã€ã“ã®å…ˆã‚’èªã‚€å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ openark-kitã¨ã¯ã€mysqlã®é‹ç”¨ã«ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã‚ãƒƒãƒˆã‚’14å€‹ã‚ã¤ã‚ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã™ã€‚ Shlomi Noachã¨ã„ã†æ–¹ãŒPythonã§é–‹ç™ºã—ã¦ãŠã‚Šã€å°‘ãªãã¨ã‚‚2009å¹´ã«ç™ºè¡¨ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ 2015-12-05æ™‚ç‚¹ã§ã®æœ€æ–°ç‰ˆã¯196.1ã¨ãªã£ã¦ãŠã‚Šã€.tar.gz ãŠã‚ˆã³ .deb ã§é…å¸ƒã•ã‚Œã¦ãŠã‚Šã¾ã™ã€‚ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ãŸèƒŒæ™¯äº‹æƒ… ãã‚‚ãã‚‚åƒ•è‡ªèº«ã€50ã‚’è¶…ãˆã‚‹ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã•ã‚ŒãŸmysqlãƒŽãƒ¼ãƒ‰ã¨ä¸€ç·’ã«æ¥å‹™ç”Ÿæ´»ã‚’é€ã£ã¦ãŠã‚Šã¾ã™ã€‚ ã¨ã“ã‚ãŒã€ã‚·ã‚¹ãƒ†ãƒ ãŒéžå¸¸ã«å¤ãã•ã„æ§‹æˆã®ãŸã‚ã€åˆè¨ˆãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒ2å„„ã‹ã‚‰3å„„ç¨‹åº¦ã‚ã‚‹åž‚ç›´åˆ†å‰²ã•ã‚ŒãŸãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ALTERã‚’æŠ•
mactkg 2015/12/06
tips

mysql
ãƒªãƒ³ã‚¯
O/Rãƒžãƒƒãƒ‘ãƒ¼ã«ã‚ˆã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã‚’æœªç„¶ã«é˜²ã
2. copyright Â© 2014 kuwata-lab.com all rights reserved ã¾ãˆãŒã ç¾åœ¨ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã®ç¾å ´ã§ã¯ O/R Mapper (ORM) ãŒæ™®åŠã—ã¦ã„ã¾ã™ã€‚ä»Šå¾Œ ã‚‚ ORM ã‚’ä½¿ã£ãŸé–‹ç™ºã¯ã€å¢—ãˆã‚‹ã“ã¨ã¯ã‚ã£ã¦ã‚‚æ¸›ã‚‹ã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã— ORM ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºè€…ã«ã¨ã£ã¦ã¯ä¾¿åˆ©ã§ã‚‚ã€DB ç®¡ç†è€… (DBA) ã‹ ã‚‰ã¿ãŸã‚‰ãƒˆãƒ©ãƒ–ãƒ«ã®ç¨®ã§ã‚‚ã‚ã‚Šã¾ã™ã€‚ãã‚ŒãŒç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹å•é¡Œã§ã‚ã‚‹ã“ ã¨ãŒå¤šã„ãŸã‚ã€é–‹ç™ºè€…ã¨ DBA ãŒå¯¾ç«‹ã™ã‚‹ã“ã¨ã‚‚çã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ ã¨ã¯ã„ãˆã€ORM ã«ã‚ˆã‚‹å•é¡Œã¯ã™ã§ã«è§£æ±ºç–ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚æœ¬å½“ã® å•é¡Œã¯ã€ã™ã§ã«å˜åœ¨ã™ã‚‹è§£æ±ºç–ãŒã‚ã¾ã‚ŠçŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã“ã¨ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ãã“ã§æœ¬ç™ºè¡¨ã§ã¯ã€ORM ã«ã‚ˆã£ã¦ã©ã®ã‚ˆã†ãªå•é¡ŒãŒèµ·ã“ã‚Šã‚„ã™ã„ã‹ã€ã©ã†è§£æ±ºãƒ»äºˆé˜² ã™ã‚Œã°ã„ã„ã‹ã€ãã—ã¦ ORM
mactkg 2014/12/23
mysql

db
ãƒªãƒ³ã‚¯
Auto Incrementã§ãªã„Primary Keyåˆ—ã‚’ä½œã‚ŠãŸã„ - ãƒŽãƒ¼ãƒˆãŒã‚ã‚Š
Railsã ã¨primary keyã®åˆ—ã«ã¯auto incrementãŒã¤ã„ã¡ã‚ƒã„ã¾ã™ãŒ auto incrementãªã—ã®primary keyåˆ—ãŒæ¬²ã—ã„æ™‚ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ã—ã¦ä½œã‚Œã¾ã—ãŸ http://stackoverflow.com/questions/1585323/how-to-turn-off-auto-increment-in-rails-active-recordã‚ˆã‚Š class CreateUsers < ActiveRecord::Migration def self.up create_table :users, :id=>false do |t| t.column :uid, "int(11) PRIMARY KEY" t.timestamps end end def self.down drop_table :users end end ãŸã ã—schema.rbã‚’
mactkg 2014/03/15
mysql

db
ãƒªãƒ³ã‚¯
1