[B! DB] ymgnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ymgn id:ymgn

DBã«é–¢ã™ã‚‹ymgnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

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

DB

DDD

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
MySQLã®FLOATåž‹ã‚’ä½¿ã†ç†ç”±ãŒè¦‹ã¤ã‹ã‚‰ãªã„ä»¶ - hnwã®æ—¥è¨˜
MySQLã®ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦FLOATåž‹ã¨ã„ã†åž‹ãŒã‚ã‚‹ã®ã§ã™ãŒã€ã“ã‚Œã‚’æŽ¡ç”¨ã™ã‚‹ã®ã¯æ··ä¹±ã®å…ƒã§ã¯ãªã„ã‹ï¼Ÿã¨æ„Ÿã˜ãŸã®ã§ã€ãã®è©³ç´°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãã‚‚ãã‚‚ã“ã®è©±ã®ãã£ã‹ã‘ã¯ã€ŒMySQLã§6æ¡ã¾ã§ã®å°æ•°ç‚¹ã‚’ä¸¸ã‚ãšã«æ‰±ã†ãªã‚‰FLOATåž‹ã‚’ä½¿ã†ã¹ãç†ç”±ã€ã¨ã„ã†è¨˜äº‹ãŒç›®ã«æ¢ã¾ã£ãŸã“ã¨ã§ã™ã€‚ãã‚Œãªã‚Šã«äººæ°—ã‚’é›†ã‚ã¦ã„ã‚‹è¨˜äº‹ã®ã‚ˆã†ã§ã™ãŒã€ç§ã®èªã‚“ã é™ã‚Šã§ã¯FLOATåž‹ã‚’ä½¿ã†ã ã‘ã®æ ¹æ‹ ãŒæ–‡ä¸ã‹ã‚‰èªã¿å–ã‚Œãšã€ã•ã‚‰ã«é¡žä¼¼ã™ã‚‹ä¸€æ¬¡æƒ…å ±ã‚„è‹±èªžè¨˜äº‹ãŒå…¨ãè¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€çœŸå½ãŒæ€ªã—ã„æƒ…å ±ã ã¨æ„Ÿã˜ã¾ã—ãŸã€‚ ãã®å¾Œã€MySQLä¸Šã§å®Ÿé¨“ã—ãŸã‚ŠCã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ãŸã‚Šã—ãŸçµæžœã€ç§ã®å¾—ãŸçµè«–ã¯çœŸé€†ã®ã‚‚ã®ã«ãªã‚Šã¾ã—ãŸã€‚MySQLè¦å¯Ÿã®æ–¹ã‚„æµ®å‹•å°æ•°ç‚¹æ•°è¦å¯Ÿã®æ–¹ã€è¿½è©¦ã‚„åè«–ãªã©é ‚ã‘ã‚‹ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚ MySQLã®FLOATåž‹ã¨ã¯ MySQLã®FLOATåž‹ã¯åŽŸå‰‡ã¨ã—ã¦IEEE754æµ®å‹•å°æ•°ç‚¹æ•°å˜ç²¾åº¦åž‹ï¼ˆ32bitï¼‰ã§å®Ÿç¾ã•ã‚Œã¾ã™*1ã€‚
ymgn 2020/03/03
MySQL

FLOAT

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

MySQL

