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

kathew id:kathew

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

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

å±¥æ´ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰æœ€æ–°ã®1ä»¶ã‚’å–ã£ã¦ãã‚‹æ–¹æ³• - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
ä¾‹ãˆã°æ¬¡ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã£ãŸã¨ã™ã‚‹ã€‚ -- PostgreSQL CREATE TABLE history ( id SERIAL PRIMARY KEY, user_id INTEGER NOT NULL, data TEXT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ); -- MySQL CREATE TABLE history ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, data TEXT, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ); INSERT INTO history (user_id, data, created_at) VALUES (1, 'First
kathew 2024/12/10
mysql

sql
ãƒªãƒ³ã‚¯
ã€Oracleã€‘DECODE ã§æ¡ä»¶ã‚’ã‚ã‘ã‚‹ã€SQLã€‘
æ¡ä»¶ã‚’ã‚ã‘ã‚‹DECODEã®ä½¿ã„æ–¹ DECODEã®æ§‹æ–‡ --DECODEã§æ¡ä»¶ã‚’ã‚ã‘ã¦SELECTã™ã‚‹ SELECT DECODE(åˆ—å, å€¤1, çµæžœ1, å€¤2, çµæžœ2, çµæžœ3) FROM table1; ã€ŒDECODEã€ã§ã¯ã€æŒ‡å®šã—ãŸåˆ—ã®å€¤ã«ã‚ˆã£ã¦ç•°ãªã‚‹çµæžœã‚’è¿”ã™ã“ã¨ãŒã§ãã¾ã™ã€‚
kathew 2022/03/01
oracle

sql
ãƒªãƒ³ã‚¯
ç¤¾å†…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
ãƒªãƒ³ã‚¯
ã€SQLã€‘Excelã§ã§ãã‚‹ã ã‘ã‚¹ãƒžãƒ¼ãƒˆã«INSERTæ–‡ã‚’ä½œæˆã™ã‚‹æ–¹æ³•ã‚’æ¨¡ç´¢ã—ãŸ - æ ªå¼ä¼šç¤¾ã‚¯ã‚¤ãƒƒã‚¯ã®Webã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºblog
ã“ã‚“ã«ã¡ã¯ã€‚sanamekoã§ã™ï¼ çªç„¶ã§ã™ãŒã€INSERTæ–‡ã‚’æ›¸ãã®ã£ã¦ã™ã”ãå¤§å¤‰ã§ã™ã‚ˆãï¼ï¼ˆå€‹äººã®æ„Ÿæƒ³ã§ã™ã€‚ï¼‰ ã€Œã‚«ãƒ©ãƒ å1,ã‚«ãƒ©ãƒ å2,ï½¥ï½¥ï½¥ã‚«ãƒ©ãƒ åNã€ã®å¾Œã«ã€Œå€¤1,å€¤2,ï½¥ï½¥ï½¥å€¤Nã€ã¨æ›¸ãã®ãŒè‹¦æ‰‹ã§ã€æœ€çµ‚çš„ã«ã‚«ãƒ©ãƒ ãŒãšã‚Œã¦ãŸã‚Šã€ã‚«ãƒ©ãƒ æ•°è¶³ã‚Šãªã‹ã£ãŸã‚Šã£ã¦ã“ã¨ã€ã‚ˆãã‚ã‚Šã¾ã™ï¼ æ‰‹ã§ã‚¬ãƒªã‚¬ãƒªæ›¸ã‹ãšã«ã€ã†ã¾ã„ã“ã¨ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ãƒ©ã‚¯ã«æ›¸ã‘ãªã„ã‚‚ã®ã‹ï½¥ï½¥ï½¥ãƒ½(Ë‡Ð´ Ë‡;)ï¾‰ ã¨ã„ã†ã“ã¨ã§ã€ã€ŒExcelã§ã§ãã‚‹ã ã‘ã‚¹ãƒžãƒ¼ãƒˆã«INSERTæ–‡ã‚’ä½œæˆã™ã‚‹æ–¹æ³•ã€ã‚’è€ƒãˆãŸã„ã¨æ€ã„ã¾ã™ï¼ ã€Œã‚¹ãƒžãƒ¼ãƒˆã€ã¨ã¯ Excelã§INSERTæ–‡ã‚’ä½œæˆã™ã‚‹ã¨ã„ã†è©±ã¯ã‚ˆãèžãã®ã§ã€ä»Šæ›´æ„Ÿã¯å¦ã‚ã¾ã›ã‚“ãŒã€ä»Šå›žã¯ã€Œã‚¹ãƒžãƒ¼ãƒˆã€ã‚’ãƒ†ãƒ¼ãƒžã«ã€ä¸‹è¨˜ã®ã“ã¨ã‚’å¿µé ã«ãŠã„ã¦ä½œã£ã¦ã¿ã¾ã™ï¼ èª°ãŒè¦‹ã¦ã‚‚åˆ†ã‹ã‚Šã‚„ã™ã„ ãƒžã‚¯ãƒã‚„VBAã¯ä½¿ã‚ãªã„ ã‚ã¡ã“ã¡ã«æ•°å¼ï¼ˆé–¢æ•°ï¼‰ã‚’æ•£ã‚Šã°ã‚ãŸã‚Šã›ãšã€æœ€å°é™ã®ã‚»ãƒ«ã«æŠ‘ãˆã‚‹ æ•°å¼ã®ä¸èº«ã‚’è¦‹ãªãã¦ã‚‚ã€ä½•ã‚’ã‚„ã£ã¦ã„
kathew 2021/04/12
sql

excel

tips
ãƒªãƒ³ã‚¯
php artisan migrate ã§å®Ÿè¡Œã•ã‚Œã‚‹SQLãŒç¢ºèªã—ãŸã„ï¼ - Qiita
ã€Œmigrateæ™‚ã®å®Ÿè¡ŒSQLãŒã¿ã‚Œã‚Œã°ã„ã„ã®ã«ãªãƒ¼ã€ã¨ã‹æ€ã£ã¦ãŸã‚‰ãŸã¾ãŸã¾åˆ¥ã®å•é¡Œã®åŽŸå› ã‚’èª¿ã¹ã¦ã„ã‚‹ã¨ãã«â†“ã®è¨˜äº‹ã«è¡Œãç€ã„ãŸã€‚ 2å¹´å‰ã®ã‚¨ãƒ³ãƒˆãƒªã§è‹¥å¹²å¤ã„æ„Ÿã¯å¦ã‚ãªã„ãŒã€Œã“ã‚“ãªä¾¿åˆ©ãªæ©Ÿèƒ½ãŒï¼ã€ã¨ãªã£ãŸã®ã§ãƒ¡ãƒ¢ä»£ã‚ã‚Šã«æ›¸ã„ã¦ãŠãã€‚ Laravelã§ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚’ä½¿ã£ãŸ1:1é–¢é€£ã®ãƒ†ãƒ¼ãƒ–ãƒ«åˆ†å‰²ã§è‡ªå‹•æŽ¡ç•ªã‚’ã—ãªã„ã‚ˆã†ã«ã™ã‚‹ æœ€å¾Œã« migrate ã® SQL ã‚’ç¢ºèªã—ãŸã„ã¨ãã¯ pretend ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ã¤ã‘ã‚‹ã¨ç¢ºèªã§ãã¾ã™ã€‚ ä¸Šè¨˜ 2 ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ãƒˆ SQL ã¯ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ $php artisan migrate --pretend CreateUsersTable: create table `users` (`id` int unsigned not null auto_increment primary key, `em ail` varchar(255) not n
kathew 2021/02/08
sql

php

laravel
ãƒªãƒ³ã‚¯
SQL Formatter & Beautifier Online
SQL Formatter helps to format SQL code data and it helps the developer easy to read the SQL. This tool helps uses to beautify large SELECT statements and make it easy to read. SQL formatting is a tedious task, which can be handled by an SQL formatter. SQL formatter is a utility that converts the unreadable SQL code into a readable format. It preserves all the details of the original, just in a dif
kathew 2021/02/07
sql

web

service
ãƒªãƒ³ã‚¯
Laravelã®ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã§SQLæ–‡ã‚’ç›´æŽ¥å®Ÿè¡Œ(select,insert,update,delete,ãã®ä»–) - 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/11/12
laravel

sql
ãƒªãƒ³ã‚¯
Laravel5ã§SQLã‚’ç¢ºèªã™ã‚‹(ãŠæ‰‹è»½ç‰ˆ) - Qiita
Query Builder ã‚’ä½¿ã£ãŸæ™‚ã«ã©ã‚“ãªSQLã«ãªã‚‹ã®ã‹çŸ¥ã‚ŠãŸã„ [2020-07-30 è¿½è¨˜] æœ€æ–°ã®Laravel 7.x ã§ã‚‚ã“ã®æ–¹æ³•ãŒä½¿ãˆã‚‹ã“ã¨ã‚’ç¢ºèªã—ã¾ã—ãŸã€‚ [/2020-07-30 è¿½è¨˜] ã“ã“ã§ã¯é–‹ç™ºä¸ã«ç°¡å˜ã«ç¢ºã‹ã‚ã‚‹æ–¹æ³•ã‚’è¼‰ã›ã¦ã„ã¾ã™ã€‚ ã˜ã£ãã‚Šã¨ãƒã‚°ã«å‡ºåŠ›ã—ã¦SQLèª¿æ•´ã—ãŸã„ã¨ã‹ã ã£ãŸã‚‰ã“ã¡ã‚‰ãŒå‚è€ƒã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ Laravel5ã§SQLãƒã‚°ã‚’å–ã‚‹ laravel5.2 å®Ÿè¡ŒSQLã®ãƒã‚°ã‚’å–ã‚‹ - webé–‹ç™ºãƒ¡ãƒ¢ ç”ãˆ: toSql() ã‚’ä½¿ã† APIãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã‚ã‚Šã¾ã—ãŸã€‚QueryBuilder::toSql() ä»¥ä¸‹ã¯ãã®ã‚„ã‚Šæ–¹ã§ã™ $users = DB::table('users') ->where('status', '<>', 1) ->get();
kathew 2020/10/13
laravel

sql
ãƒªãƒ³ã‚¯
MySQLã§datetimeåž‹(æ—¥æ™‚)ã‚’æ—¥ä»˜ã§æŠ½å‡ºã™ã‚‹SQLã®é€Ÿåº¦æ¯”è¼ƒ - [MySQL MariaDB/SQL] ãºã‚“ãŸã‚“ info
ã€Ž2014-07-26 08:47:13ã€ã®ã‚ˆã†ã«datetimeåž‹ã§ã‚«ãƒ©ãƒ ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹å€¤ã‚’æ—¥ä»˜ã§æŠ½å‡º(SELECT)ã—ãŸæ™‚ã®é€Ÿåº¦ã‚’æ¯”è¼ƒã—ã¦ã¿ã¾ã—ãŸã€‚ ã‚µãƒ³ãƒ—ãƒ«ãƒ†ãƒ¼ãƒ–ãƒ«ã¯100,000ãƒ¬ã‚³ãƒ¼ãƒ‰ æŠ½å‡ºã™ã‚‹datetimeåž‹ã®ã‚«ãƒ©ãƒ ã«ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã£ã¦ã„ã¾ã™ã€‚ å®Ÿè¡Œæ™‚é–“ã¯10å›žå¹³å‡ã§ã™ã€‚ çµæžœã¯ã»ã»æƒ³åƒé€šã‚Šã§ã™ãŒã€å‚è€ƒã¨ã—ã¦ åŒã˜çµæžœã§ã‚‚SQLæ–‡ã«ã¯ã„ãã¤ã‚‚ã®æ›¸ãæ–¹ãŒã‚ã‚Šã€æ›¸ãæ–¹ã«ã‚ˆã£ã¦é€Ÿåº¦ãŒ20å€ã‚‚é•ã„ã¾ã™ã€‚ [å‚è€ƒè¨˜äº‹] æ—¥ä»˜åž‹ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã«ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ä½¿ã£ã¦ã¯ã„ã‘ã¾ã›ã‚“(æ–‡å—ã‚³ãƒ¼ãƒ‰ã«ã‚ˆã£ã¦å€¤ãŒå¤‰ã‚ã‚‹) datetimeåž‹ã‚’ã€Ž2014-07-26ã€ã®ã‚ˆã†ã«å˜ç´”ã«æ¯”è¼ƒã™ã‚‹ã¨ã€Ž00:00:00ã€ãŒè£œå®Œã•ã‚Œã¾ã™ã€‚ `sample_time` = '2014-07-26' â†“ã¨åŒã˜æ‰±ã„ `sample_time` = '2014-07-26 00:00:00' ä»¥ä¸‹ã€æ—©ã„é †ã§ã™ã€‚ æ—¥æ™‚ã‚’
kathew 2020/08/11
mysql

performance

sql

date
ãƒªãƒ³ã‚¯
SQL Server Management Studio ã§ MDFãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãï¼ˆé–‰ã˜ã‚‹ï¼‰ | zoro0nine
Management Studioã§LocalDBç‰ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç·¨é›†ã—ãŸã„å ´åˆã®æ“ä½œã€‚ é–‹ãï¼ˆã‚¢ã‚¿ãƒƒãƒï¼‰ ï¼‘ï¼Žå·¦ãƒšã‚¤ãƒ³ã®[ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹]ã‚’å³ã‚¯ãƒªãƒƒã‚¯ã—ã€[ã‚¢ã‚¿ãƒƒãƒ]ã‚’é¸æŠž ï¼’ï¼Ž[ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆ]ç”»é¢ã§ã€[è¿½åŠ ]ãƒœã‚¿ãƒ³ã‚’æŠ¼ä¸‹ ï¼“ï¼Ž[ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã®æ¤œç´¢]ç”»é¢ã§å¯¾è±¡ã®mdfãƒ•ã‚¡ã‚¤ãƒ«ã‚’é¸æŠžã—[OK]ãƒœã‚¿ãƒ³æŠ¼ä¸‹ ï¼”ï¼Ž[ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆ]ç”»é¢ã§[OK]ãƒœã‚¿ãƒ³æŠ¼ä¸‹ ï¼•ï¼Žè‰²ã€…æ“ä½œã™ã‚‹ã€‚
kathew 2020/06/23
sql

server
ãƒªãƒ³ã‚¯
ã€SQL Serverã€‘ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’INSERTæ–‡ä»˜ãã§ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ - å°ç‰©SEã®ãƒ¡ãƒ¢å¸³
ãƒ†ãƒ¼ãƒ–ãƒ«å†…ã®ãƒ‡ãƒ¼ã‚¿ã‚’INSERTæ–‡ä»˜ãã§ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹æ‰‹é †ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ç§»è¡Œç”¨ã®ãƒ‡ãƒ¼ã‚¿æŠ½å‡ºãªã©ã§åˆ©ç”¨ã§ãã‚‹ã‹ã¨ã€‚ SSMSã®å·¦ãƒšã‚¤ãƒ³ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã§å³ã‚¯ãƒªãƒƒã‚¯ã€ã€Œã‚¿ã‚¹ã‚¯ã€ã‚’é¸æŠžã—ã€ã€Œã‚¹ã‚¯ãƒªãƒ—ãƒˆç”Ÿæˆã€ã‚’é¸ã³ã¾ã™ã€‚ ä»Šå›žã¯ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã®ã¿æŠ½å‡ºã—ãŸã„ãŸã‚ã€ã€Œç‰¹å®šã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®é¸æŠžã€ã‚’é¸ã³ã€ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã—ãŸã„ãƒ†ãƒ¼ãƒ–ãƒ«åã‚’é¸æŠžã€‚ ã€Œè©³ç´°è¨å®šã€ã‚’æŠ¼ä¸‹ã—ã¾ã™ã€‚ ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®ã€Œå…¨èˆ¬ã€ã«ã‚ã‚‹ã€Œã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œæˆã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ç¨®é¡žã€ã§ã€Œãƒ‡ãƒ¼ã‚¿ã®ã¿ã€ã‚’é¸æŠžã€‚ ã€Œæ¬¡ã¸ã€ã‚’é¸æŠžã—ã€æ¬¡ç”»é¢ã§ã€Œå®Œäº†ã€ã‚’æŠ¼ä¸‹ã—ã¾ã™ã€‚ æŒ‡å®šã—ãŸãƒ•ã‚©ãƒ«ãƒ€ã«INSERTæ–‡ä»˜ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãŒã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã•ã‚Œã¾ã™ã€‚ ã€Œã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œæˆã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ç¨®é¡žã€ã®éš›ã«ã€Œã‚¹ã‚ãƒ¼ãƒžã¨ãƒ‡ãƒ¼ã‚¿ã€ã‚’é¸æŠžã™ã‚Œã°ã€ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆã‚„åˆ¶ç´„ä»˜ãã§ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã—ã€ã€Œçµ±è¨ˆã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œæˆã€ã§ã€Œçµ±è¨ˆã¨ãƒ’ã‚¹ãƒˆ
kathew 2020/06/22
sql

server
ãƒªãƒ³ã‚¯
SQLServer:å®Œå…¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’åˆ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¾©å…ƒã™ã‚‹æ–¹æ³•
æ™®æ®µã¯ Linux ç³»ã‚·ã‚¹ãƒ†ãƒ ãŒãƒ¡ã‚¤ãƒ³ã§ã€SQLServerã¯ç¢ºèªç”¨SQLã‚’èµ°ã‚‰ã›ã‚‹ç¨‹åº¦ã€‚ ç®¡ç†ç³»ä½œæ¥ã¯ã»ã¼ã„ã˜ã‚‰ãªã„ã®ã§ã€å¿˜ã‚Œãªã„ã‚ˆã†ã«ãƒ¡ãƒ¢ã€‚ SQLServer Management Studio ã‚’èµ·å‹• ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã‚’å³ã‚¯ãƒªãƒƒã‚¯ã—ã¦ã€ã€Œæ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã‚’ä½œæˆ ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã‚’å³ã‚¯ãƒªãƒƒã‚¯ã—ã¦ã€ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¾©å…ƒã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œå…¨èˆ¬ã€ã‚¿ãƒ–ã®å¾©å…ƒå…ˆâ†’å¾©å…ƒå…ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¸Šã§æ–°è¦ä½œæˆã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é¸æŠž ã€Œ å¾©å…ƒç”¨ã®ã‚½ãƒ¼ã‚¹ã€ã§ã€Œãƒ‡ãƒã‚¤ã‚¹ã‹ã‚‰ã€ã‚’ãƒã‚§ãƒƒã‚¯ã—ã€å®Œå…¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡å®š [ã‚ªãƒ—ã‚·ãƒ§ãƒ³]ã‚¿ãƒ–ã§ã€Œæ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¸Šæ›¸ãã™ã‚‹ã€ã‚’ãƒã‚§ãƒƒã‚¯ [OK] å®Œäº† â– æ³¨æ„1 ã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ã‚¿ãƒ–ã®ã€Œæ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¸Šæ›¸ãã™ã‚‹ã€ã®ãƒã‚§ãƒƒã‚¯ã‚’è¡Œã„ã‚ãªã„ã¨ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã‚»ãƒƒãƒˆã¯ã€æ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ â€˜%lsâ€™ ä»¥å¤–ã®ãƒ‡ãƒ¼ã‚¿ ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ä¿æŒã—ã¦ã„ã¾ã™ã€‚ ã¨ã„ã£ãŸã‚¨ãƒ©ãƒ¼
kathew 2020/06/22
sql

server
ãƒªãƒ³ã‚¯
å„Windows OSã§åˆ©ç”¨ã§ãã‚‹SQL Serverã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’çŸ¥ã‚‹
å¯¾è±¡ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼šWindows XPï¼Windows Vistaï¼Windows 7ï¼Windows 8ï¼Windows 8.1ï¼Windows Server 2003ï¼Windows Server 2008ï¼Windows Server 2008 R2ï¼Windows Server 2012ï¼Windows Server 2012 R2ã€SQL Server 2005ï¼SQL Server 2008ï¼SQL Server 2008 R2ï¼SQL Server 2012ï¼SQL Server 2014 è§£èª¬ ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€ŒSQL Serverã€ã¯ã€Windows OSã¨åŒæ§˜ã€æ©Ÿèƒ½ã‚„æ€§èƒ½ã®å‘ä¸Šã®ãŸã‚ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ãŒç¹°ã‚Šè¿”ã•ã‚Œã¦ããŸã€‚ç¾åœ¨ã‚µãƒãƒ¼ãƒˆä¸ã®ï¼ˆãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ«ãŒçµ‚ã‚ã£ã¦ã„ãªã„ï¼‰ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã ã‘ã§ã‚‚ã€æ¬¡ã®5ç¨®é¡žãŒå˜åœ¨ã™ã‚‹ã€‚ SQL Server 2005ï¼ˆå†…
kathew 2020/05/26
windows

sql

server
ãƒªãƒ³ã‚¯
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/03/12
laravel

sql

log

development
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - ãƒŠã‚¤ãƒ¼ãƒ–ãƒ„ãƒªãƒ¼
ç¤¾å†…å‹‰å¼·ä¼šè³‡æ–™ è¿½è¨˜: 2013-10-31 ã¤ã„ã£ãŸã§æŒ‡æ‘˜( https://twitter.com/akuraru/status/395822183777202176 )ã‚’å—ã‘ãŸã®ã§å…¥ã‚Œåé›†åˆã®ãƒŽãƒ¼ãƒ‰è¿½åŠ ã®èª¬æ˜Žã®æ‰€ã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚Read less
kathew 2020/02/25
å˜ãªã‚‹è‡ªå·±å‚ç…§ã¨æ€ã£ã¦æ‰‹ã‚’å‡ºã—ãŸã‚‰ã€åå«ã®é›†è¨ˆã§ç—›ã„ç›®ã‚’è¦‹ãŸ

sql
ãƒªãƒ³ã‚¯
HeidiSQLã§ã®csvã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã€ã‚¤ãƒ³ãƒãƒ¼ãƒˆ - Qiita
åˆ©ç”¨ã‚·ãƒ¼ãƒ³ MySQL(UTF8ã®DB)ã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«å˜ä½ã§CSVå‡ºåŠ›ã—ã¦ã€Excelã§ç·¨é›†ã—å†åº¦å–ã‚Šè¾¼ã‚€ã€‚ ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’é¸æŠžã™ã‚‹ã€‚ ã€Œãƒ¡ãƒ‹ãƒ¥ãƒ¼ï¼žToolsï¼žExport grid rows ..ã€ã‚’é¸æŠžã™ã‚‹ã€‚ Encodingã‚’ã€ŒANSIã€ã¨ã™ã‚‹ã€‚ Row selectionã‚’ã€ŒCompleteã€ã¨ã™ã‚‹ã€‚ ã€ŒOKã€ã‚’æŠ¼ã—ã¦ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹ã€‚ ï½ž Excelç‰ã§CSVã‚’ç·¨é›† ã‚¤ãƒ³ãƒãƒ¼ãƒˆ å–ã‚Šè¾¼ã‚€CSVã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’UTF-8ã¨ã™ã‚‹ã€‚â€»ä»»æ„ã®ã‚¨ãƒ‡ã‚£ã‚¿ã‚„ãƒ„ãƒ¼ãƒ«ã§ ã€Œãƒ¡ãƒ‹ãƒ¥ãƒ¼ï¼žToolsï¼žImport CSV file ..ã€ã‚’é¸æŠžã™ã‚‹ã€‚ Control charactersã®Fields terminated byã‚’ã€Œ,ã€ã«ã™ã‚‹ã€‚ Methodã‚’ã€ŒClient parses file contentsã€ã«ã™ã‚‹ã€‚ ã€ŒImport!ã€ã‚’æŠ¼ã—ã¦ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã€‚ ###ã€€è£œè¶³ Handlin
kathew 2019/10/17
mysql

sql

tips

csv
ãƒªãƒ³ã‚¯
SQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ãã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ–ãƒƒã‚¯
é–‹ç™ºè€…å‘ã‘ã®SQLã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è§£èª¬ã‚µã‚¤ãƒˆã€ç®¡ç†ã«ã¤ã„ã¦ã®é–“é•ã„ãªã„çŸ¥è˜ã‚’æä¾›ã—ã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é–‹ç™ºæ™‚ã«ã¯å¿˜ã‚Œã‚‰ã‚ŒãŒã¡ã§ã‚ã‚‹ä¸€æ–¹ã§ã€éžå¸¸ã«åŠ¹æžœçš„ãªSQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³•ã§ã™ã€‚Use The Index, Lukeã§ã¯ã€Hibernateãªã©ã®ORMãƒ„ãƒ¼ãƒ«ã®è§£èª¬ã«ã¨ã©ã¾ã‚‰ãšã€SQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åŸºç¤Žã‹ã‚‰èª¬æ˜Žã—ã¾ã™ã€‚ Use The Index, Lukeã¯SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã®Webä¸Šã®ç„¡æ–™ç‰ˆã§ã™ã€‚ã‚µã‚¤ãƒˆã‚’æ°—ã«å…¥ã£ã¦é ‚ã‘ãŸã‚‰ã€ãœã²æ›¸ç±ã‚‚è³¼å…¥ã—ã¦ã¿ã¦ä¸‹ã•ã„ã€‚ã¾ãŸã€ã“ã®ã‚µã‚¤ãƒˆã®é‹å–¶ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹æ§˜ã€…ãªã‚°ãƒƒã‚ºã‚‚è²©å£²ã—ã¦ã„ã¾ã™ã€‚ MySQLã€Oracleã€SQL Serverãªã©ã«ãŠã‘ã‚‹SQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹Use The Index, Lukeã§ã¯ã€ãƒ™ãƒ³ãƒ€ã«ã¨ã‚‰ã‚ã‚Œãªã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®èª¬æ˜Žã‚’å¿ƒãŒã‘ã¦ã„ã¾ã™ã€‚è£½å“ç‰¹æœ‰ã®äº‹æŸ„ã«ã¤ã„ã¦ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªè¡¨ç¤ºã‚’ã—ã¦ã„ã¾ã™ã€‚ Db2 (LUW)U
kathew 2019/10/04
sql

performance

db
ãƒªãƒ³ã‚¯
[Oracle]LIKEæ¤œç´¢ã§ã‚¢ãƒ³ãƒ€ãƒ¼ã‚¹ã‚³ã‚¢ã‚’æŒ‡å®šã™ã‚‹ - KONY.NET
æ™®æ®µã€SQLã‚’æ›¸ã„ã¦ã„ãªã„ã¨ã‚ˆãå¿˜ã‚Œã‚‹ã®ã§å‚™å¿˜éŒ²ã€‚ escapeå¥ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€ã‚¢ãƒ³ãƒ€ãƒ¼ã‚¹ã‚³ã‚¢(_)ã‚„ãƒ‘ãƒ¼ã‚»ãƒ³ãƒˆ(%)ã‚’æ¤œç´¢æ–‡å—åˆ—ã¨ã—ã¦æŒ‡å®šã§ãã‚‹ã€‚ SQL> select * from TBLNAME; ID STR ---------- ---------- 1 KONY 2 _KONYã€€ã€€ã€€â†ã‚¢ãƒ³ãƒ€ãƒ¼ã‚¹ã‚³ã‚¢ã‚’å«ã‚€æ–‡å—åˆ— SQL> select * from TBLNAME where STR like '_%'; ID STR ---------- ---------- 1 KONYã€€ã€€ã€€â†ã‚¢ãƒ³ãƒ€ãƒ¼ã‚¹ã‚³ã‚¢ã¯ä»»æ„ã®1æ–‡å—ã®ãŸã‚ã“ã‚Œã‚‚ãƒ’ãƒƒãƒˆã™ã‚‹ã€‚ 2 _KONY SQL> select * from TBLNAME where STR like '#_%' escape '#'; ID STR ---------- ---------- 2 _KONYã€€ã€€ã€€â†ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹ã“ã¨ã«
kathew 2019/08/23
oracle

sql
ãƒªãƒ³ã‚¯
ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆãƒ»å‰Šé™¤ã™ã‚‹ï¼ˆCREATE TABLE / DROP TABLEï¼‰ - Oracle - Project Group
ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆ/å‰Šé™¤ã™ã‚‹SQLã€‚ ãƒ»è¡¨ã‚’ä½œæˆã™ã‚‹ï¼ˆè¡¨é ˜åŸŸã‚’æŒ‡å®šã—ãªã„å ´åˆã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¡¨é ˜åŸŸã«ä½œæˆã•ã‚Œã¾ã™ã€‚ï¼‰
kathew 2019/08/21
oracle

reference

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