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

kathew id:kathew

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

${{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] UPDATEã§æ™‚é–“ã‚’åŠ ç®—ãƒ»æ¸›ç®—ã™ã‚‹ | ãã»ã‚“ã®ã
MySQLã§Datetimeåž‹ã‚«ãƒ©ãƒ ã«è¨˜éŒ²ã•ã‚ŒãŸæ—¥æ™‚ã‚’UPDATEæ–‡ã§å¤‰æ›´ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã®è§£èª¬ã§ã™ã€‚ ã‚«ãƒ©ãƒ ã«â€2013-07-01 00:00:00â€³ã¨è¨˜éŒ²ã•ã‚Œã¦ã„ãŸã¨ã—ã¾ã™ã€‚ã“ã‚Œã‚’1æ™‚é–“å‰ã«ä¿®æ£ã™ã‚‹å ´åˆã¯ä»¥ä¸‹ã®SQLæ–‡ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ UPDATE table_name SET 'target_column' = (`target_column` - INTERVAL 1 HOUR); ã“ã‚Œã§ã€å…¨ã¦ã®target_columnã«è¨˜éŒ²ã•ã‚Œã¦ã„ãŸæ™‚é–“ãŒã€1æ™‚é–“å‰ã«å¤‰æ›´ã•ã‚Œã¾ã™ã€‚ä¸Šè¨˜ã®ä¾‹ã§ã¯â€2013-07-01 00:00:00â€³ã¯â€2013-06-30 23:00:00â€³ã«å¤‰æ›´ã•ã‚Œã¾ã™ã€‚1æ™‚é–“å¾Œã«å¤‰æ›´ã™ã‚‹å ´åˆã¯(`target_column` - INTERVAL 1 HOUR)ã®-ã‚’+ã«å¤‰ãˆã¾ã™ã€‚ ä»¥ä¸‹ã¯æ™‚é–“ä»¥å¤–ã®ã€ç§’å˜ä½ã‚„æ—¥å˜ä½ã®æ™‚é–“å¤‰æ›´ã«ã¤ã„ã¦ã®ä¾‹ã§ã™ã€‚ UPDATE table_
kathew 2024/07/01
mysql

db
ãƒªãƒ³ã‚¯
MySQLã§ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚’UUIDã«ã™ã‚‹å‰ã«çŸ¥ã£ã¦ãŠã„ã¦æ¬²ã—ã„ã“ã¨ | Raccoon Tech Blog [æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ æŠ€è¡“æˆ¦ç•¥éƒ¨ãƒ–ãƒã‚°]
æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢/ãƒ‡ã‚¶ã‚¤ãƒŠãƒ¼ã‹ã‚‰æŠ€è¡“æƒ…å ±ã‚’ã¯ã˜ã‚ã€ä¸–ã®ä¸ã®ãŸã‚ã«ãªã‚‹ã“ã¨ã‚„ç¤¾å†…ã®ã“ã¨ãªã©ã‚’ç™ºä¿¡ã—ã¦ã¾ã™ã€‚ bashãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQLInnoDB DBè¨è¨ˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã“ã‚“ã«ã¡ã¯ã€ç¾½å±±ã§ã™ã€‚ ä»Šå›žã¯ MySQL ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã« UUID ã‚’æŽ¡ç”¨ã™ã‚‹å ´åˆã«èµ·ãã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å•é¡Œã‚’ä»•çµ„ã¿ã‹ã‚‰è§£èª¬ã—ã¾ã™ã€‚ MySQL(InnoDB) & UUID ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¤ã„ã¦ã¯å„æ‰€ã§ã•ã‚“ã–ã‚“è°è«–ãƒ»æ¤œè¨¼ã•ã‚Œã¦ã„ã¾ã™ãŒã€è«–ç†çš„ã«è§£èª¬ã—ãŸè¨˜äº‹ãŒå°‘ãªã‹ã£ãŸã‚Šä¸€éƒ¨ã«ã¯èª¤è§£ã‚’æ‹›ãã‚ˆã†ãªã‚‚ã®ã‚‚ã‚ã‚‹ãŸã‚ã€ã—ã£ã‹ã‚Šã¨ç†ç”±ã‹ã‚‰ç†è§£ã™ã‚‹ãŸã‚ã®æƒ…å ±ã¨ã—ã¦å½¹ç«‹ã¤ã“ã¨ãŒã§ãã‚Œã°ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ UUID ã¨æ¯”è¼ƒã•ã‚Œã‚‹å¤ãè‰¯ãæ˜‡é †/é™é †ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã¯ã¨ã„ã†ã¨ã€ MySQL ã® InnoDB ã«ãŠã„ã¦è‰¯ã„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‡ºã™ãŸã‚ã«ç¸ã®ä¸‹ã®åŠ›æŒã¡ã®ã‚ˆã†ãªåƒãã‚’ã—ã¦ãã‚Œã¦ã„ã‚‹ã‚±ãƒ¼ã‚¹ãŒå®Ÿã¯å°‘ãª
kathew 2021/09/01
mysql

performance

db
ãƒªãƒ³ã‚¯
ç¤¾å†…SQLç ”ä¿®ã®ãŸã‚ã«ä½œã£ãŸè³‡æ–™ã‚’å…¬é–‹ã—ã¾ã™ | æ ªå¼ä¼šç¤¾AI Shift
ã“ã‚“ã«ã¡ã¯ã€Development Teamã®ä¸‰å®…ã§ã™ã€‚ å…ˆæ—¥ã€ç¤¾å†…ï¼ˆAIäº‹æ¥æœ¬éƒ¨å†…ï¼‰ã§SQLç ”ä¿®ã®è¬›å¸«ã‚’æ‹…å½“ã—ãŸã®ã§ã€ä»Šå›žã¯ãã®å†…å®¹ã«ã¤ã„ã¦ç°¡å˜ã«å…±æœ‰ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ä¾‹å¹´ã€AIäº‹æ¥æœ¬éƒ¨ã§ã¯ã€æ–°å’ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®è‚²æˆã®ãŸã‚ã«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ç ”ä¿®ã‚’è¡Œã£ã¦ãŠã‚Šã¾ã™ã€‚ä»Šå¹´ã¯ãƒ•ãƒ«ãƒªãƒ¢ãƒ¼ãƒˆã§ã®å®Ÿæ–½ã¨ãªã‚Šã¾ã—ãŸã€‚ç ”ä¿®æœŸé–“ã¯2é€±é–“ã»ã©ã§ã€å†…å®¹ã¯å‰åŠãŒè¬›ç¾©ã€å¾ŒåŠãŒå®Ÿè·µï¼ˆãƒãƒ¼ãƒ é–‹ç™ºï¼‰ã§ã—ãŸã€‚ç§ãŒæ‹…å½“ã—ãŸã®ã¯ã€è¬›ç¾©ãƒ‘ãƒ¼ãƒˆã®ä¸€éƒ¨ã§ã‚ã‚‹SQLç ”ä¿®ã§ã™ã€‚SQLã‚„RDBã«ã‚ã¾ã‚Šæ…£ã‚Œã¦ã„ãªã„äººã§ã‚‚ã€ã§ãã‚‹ã ã‘ä½“ç³»çš„ãªå¦ã³ãŒå¾—ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã™ã‚‹ã“ã¨ã‚’ç›®æ¨™ã«ã€æ§˜ã€…ãªè³‡æ–™ã‚’ã¾ã¨ã‚ã¦æä¾›ã™ã‚‹æ–¹é‡ã§æº–å‚™ã—ã¾ã—ãŸã€‚çµæžœçš„ã«ã¯ã€ãƒãƒ³ã‚ºã‚ªãƒ³è¾¼ã¿ã§4æ™‚é–“ã»ã©ã®ã‚„ã‚„é•·ã„è¬›ç¾©ã¨ãªã‚Šã¾ã—ãŸãŒã€å‹‰å¼·ã«ãªã£ãŸã¨ã„ã†å£°ã‚‚é ‚ã‘ãŸã®ã§ã‚„ã£ã¦è‰¯ã‹ã£ãŸã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ç ”ä¿®è³‡æ–™ ç ”ä¿®å†…å®¹ SQLç ”ä¿®ã®å†…å®¹ã¯ã€åŸºæœ¬çš„ã«ã¯å¤§å¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¬›ç¾©ã§
kathew 2021/06/22
sql

db

education
ãƒªãƒ³ã‚¯
SQLãŒé‡ã„ã¨ãã«è¦‹ã‚‹ãŠæ°—è»½ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³•
SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³• æ˜”Qiitaã§æ›¸ã„ãŸã‚‚ã®ã‚’zennã«ã†ã¤ã—ã¦ã€è‹¥å¹²ã®ä¿®æ£ã€è¿½åŠ ã‚’ã—ã¦ã¿ã¾ã—ãŸã€‚ ORACLEã§ã®çµŒé¨“ã‚’å…ƒã«æ›¸ã„ã¦ã„ã¾ã™ãŒã‚³ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ã¹ãƒ¼ã‚¹ãªã‚‰å¤§ä½“å…±é€šã®è€ƒãˆæ–¹ã ã¨æ€ã†ã®ã§ä»–ã«ã‚‚ä½¿ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚ SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã„ãˆã°æ¯”è¼ƒçš„å®¹æ˜“ã«æ¸ˆã‚€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¨ã‚Šã‚ãˆãšä½œæˆã™ã‚‹ã€‚ã¨ã„ã£ãŸå¯¾å¿œã‚’å–ã‚‰ã‚ŒãŒã¡ã§ã™ãŒã€æ•°ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ç¨‹åº¦ã§ã®ãƒ‡ãƒ¼ã‚¿é‡ã§ã¯ã‚ã¾ã‚ŠåŠ¹ãç›®ãŒãªãï¼ˆè‡ªåˆ†ã®çµŒé¨“å‰‡ï¼‰ã€ã©ã¡ã‚‰ã‹ã¨ã„ãˆã°ã€çµåˆé †ãŒå¤§å¹…ã«ç‹‚ã£ã¦ãŸã‚Šã™ã‚‹ã“ã¨ãŒåŽŸå› ã®ã“ã¨ãŒå¤šã‹ã£ãŸã‚Šã—ã¾ã™ã€‚ã‚ˆã£ã¦æœ¬å½“ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒãªã„ã“ã¨ãŒåŽŸå› ãªã®ã‹ï¼Ÿã‚’ç†Ÿè€ƒã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ï¼ˆä¾‹ãˆã°IDä»¥å¤–ã®ãƒ•ãƒ©ã‚°ã¨ã‹ã‚³ãƒ¼ãƒ‰ã«å˜é …ç›®indexã‚’è²¼ã£ã¦ã‚‹ã®ã‚‚ã¿ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚æ€–ã„ã‘ã©å®Ÿè©±ï¼‰ ã¾ãŸã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚Šã™ãŽã‚‹ã¨ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãŒç‹‚ã„ã‚„ã™ããªã£ã¦ä»–ã®SQLã«ã‚‚æ‚ªå½±éŸ¿ã‚’åŠã¼ã—ãŸã‚Šã™ã‚‹ã®ã§çµæ§‹ç†Ÿæ…®ã—ã¦è¿½åŠ
kathew 2021/05/09
sql

performance

db

tips
ãƒªãƒ³ã‚¯
ã€Laravelã€‘ãƒãƒ«ã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã‚’è¡Œã†æ–¹æ³• - Qiita
Laravelã§ã€è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ãŸã„ã‚±ãƒ¼ã‚¹ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ é€šå¸¸è€ƒãˆã‚‰ã‚Œã‚‹ã®ã¯ã€foreachã§ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’1ã¤ãšã¤ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã™ã‚‹æ–¹æ³•ã ã¨æ€ã„ã¾ã™ã€‚ ä»–ã«ã‚‚save()ãƒ¡ã‚½ãƒƒãƒ‰ã‚„SQLã‚’ä½¿ã†æ–¹æ³•ãªã©ãŒã‚ã‚‹ã®ã§ã€ãã‚Œãžã‚Œã®ä½¿ã„é“ã«ã¤ã„ã¦ã€ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ update()ã®ä½¿ã„é“ ä¸€ç•ªä¸€èˆ¬çš„ãªæ–¹æ³•ã ã¨æ€ã„ã¾ã™ã€‚ activeã‚«ãƒ©ãƒ ãŒ1ã®ãƒ¬ã‚³ãƒ¼ãƒ‰å…¨ã¦ã®delayedã‚’1ã«ã™ã‚‹ã¨ã„ã†ã‚³ãƒ¼ãƒ‰ã§ã™ã€‚ ã“ã®æ–¹æ³•ãªã‚‰ã€App\Flight::all()->update(xxx)ã¨ã™ã‚‹ã“ã¨ã§ã€Flightãƒ¢ãƒ‡ãƒ«ã®å…¨ã¦ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å¯¾ã—ã¦ã€æ›´æ–°ã‚’ã‹ã‘ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãŸã ã€ID:1ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã¯delayedã‚’2ã«ã—ã¦ã€ID:2ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã®delayedã‚’3ã«ã™ã‚‹ã€ã¨ã„ã†ã‚ˆã†ãªãƒ¬ã‚³ãƒ¼ãƒ‰ã«ã‚ˆã£ã¦æ›´æ–°ã—ãŸã„å€¤ãŒé•ã†å ´åˆã¯ã€update()ã‚³ãƒžãƒ³ãƒ‰ã§ã¯å¯¾å¿œã§ãã¾ã›ã‚“ã€‚ foreach + sav
kathew 2021/03/08
laravel

DB
ãƒªãƒ³ã‚¯
laravel migration æ—¢å˜ã‚«ãƒ©ãƒ ã®é †åºå¤‰æ›´æ–¹æ³•ã‚’çŸ¥ã‚ŠãŸã„
ä»Šã™ã§ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã€Œhogesã€ã‚’ä½œæˆã—çµ‚ã‚ã£ã¦ã„ã¦ ãã®ä¸ã®ã‚«ãƒ©ãƒ ã®ä½ç½®ã‚’å¤‰æ›´ã—ãŸã„ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒ ãªã‹ãªã‹åæ˜ ã•ã‚Œãšã”æ•™ç¤ºã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã”ã–ã„ã¾ã™ã€‚ ç¾åœ¨ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«é †åºã«ãªã£ã¦ã„ã¦ã€ service_idãŒupdated_atã®å¾Œã«ã‚ã‚‹ã®ã‚’ created_atã®å‰ï¼ˆBã®å¾Œï¼‰ã«ã—ãŸã„ã§ã™ã€‚ migrationã§ä»¥ä¸‹ã‚’å®Ÿè¡Œã—ãŸã®ã§ã™ãŒ åæ˜ ã•ã‚Œã¾ã›ã‚“ã§ã—ãŸã€‚ <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class ChangeColumnOrderInHogeTable extends Migration { /** * Run the migrat
kathew 2021/02/09
laravel

db

tips
ãƒªãƒ³ã‚¯
laravel bulk insertã§æ°—ã‚’ã¤ã‘ã‚‹ã“ã¨ - Qiita
è¿½è¨˜ 2020/11/26 Laravel 8.10ä»¥é™ã§Laravelã«ã¦bulk upsertãŒã‚µãƒãƒ¼ãƒˆã•ã‚ŒãŸã¿ãŸã„ã§ã™ã€‚ @kaya517ã•ã‚“æƒ…å ±ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ Laravel 8.10.X ãã‚‰ã„ã‚ˆã‚Šbulk upsertãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¾ã—ãŸ è©³ã—ãã¯ã“ã®PRã‚’å‚ç…§ ä»¥ä¸‹ã®è¨˜äº‹ã¯å†…å®¹ãŒå¤ããªã£ã¦ã„ã¾ã™ãŒã„ã¡ãŠã†æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ã¯ã¾ã‚Šã©ã“ã‚ æ™®é€šlaravelã§bulkinsertã¯ã“ã†ã—ã¾ã™ãã€‚ $params = [ ['first_name' => "tanaka", 'age' => 31, 'is_hungry' => 1 ], ['first_name' => "yamada", 'age' => 28, 'is_hungry' => 0 ] ] DB::table('table-name')->insert($params); ã—ã‹ã—ã€ã¡ã‚‡ã£ã¨è¤‡é›‘ãªç”ŸSQLã‚’
kathew 2021/01/25
laravel

db

tips
ãƒªãƒ³ã‚¯
laravelã§DBãƒ¬ã‚³ãƒ¼ãƒ‰ã®å˜åœ¨ãƒã‚§ãƒƒã‚¯æ–¹æ³• - Qiita
ç¾ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã‚ˆãä½¿ã†ã‘ã©æ›¸ã„ã¨ã‹ãªã„ã¨å¿˜ã‚Œãã†ãªã®ã§å‚™å¿˜éŒ²ãƒ¡ãƒ¢ ç’°å¢ƒ Laravel Framework 5.5 DBã®å˜åœ¨ãƒã‚§ãƒƒã‚¯æ–¹æ³•
kathew 2021/01/15
laravel

db
ãƒªãƒ³ã‚¯
ã€laravelã€‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œï¼šDBãƒ•ã‚¡ã‚µãƒ¼ãƒ‰ç·¨ - Qiita
æ¦‚è¦ laravelã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ã«ã¯ã„ãã¤ã‹ã®æ–¹æ³•ãŒã‚Šã¾ã™ã€‚ ãƒ»DBã‚¯ãƒ©ã‚¹ã«ã‚ˆã‚‹æ“ä½œ ãƒ»ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã«ã‚ˆã‚‹æ“ä½œ ãƒ»Modelã‚¯ãƒ©ã‚¹ï¼ˆEloquent ORMï¼‰ã«ã‚ˆã‚‹æ“ä½œ DBã‚¯ãƒ©ã‚¹ã‚‚ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã‚‚Illuminate\Support\Facades\DBã‚¯ãƒ©ã‚¹ï¼ˆãƒ•ã‚¡ã‚µãƒ¼ãƒ‰ï¼‰ã«ã‚ˆã‚‹è¨˜è¿°æ–¹æ³•ã§ã™ãŒã€Modelã‚¯ãƒ©ã‚¹ã¯Illuminate\Database\Eloquent\Modelã‚¯ãƒ©ã‚¹ã‚’ç¶™æ‰¿ã™ã‚‹ãŸã‚ä»•çµ„ã¿ãŒç•°ãªã‚Šã¾ã™ã€‚ ãã®ãŸã‚ã€DBã‚¯ãƒ©ã‚¹ã¨Modelã‚¯ãƒ©ã‚¹ã§æŠ•ç¨¿ã‚’åˆ†ã‘ã¦è¨˜è¿°ã—ã¾ã™ã€‚ ã€laravelã€‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œï¼šElequentç·¨ ä½™è«‡ã§ã™ãŒã‚¨ãƒ‡ã‚£ã‚¿ã§VSCodeã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã¯ã€æ‹¡å¼µæ©Ÿèƒ½ã«ã‚ˆã‚ŠSQLæ–‡ã‚’å¤§æ–‡å—ã§è¨˜è¿°ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šè‰²ãŒå¤‰ã‚ã‚Šè¦‹ã‚„ã™ããªã‚Šã¾ã™ã€‚ DBã‚¯ãƒ©ã‚¹å…±é€šã®è¨˜è¿° DBã‚¯ãƒ©ã‚¹ã§ã‚‚ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã§ã‚‚DBãƒ•ã‚¡ã‚µãƒ¼ãƒ‰ã«ã‚ˆã‚‹è¨˜è¿°ã®ãŸã‚Illuminate\
kathew 2021/01/05
laravel

reference

db
ãƒªãƒ³ã‚¯
Laravelã§DBã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹æ–¹æ³•ã€‚createã¨insertã®é•ã„ãªã© - Kattsu Sandbox
ã¯ã˜ã‚ã«æœ¬è¨˜äº‹ã®å†…å®¹ã¯ Laravel5.5 ã§æ¤œè¨¼ã—ã¦ã„ã¾ã™ã€‚ DB ã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹DB ã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹æ–¹æ³•ã¯ã€å¤§ããåˆ†ã‘ã¦ Eloquent ã§ãƒ¢ãƒ‡ãƒ«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ä½œæˆã—ã¦ä¿å˜ã™ã‚‹æ–¹æ³•ã¨ã€SQL ã§ç›´ã§ä¿å˜ã™ã‚‹æ–¹æ³•ã® 2 é€šã‚Šã‚ã‚Šã¾ã™ã€‚ Eloquent ã§ãƒ¢ãƒ‡ãƒ«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ä½œæˆã—ã¦ä¿å˜ã™ã‚‹æ–¹æ³•ã¯ã•ã‚‰ã«ã„ãã¤ã‹ã®æ–¹æ³•ã«åˆ†ã‹ã‚Œã¾ã™ã€‚ 1. create ãƒ¡ã‚½ãƒƒãƒ‰ // fillableã‹guardedã®ã©ã¡ã‚‰ã‹ã‚’æŒ‡å®šã™ã‚‹å¿…è¦ã‚ã‚Š protected $fillable = ['name']; // protected $guarded = ['']; $flight = App\Flight::create(['name' => 'Flight 10']); ãƒ¢ãƒ‡ãƒ«ã‚¯ãƒ©ã‚¹ã‹ã‚‰ create ãƒ¡ã‚½ãƒƒãƒ‰ã‚’å‘¼ã¶ã“ã¨ã§ã€ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ä½œæˆ â†’ å±žæ€§ã®ä»£å…¥ â†’ ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜ã‚’ä¸€æ°—é€šè²«ã§ã‚„
kathew 2021/01/05
laravel

db

tips
ãƒªãƒ³ã‚¯
MySQL with InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã‚ã‚ŠãŒã¡ãªé–“é•ã„ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºéƒ¨ã®è’å¼• (@a_bicky) ã§ã™ã€‚ çªç„¶ã§ã™ãŒã€RDBMS ã®æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¦‹ã¦ã¿ãŸã‚‰ã€Œä½•ã§ã“ã‚“ãªã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã ã‚‰ã‘ãªã®ï¼Ÿã€ã¿ãŸã„ãªçµŒé¨“ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿä¸è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å®¹é‡ã‚’åœ§è¿«ã—ãŸã‚Šã€æŒ¿å…¥ãŒé…ããªã£ãŸã‚Šã¨è‰¯ã„ã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ãã‚“ãªã‚ã‘ã§ã€ä»Šå›žã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã€ã‚ˆãè¦‹ã‹ã‘ã‚‹ä¸é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯ Rails ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä¸»ã« MySQL 5.6ã€MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ä¸»ã« InnoDB ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã€MySQL 5.6 ã® InnoDB ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«é–¢ã™ã‚‹åŸºç¤ŽçŸ¥è˜ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹é€ (B+ æœ¨) InnoDB ã§ã¯ B+ æœ¨ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚B+ æœ¨ã¯æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ã‚’æŒã£ãŸæœ¨æ§‹é€ ã§ã™ã€‚ æ¬¡æ•°ã‚’ b ã¨ã™ã‚‹ã¨ã€
kathew 2020/11/27
performance

db
ãƒªãƒ³ã‚¯
ã€Laravelã€‘ MySQL ãŒãƒžã‚¹ã‚¿ã‚¹ãƒ¬ãƒ¼ãƒ–æ§‹æˆã®ã¨ãï¼Œãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’è¶…ãˆã¦ sticky åŠ¹æžœã‚’é©ç”¨ã™ã‚‹ - Qiita
2019-12-31 è¿½è¨˜: ãƒ©ã‚¤ãƒ–ãƒ©ãƒªåŒ–ã—ã¾ã—ãŸï¼ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ï¼†ã‚µãƒ¼ãƒ“ã‚¹ãƒ—ãƒãƒã‚¤ãƒ€ã«1å€‹ç™»éŒ²ã™ã‚‹ã ã‘ã§ç°¡å˜ã«ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ï¼ mpyw/laravel-cached-database-stickiness: Guarantee database stickiness over the same user's consecutive requests æ¦‚è¦ MySQL ã‚„ Aurora ãªã©ã§ï¼Œãƒžã‚¹ã‚¿ã‚¹ãƒ¬ãƒ¼ãƒ–æ§‹æˆã«ã—ã¦ SELECT ã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ã«å¯¾ã—ã¦å®Ÿè¡Œ INSERT UPDATE DELETE ã¯ãƒžã‚¹ã‚¿ã«å¯¾ã—ã¦å®Ÿè¡Œ ã¨ã„ã†è¨å®šã«ã™ã‚‹ã“ã¨ã¯ã‚ˆãã‚ã‚‹ã€‚ Laravel ã¯ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ãƒ¬ãƒ™ãƒ«ã§ã“ã®è¨å®šã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ãŠã‚Šï¼Œè‡ªå‹•çš„ã«æŒ¯ã‚Šåˆ†ã‘ã‚’è¡Œãªã£ã¦ãã‚Œã‚‹ã€‚ã•ã‚‰ã«è¨å®šã§ sticky ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æœ‰åŠ¹åŒ–ã—ã¦ã„ã‚‹å ´åˆï¼Œ è‡ªåˆ†ãŒ INSERT UPDATE DELETE ã‚’å®Ÿè¡Œã—ãŸåŒä¸€H
kathew 2020/11/18
laravel

DB
ãƒªãƒ³ã‚¯
Laravel ã® DB ã®ãƒžã‚¹ã‚¿ãƒ¼/ã‚¹ãƒ¬ãƒ¼ãƒ–ã§ãƒžã‚¹ã‚¿ãƒ¼ã§ SELECT ã—ãŸã‚Šã‚¹ãƒ¬ãƒ¼ãƒ–ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã—ãŸã‚Š - Qiita
<?php return [ 'default' => env('DB_CONNECTION', 'mysql'), 'connections' => [ 'mysql' => [ 'driver' => 'mysql', 'read' => [ 'host' => env('DB_SLAVE_HOST', '127.0.0.1'), 'port' => env('DB_SLAVE_PORT', '3306'), ], 'write' => [ 'host' => env('DB_MASTER_HOST', '127.0.0.1'), 'port' => env('DB_MASTER_PORT', '3306'), ], 'database' => env('DB_DATABASE', 'test'), 'username' => env('DB_USERNAME', 'ore'), 'p
kathew 2020/11/18
laravel

DB
ãƒªãƒ³ã‚¯
Laravelã‚¯ã‚¨ãƒªãƒ¼ãƒ“ãƒ«ãƒ€ãƒ¼ã§ä½œæˆã—ãŸSQLã«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ãƒã‚¤ãƒ³ãƒ‰ã—ã¦å‡ºåŠ›ã—ãŸè©± - Qiita
helperé–¢æ•°ã‚’ä½¿ã£ã¦Bindéƒ¨åˆ†ã«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’æŒ¿å…¥ â€»ã€€å‚è€ƒ ã€æœ—å ±ã€‘Laravel ã® SQL å®Ÿè¡Œãƒã‚°ãŒå–å¾—ã—ã‚„ã™ããªã‚‹ ã“ã¡ã‚‰ã§æ›¸ã‹ã‚Œã¦ã„ã‚‹é€šã‚Šã€Laravel 10.x ç³»ã§ toRaw Sql() ãŒå®Ÿè£…ã•ã‚Œã‚‹ãã†ã§ã™ã€‚ å¯¾è±¡ã®æ–¹ã¯ã€ã“ã¡ã‚‰ç¢ºèªã—ã¦ãã ã•ã„ã€‚ Laravelã§QueryBuilderã‚’ä½¿ç”¨æ™‚ã«ã€$builder->toSql()ã§ä½œæˆä¸ã®SQLã¯è¦‹ã‚Œã‚‹ã‚“ã ã‘ã©ã€ãƒã‚¤ãƒ³ãƒ‰ã—ãŸå¾Œã®ãƒ‡ãƒ¼ã‚¿ã‚’PHPå´ã‹ã‚‰å‡ºåŠ›ã—ãŸã‹ã£ãŸã®ã§ã€Helperé–¢æ•°ã‚’ä½¿ã£ã¦Bindã—ã¦ã¿ãŸã€‚ ã‚³ãƒ¼ãƒ‰ä¾‹ // modelã«ã¯é©å½“ãªEloquentãƒ¢ãƒ‡ãƒ«ã‚’æŒ‡å®šã—ã¦ãã ã•ã„ã€‚ $builder = Model::where('id', 1)->where('name', 'name'); $sql = preg_replace_array('/\?/', $builder->getBindings()
kathew 2020/10/28
laravel

tips

db
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼šã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ 5.6 Laravel
ã‚¤ãƒ³ãƒˆãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã¯ã‚¹ãƒ©ã‚¹ãƒ©ã¨æ›¸ã‘ã‚‹(fluent)ä¾¿åˆ©ãªã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã§ã€ã‚¯ã‚¨ãƒªã‚’ä½œæˆã—å®Ÿè¡Œã™ã‚‹ãŸã‚ã«ä½¿ç”¨ã—ã¾ã™ã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§è¡Œã‚ã‚Œã‚‹ã»ã¨ã‚“ã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹æ“ä½œãŒå¯èƒ½ã§ã€ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã«å¯¾ã—ä½¿ç”¨ã§ãã¾ã™ã€‚ Laravelã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã‹ã‚‰å®ˆã‚‹ãŸã‚ã«ã€PDOãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã«ã‚ˆã‚‹ãƒã‚¤ãƒ³ãƒ‡ã‚£ãƒ³ã‚°ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ãƒã‚¤ãƒ³ãƒ‰ã™ã‚‹æ–‡å—åˆ—ã‚’ã‚¯ãƒªãƒ¼ãƒ³ã«ã—ã¦ã‹ã‚‰æ¸¡ã™å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ çµæžœã®å–å¾— å…¨ãƒ¬ã‚³ãƒ¼ãƒ‰ã®å–å¾— ã‚¯ã‚¨ãƒªã‚’æ›¸ãã«ã¯DBãƒ•ã‚¡ã‚µãƒ¼ãƒ‰ã®tableãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã„ã¾ã™ã€‚tableãƒ¡ã‚½ãƒƒãƒ‰ã¯æŒ‡å®šã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’è¿”ã—ã¾ã™ã€‚ã“ã‚Œã‚’ä½¿ã„ã‚¯ã‚¨ãƒªã«åˆ¶ç´„ã‚’åŠ ãˆã€æœ€çµ‚çš„ãªçµæžœã‚’å–å¾—ã™ã‚‹ãƒã‚§ãƒ¼ãƒ³ã‚’ç¹‹ã’ã¾ã™ã€‚æ¬¡ã«ã€æœ€çµ‚çš„ãªçµæžœã‚’getã§å–å¾—ã—ã¾ã™ã€‚ <?php namespace App\Ht
kathew 2020/10/13
laravel

db
ãƒªãƒ³ã‚¯
å¤šæ®µsshãŒå¿…è¦ãªç’°å¢ƒã§ãƒãƒ¼ã‚«ãƒ«ã‹ã‚‰RDSã¸æŽ¥ç¶šã™ã‚‹ - notebook
ç¤¾å†…ã®ã—ãŒã‚‰ã¿ï¼Ÿã¨ã‹ã§RDSã¸æŽ¥ç¶šã™ã‚‹ã®ã«2ã¤è¸ã¿å°ã‚’çµŒç”±ã—ãªã„ã¨ã„ã‘ãªããªã£ã¦ã—ã¾ã£ãŸã®ã§å›°ã£ã¦ã„ãŸã®ã§ã™ãŒã½ã‚ã£ã¨æ„šç—´ã£ãŸã‚‰å…ˆè¼©æ–¹ã«å‡ºæ¥ã‚‹ã˜ã‚ƒããƒ¼ã‹ï¼ã¨æ•™ãˆã¦ã„ãŸã ã„ãŸã®ã§ãƒ¡ãƒ¢ è¸ã¿å°ä¸€ã¤ã§ã‚ã‚Œã°ã‚½ãƒ•ãƒˆã«ã‚ˆã£ã¦ã¯å¯¾å¿œã—ã¦ã„ã¦è¸ã¿å°ã®è¨å®šã‚’å…¥åŠ›ã™ã‚Œã°æŽ¥ç¶šã§ããŸã®ã§æœ€è¿‘ã¾ã§ãã†ã„ã†æ–¹æ³•ã§ã‚„ã£ã¦ã„ãŸã®ã§ã™ãŒã€è¸ã¿å°ã‚’2å°çµŒç”±ã—ãªã„ã¨ã„ã‘ãªã„æ¡ˆä»¶ãŒç™ºç”Ÿã—ã¦ã—ã¾ã£ãŸãŸã‚ã“ã†ã„ã†äº‹æ…‹ã«ãªã‚Šã¾ã—ãŸ æœ€åˆcliã ã‘ã§é ‘å¼µã£ã¦ãŸã‚“ã§ã™ãŒãªã‚“ã ã‹ã‚“ã ã„ã£ã¦cliã ã‘ã§SQLå©ã„ã¦ãã®ã¯ã¡ã‚‡ã£ã¨ã¤ã‚‰ã¿ãŒã‚ã‚‹ã®ã§GUIä½¿ã£ã¦ã‚‰ãã—ãŸã„ã§ã™ã ã¨ã„ã†ã“ã¨ã§ã€ãƒãƒ¼ãƒˆãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ã‚’ä½¿ã£ã¦å®Ÿç¾ã—ã¾ã™ çŠ¶æ³ã¯ã“ã‚“ãªæ„Ÿã˜ ãƒãƒ¼ã‚«ãƒ«PC â‡’ è¸ã¿å°ã‚µãƒ¼ãƒA â‡’ è¸ã¿å°ã‚µãƒ¼ãƒB â‡’ RDS è‡ªåˆ†ã®PCã¯Windowsã§ã™ãŒ Git Bashãªã©ãŒå…¥ã£ã¦ã„ã‚Œã°ãã¡ã‚‰ã®ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‹ã‚‰sshã‚³ãƒžãƒ³ãƒ‰ãŒå®Ÿè¡Œã§ãã‚‹ã®ã§ãã‚Œã§è¡Œã„ã¾ã—ãŸ
kathew 2020/10/04
ssh

db

aws
ãƒªãƒ³ã‚¯
Laravelã§å®Ÿè¡Œã•ã‚ŒãŸSQLã‚’ç¢ºèªã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
kathew 2020/09/19
laravel

db

debug
ãƒªãƒ³ã‚¯
Laravel ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€è¨˜æ³•ã¾ã¨ã‚
å…¬é–‹æ—¥ 2018.3.22æ›´æ–°æ—¥ 2022.10.27ã‚«ãƒ†ã‚´ãƒªï¼šLaravelã‚¿ã‚°ï¼šPHP,Laravel,QueryBuilder
kathew 2020/08/20
laravel

DB
ãƒªãƒ³ã‚¯
How to drop table in Laravel?
The probl em is that I have this error: [PDOException] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'songs' already exists This is my migration file: <?php use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateSongsTable extends Migration { public function up() { Schema::create('songs', function (Blueprint $table) { $table->increments(
kathew 2020/08/20
laravel

migration

db

tips
ãƒªãƒ³ã‚¯
Mysqlã®booleanåž‹ã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ãŸ - Qiita
ã¯ã˜ã‚ã« Mysqlã§booleanã¨ã„ã†åž‹ã‚’æŒ‡å®šã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ãŒä½œã‚Œã‚‹ã®ã§ã€ å®Ÿéš›ã©ã†ã„ã†æ‰±ã„ã«ãªã£ã¦ã„ã‚‹ã®ã‹èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ ãƒ†ã‚¹ãƒˆã—ãŸMysql ver. 5.1.73 booleanåž‹ã§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã£ã¦ã¿ã‚‹ -- ã“ã‚“ãªã®ã‚’ä½œã£ã¦ã¿ã‚‹ create table `bool_check` ( `bool` boolean ); mysql> create table `bool_check` ( -> `bool` boolean -> ) -> ; Query OK, 0 rows affected (0.06 sec) mysql> show create table bool -> ; +-------+-----------------------------------------------------------------------------------------
kathew 2020/08/17
mysql

db

tips
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