æµ®å‹•å°æ•°ç‚¹æ•°
ãƒªãƒ³ã‚¯
å›ã¯çŸ¥ã£ã¦ã„ã‚‹ã‹SequelProã®ä¾¿åˆ©ãªæ©Ÿèƒ½ - Qiita
ã¯ã˜ã‚ã« æœ€è¿‘ã€è‡ªå®…ã«å¸°ã£ã¦ã‹ã‚‰SequelProã‚’è§¦ã‚‹ã‚ˆã†ã«ãªã‚Šã€ãã“ã§æ°—ã¥ã„ãŸå°æŠ€ã‚„åˆã‚ã¦ä½¿ã£ãŸæ©Ÿèƒ½ã‚’åŒæœŸã«å…±æœ‰ã—ãŸã¨ã“ã‚çµ¶è³›ã—ã¦ãã‚ŒãŸã®ã§ã€ã›ã£ã‹ããªã®ã§è¨˜äº‹ã«ã—ã‚ˆã†ã¨æ€ã„ã¾ã—ãŸã€‚ SequelProã¨ã¯ Mysqlã®DBã‚’ç¢ºèªã§ãã‚‹Macç”¨ã®GUIã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã™ã€‚Mysqlã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®ä¸ã§ã©ã‚Œãã‚‰ã„ã®ã‚·ã‚§ã‚¢çŽ‡ãŒã‚ã‚‹ã‹ã¾ã§ã¯ã‚ã‹ã‚‰ãªã„ã§ã™ãŒå¿…è¦ãªæ©Ÿèƒ½ã¯ä¸€é€šã‚Šæƒã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ ãªãŠç¾åœ¨ã®æ£å¼ç‰ˆãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯1.1.2ã§ã‚ã‚Šã€ã“ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯æœ€æ–°OSãªã©ã§é »ç¹ã«ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã™ã‚‹å ±å‘ŠãŒå¤šæ•°ã‚ã‚Šã€ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã‚‚2016å¹´ã‹ã‚‰æ¢ã¾ã£ã¦ã„ã¾ã™ã€‚æ£å¼ç‰ˆã§ã¯ãªããƒ†ã‚¹ãƒˆãƒ“ãƒ«ãƒ‰ç‰ˆã‚’ä½¿ã†ã“ã¨ã§ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚’å›žé¿ã™ã‚‹ã“ã¨ãŒã§ãã€æœ€æ–°ã®ãƒ†ã‚¹ãƒˆãƒ“ãƒ«ãƒ‰ç‰ˆã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã¯7ãƒ¶æœˆå‰ã¨ãªã£ã¦ã„ã‚‹ãŸã‚ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã«æ‚©ã‚€äººã¯ç§»è¡Œã™ã‚‹ã®ã‚‚ã‚ã‚Šã ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯ã©ã¡ã‚‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚‚ä½¿ç”¨å¯èƒ½ãªã‚‚ã®ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚
ymgn 2020/02/06
ã—ã‚‰ãªã‹ã£ãŸã€€ã‚«ãƒ©ãƒ åã§ãƒ†ãƒ¼ãƒ–ãƒ«åæ¤œç´¢ã¨ã‹ã€€è¤‡æ•°æ¡ä»¶æ¤œç´¢ã¨ã‹ã‚ã£ã¡ã‚ƒä¾¿åˆ©ã˜ã‚ƒã‚“

DB

mac
ãƒªãƒ³ã‚¯
ã€Spring Data JPAã€‘è‡ªå‹•å®Ÿè£…ã•ã‚Œã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ã®å‘½åãƒ«ãƒ¼ãƒ« - Qiita
Spring Data JPAã«ã¯ã€Repositoryã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã«å®£è¨€ã•ã‚ŒãŸãƒ¡ã‚½ãƒƒãƒ‰ã‚’ã€ãã®åå‰ã‹ã‚‰ã‚¯ã‚¨ãƒªã‚’ç”Ÿæˆã—ã¦è‡ªå‹•çš„ã«ç”Ÿæˆã—ã¦ãã‚Œã‚‹ãŠä¾¿åˆ©æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ã©ã‚“ãªå‘½åè¦å‰‡ãŒã‚ã‚‹ã®ã‹åˆ†ã‹ã‚‰ãªã‹ã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ åŸºæœ¬çš„ã«ã¯ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã®è¦ç´„ã§ã™ã€‚ ç’°å¢ƒ Java ãƒ»ãƒ»ãƒ» jdk1.8 Spring Boot ãƒ»ãƒ»ãƒ» 1.3.5-RELEASE DB ãƒ»ãƒ»ãƒ» MySQL 5.7 æ§‹æ–‡ ä»¥ä¸‹ã®ï¼“ã¤ã®è¦ç´ ã‚’è¦å‰‡ã«å¾“ã£ã¦çµ„ã¿åˆã‚ã›ãŸãƒ¡ã‚½ãƒƒãƒ‰åã‚’Repositoryã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã«å®£è¨€ã™ã‚‹ã“ã¨ã§ã€è‡ªå‹•å®Ÿè£…ãŒåˆ©ç”¨å¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ ãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ï¼ˆfind...By read...By query...By count...By get...Byï¼‰ ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’ä¾‹ã«ä½¿ã„ã¾ã™ã€‚ @Entity public class Employee implements Ser
ymgn 2019/01/11
DDDãªã©ã®Repositoryã‚’ä½œã‚‹å ´åˆã®å‘½åã«ã‚‚åˆ©ç”¨ã§ããã†ã§è‰¯ã„

spring

å‘½å

Qiita

SpringBoot

DB

java
ãƒªãƒ³ã‚¯
ã‚¤ãƒŸãƒ¥ãƒ¼ã‚¿ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¨ webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹ç¾å®Ÿè§£ - Qiita
ã“ã‚Œã¯ç¬¬2ã®ãƒ‰ãƒ¯ãƒ³ã‚´ Advent Calendar 2017ã®5æ—¥ç›®ã§ã™ 5æ—¥11æ™‚æ™‚ç‚¹ã§2æ—¥æ‹…å½“ã® yonex ãŒã¾ã è¨˜äº‹æ›¸ã„ã¦ãªã„ã§ã™ãŒã€æ°—ã«ã›ãšç¶šã‘ã¾ã™ã€‚niconico(ã)ã®ãƒªãƒªãƒ¼ã‚¹ãŒæ¥å¹´ã¨èžã„ã¦æ®‹å¿µãªæ°—æŒã¡ã§ã™ã€‚ ãŠã‚ãƒ¼èª°ã‚ˆï¼Ÿ ãƒ‰ãƒ¯ãƒ³ã‚´ Advent Calendarçš†å‹¤è³žã£ã½ã„ã§ã™ãŒã€ç§ã¯ãƒ‰ãƒ¯ãƒ³ã‚´ç¤¾å“¡ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ å®šå¹´ã‚’ã¨ã†ã«éŽãŽãŸãŠã˜ã•ã‚“ã§ã™ã€‚ å‰ç½®ã web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºã«ãŠã„ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã¯ã¨ã¦ã‚‚é‡è¦ã§ã™ã€‚ SIerã§ã¯DBAã¨ã‹è¨€ã£ã¦å°‚é–€ã®è¨è¨ˆæ‹…å½“ãŒã„ã‚‹ã¿ãŸã„ã§ã™ãŒã€ä¸å°webã‚µãƒ¼ãƒ“ã‚¹ä¼æ¥ã§ãã“ã¾ã§ã®åˆ†æ¥ãŒã§ãã‚‹ã‚ã‘ã‚‚ãªãã€å¤§ä½“ã«ãŠã„ã¦webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³(ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰)ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæ‹…å½“ã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ã‚¤ãƒŸãƒ¥ãƒ¼ã‚¿ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« è©³ç´°ã¯ãƒªãƒ³ã‚¯ã«è²ã‚Šã¾ã™ãŒã€ã€Œå±¥æ´ã‚’å…¨ã¦æ®‹ã™ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿è¨è¨ˆã«ã—ã€ UPDATE ã‚’å»ƒã™ã‚‹ã“ã¨ã§æƒ…å ±ã®è¿½è·¡å¯èƒ½æ€§
ymgn 2017/12/06
ã‚ã¨ã§èªã‚€

Web

DB
ãƒªãƒ³ã‚¯
1