[B! sql] jun-kunã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

jun-kun id:jun-kun

sqlã«é–¢ã™ã‚‹jun-kunã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (25)

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

SQL Server Management Studio ã‚’ä½¿ã„ã‚„ã™ãã™ã‚‹ãŸã‚ã®ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚º at SE ã®é›‘è¨˜
SQL Server Management Studio (SSMS) ã‚’ä½¿ç”¨ã™ã‚‹ãŸã‚ã«ã€å®Ÿæ–½ã—ã¦ã„ã‚‹è¨å®šã®ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ãŠããŸã„ã¨æ€ã„ã¾ã™ã€‚ æ°—ã¥ã„ãŸã¨ãã«ã„ã‚ã„ã‚ã¨è¿½è¨˜ã—ã¦ã„ã“ã†ã‹ã¨ã€‚ ã‚¹ãƒšãƒ¼ã‚¹ã®è¡¨ç¤º ã‚¯ã‚¨ãƒªã‚¨ãƒ‡ã‚£ã‚¿ã‚’é¸æŠž (ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã‚’å½“ã¦ãŸ) ã—ãŸçŠ¶æ…‹ã§ã€ã€Œç·¨é›†ã€â†’ã€Œè©³ç´°ã€ã‚’é¸æŠžã™ã‚‹ã¨ã€æ¬¡ã®ã‚ˆã†ãªãƒ¡ãƒ‹ãƒ¥ãƒ¼ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ (ã‚¯ã‚¨ãƒªã‚¨ãƒ‡ã‚£ã‚¿ã‚’é¸æŠžã—ã¦ã„ãªã„ã¨è¡¨ç¤ºã•ã‚Œã‚‹é …ç›®ãŒç•°ãªã‚Šã¾ã™) ã“ã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã€Œã‚¹ãƒšãƒ¼ã‚¹ã®è¡¨ç¤ºã€ã‚’æœ‰åŠ¹ã«ã™ã‚‹ã¨ã‚¯ã‚¨ãƒªã‚¨ãƒ‡ã‚£ã‚¿å†…ã®ãƒ†ã‚ã‚¹ãƒˆã«ã‚¹ãƒšãƒ¼ã‚¹ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ SSMS ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³è¨å®š SSMS ã®ã€Œãƒ„ãƒ¼ãƒ«ã€â†’ ã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ã§ã¯æ¬¡ã®ã‚ˆã†ãªè¨å®šã‚’å¤‰æ›´ã—ã¦ã„ã¾ã™ã€‚ ã€Œãƒ†ã‚ã‚¹ãƒˆ ã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã€â†’ã€Œå…¨ã¦ã®è¨€èªžã€ã®ã€Œè¡Œç•ªå·ã€ã‚’æœ‰åŠ¹åŒ–ã—ã€ãƒ†ã‚ã‚¹ãƒˆå†…ã«è¡Œç•ªå·ã‚’è¡¨ç¤º ã“ã®è¨å®šã‚’æœ‰åŠ¹åŒ–ã™ã‚‹ã“ã¨ã§ã€ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã«è¡Œç•ªå·ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™
jun-kun 2022/06/04
server

sql

SSMS

SQL Server
ãƒªãƒ³ã‚¯
SE ã®é›‘è¨˜
Written by Masayuki.Ozawa 12æœˆ 8th, 2022 at 9:51 am
jun-kun 2022/01/25
sql

SQL Server
ãƒªãƒ³ã‚¯
PostgreSQLã§SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„éšœå®³çŠ¶æ³èª¿æŸ»ã«ä½¿ã£ãŸã‚¯ã‚¨ãƒªé”ã¾ã¨ã‚ - $shibayu36->blog;
æœ€è¿‘PostgreSQLã§SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ã€DBãŒè©°ã¾ã£ãŸæ™‚ã®çŠ¶æ³èª¿æŸ»ã‚’ã„ã‚ã„ã‚ã‚„ã£ãŸã€‚ãã®æ™‚ã«ä¾¿åˆ©ã ã£ãŸã‚¯ã‚¨ãƒªé”ã‚’ã¾ã¨ã‚ã¦ã„ãã€‚PostgreSQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯9.6ç³»ã§ã™ã€‚ SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãªã©ã«ä¾¿åˆ©ã ã£ãŸã‚¯ã‚¨ãƒªé” ãã‚Œä»¥é™ã«å®Ÿè¡Œã™ã‚‹SQLã®å®Ÿè¡Œæ™‚é–“ã‚’è¡¨ç¤ºã™ã‚‹ã€‚å‚è€ƒ https://morumoru00.wordpress.com/2011/05/08/postgresql-sql%E5%87%A6%E7%90%86%E6%99%82%E9%96%93%E3%82%92%E8%AA%BF%E3%81%B9%E3%82%8B%EF%BC%88timing/ \timing å®Ÿéš›ã«ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¦å®Ÿè¡Œè¨ˆç”»ã‚„å®Ÿè¡Œæ™‚é–“ã‚’è¡¨ç¤ºã™ã‚‹ã€‚ã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•ã‚Œã‚‹ã®ã§ç ´å£Šçš„ãªæ“ä½œã‚‚å®Ÿè¡Œã•ã‚Œã¦ã—ã¾ã†ã“ã¨ã«æ³¨æ„ã€‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å¼µã£ã¦æœ€å¾Œã«ROLLBACKã—ã¾ã—ã‚‡ã†ã€‚å‚è€ƒ https://www.post
jun-kun 2021/06/03
sql

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

ãƒˆãƒ©ãƒ–ãƒ«

database

tips
ãƒªãƒ³ã‚¯
awesome-mysql-performance - MySQL/MariaDBã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãŸã‚ã®æƒ…å ±ã‚’ã¾ã¨ã‚ãŸãƒªãƒ³ã‚¯é›† | ã‚½ãƒ•ãƒˆã‚¢ãƒ³ãƒ†ãƒŠ
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã€ŒMySQLã€ã€‚ãã®æ´¾ç”Ÿç‰ˆã§ã‚ã‚‹ã€ŒMariaDBã€ã¨ã¨ã‚‚ã«é«˜é€Ÿã‹ã¤ç„¡æ–™ã§åˆ©ç”¨ã§ãã‚‹ã“ã¨ã‹ã‚‰é«˜ã„äººæ°—ã‚’é›†ã‚ã¦ã„ã¾ã™ã€‚ æœ¬æ—¥ç´¹ä»‹ã™ã‚‹ã€Œawesome-mysql-performanceã€ã¯ã€ãã‚Œã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æœ€é©åŒ–ã™ã‚‹ãŸã‚ã®æƒ…å ±ã‚’ã¾ã¨ã‚ãŸãƒªãƒ³ã‚¯é›†ã§ã™ã€‚ MySQLã‚„MariaDBã‚’å˜ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ä½¿ç”¨ã™ã‚‹ãŸã‚ã®æ–¹æ³•ã‚’èª¬æ˜Žã—ãŸæƒ…å ±ã¯ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆä¸Šã«å¤šæ•°å˜åœ¨ã—ã¾ã™ãŒã€ã‚ˆã‚Šæ·±ã„è¦‹è˜ãŒå¿…è¦ã¨ãªã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ”¹å–„ã®ãŸã‚ã®æƒ…å ±ã¯ã‚ã¾ã‚Šå¤šãã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã‚’é‹ç”¨ã—ã¦ã¿ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ä½Žä¸‹ã«æ‚©ã¾ã•ã‚Œã¦ã„ã‚‹æ–¹å¿…è¦‹ã®æƒ…å ±ã¨ã„ãˆãã†ã§ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼ã®è¨å®šã‹ã‚‰InnoDBã®æœ€é©åŒ– åŒãƒªãƒ³ã‚¯æ•°ã«ã¯ä»¥ä¸‹ã®æƒ…å ±ãŒå«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ Ten MySQL performance tuning settings after
jun-kun 2021/02/16
MySQL

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

sql
ãƒªãƒ³ã‚¯
DBCLI
We value the diversity of our community. We strive to amplify the voices of the oppressed to eradicate racism and xenophobia. We ask our community to stand together in support of the Black community. #BlackLivesMatter Projects PGCLI Postgres Client MYCLI MySQL Client LiteCLI SQLite Client MSSQL-CLI MS SQL Server Client IRedis Redis Client ATHENACLI AWS Athena Client pgspecial Postgres meta command
jun-kun 2019/11/02
sql

client

database
ãƒªãƒ³ã‚¯
SQLiteã‹ã‚‰CSVãƒ•ã‚¡ã‚¤ãƒ«ã«SQLã‚’æŠ•ã’ã¦ã¿ãŸ | DevelopersIO
SQLite3.14(å††å‘¨çŽ‡Ï€ã¨åŒã˜ã§ã™ã!)ãŒ2016/08/08ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã«ã‚ˆã‚‹ã¨ã€CSVä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾å¿œã—ãŸã¨ã‚ã‚Šã¾ã—ãŸã®ã§ã€æ—©é€Ÿä½¿ã£ã¦ã¿ã¾ã—ãŸã€‚ Added the CSV virtual table for reading RFC 4180 formatted comma-separated value files. ã“ã®æ©Ÿèƒ½ã‚’ä½¿ã†ã¨ã€CSVå½¢å¼ã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«SQLã§å•ã„åˆã‚ã›ã‚‹ã¨ã„ã£ãŸã“ã¨ãŒç°¡å˜ã«ã§ãã¾ã™ã€‚ ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦ ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«(Virtual Table)ã¯SQLiteã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ç®¡ç†ã•ã‚Œã¦ã„ãªã„ãƒ‡ãƒ¼ã‚¿ã‚’ä»®æƒ³çš„ã«ç®¡ç†ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«è¦‹ã›ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã™ã€‚ ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã§ç®¡ç†ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã¯ã€é€šå¸¸ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã¨åŒã˜ã‚ˆã†ã« SQL ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã§æ“ä½œã§ãã¾ã™ã€‚ SQLite ã§ã¯ å…¨æ–‡æ¤œç´¢ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ R-Trees
jun-kun 2016/08/16
é¢ç™½ãã†ã€‚

csv

sqlite

programming

SQL
ãƒªãƒ³ã‚¯
Big Sky :: UNIX ã‚³ãƒžãƒ³ãƒ‰ã‚’ SQL ã§æŠ½å‡ºã§ãã‚‹ãƒ„ãƒ¼ãƒ« qq ã‚’ä½œã£ãŸã€‚
æ˜¨æ—¥åƒ•ã® Twitter ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã§ q ã¨ã„ã†ãƒ„ãƒ¼ãƒ«ãŒè©±é¡Œã«ä¸ŠãŒã£ã¦ã„ã¾ã—ãŸã€‚ GitHub - harelba/q: q - Run SQL directly on CSV or TSV files Text as Data q is a command line tool that allows direct execution of SQL-like q... https://github.com/harelba/q æ¨™æº–å…¥åŠ›ã‚’ SQL ã§æŠ½å‡ºã§ãã‚‹ã¨ã„ã†ç‰©ã§ã™ã€‚ãŸã å€‹äººçš„ã«ã¯ã€Œã“ã†ã„ã†ã® python ã˜ã‚ƒãªãã¦ Go ã§ãƒ“ãƒ«ãƒ‰ã•ã‚Œã¦ã‚‹ã¨åŠ©ã‹ã‚‹ã‚ˆãªãƒ¼ã€ã¨æ€ã£ãŸã®ã§ q ã¨åŒã˜æ§˜ãªå‹•ä½œã«ãªã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ GitHub - mattn/qq Select stdin with query https://github.com/mattn/qq ä¾‹ãˆã° msys2 ã®ã‚·
jun-kun 2016/08/06
github

sql

ãƒ„ãƒ¼ãƒ«

command
ãƒªãƒ³ã‚¯
CSV/TSVã«å¯¾ã—ã¦SQLç™ºè¡Œã§ãã‚‹ãƒ„ãƒ¼ãƒ«ã€Œqã€ | DevelopersIO
ä»Šæ—¥ã¯CSV/TSVãªã©ã®ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’SQLã§æ“ä½œã§ãã‚‹ãƒ„ãƒ¼ãƒ«ã€Œqã€ã®ç´¹ä»‹ã§ã™ã€‚ ä½¿ã„ã©ã“ã‚ ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã‚’å®Ÿæ–½ã™ã‚‹æ™‚ã«ã¯DBã«ä¿å˜ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚„ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ãªã©ã‚’CSVã‚„TSVç‰ã®ä¸€å®šã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã«å¤‰æ›ã—ã¦å‡¦ç†ã™ã‚‹ã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚ãã®ãƒ‡ãƒ¼ã‚¿å†…å®¹ã‚’ç¢ºèªã™ã‚‹ã¨ãã«ã¯ã€ä¾‹ãˆã°Excelç‰ã«è²¼ã‚Šä»˜ã‘ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãŸã ã€Excelã§ã¯ãƒ‡ãƒ¼ã‚¿é‡ãŒæ•°ç™¾ä¸‡ä»¶è¦æ¨¡ã«ãªã£ã¦ãã‚‹ã¨ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®åˆ¶ç´„ä¸Šã€å‡¦ç†ãŒè¡Œãˆã¾ã›ã‚“ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã•ã‚Œã¦ã„ã‚‹å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‡¦ç†ãƒ»å–å¾—ã™ã‚‹éš›ã«ã‚ˆãç”¨ã„ã‚‰ã‚Œã‚‹ã®ã¯SQLã§ã™ã€‚SQLã¯ãƒ‡ãƒ¼ã‚¿æ“ä½œã®ãŸã‚ã®éžå¸¸ã«ã‚ˆãã§ããŸã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã§ã‚ã‚Šã€ã‹ãªã‚Šã®æ•°ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒåˆ©ç”¨ã§ãã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ å˜ç´”ãªCSVãƒ•ã‚¡ã‚¤ãƒ«ã«å¯¾ã—ã¦ã‚‚SQLã‚’åˆ©ç”¨ã—ã¦æ¤œç´¢ãŒå®Ÿæ–½ã§ãã‚Œã°æ¥½ã ã¨æ€ã£ã¦æŽ¢ã—ã¦ã„ãŸã¨ã“ã‚ã€ã€Œqã€ã«ãŸã©ã‚Šç€ãã¾ã—ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« qã«ã¯æ§˜ã€…ãªã‚¤
jun-kun 2015/11/21
ã“ã‚“ãªä¾¿åˆ©ãªã®ãŒã‚ã‚‹ã¨ã¯ã€‚ã€‚ã€‚

csv

sql

ãƒ„ãƒ¼ãƒ«

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

ã‚·ã‚¹ãƒ†ãƒ

q
ãƒªãƒ³ã‚¯
Oracleä½¿ã„ã®ãƒã‚¿å¸³
alter pluggable database ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆç’°å¢ƒã§ã¯ã€PDBï¼ˆãƒ—ãƒ©ã‚¬ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼‰ãŒè¤‡æ•°å˜åœ¨ã™ã‚‹å ´åˆãŒã‚ã‚‹ãŸã‚ã€ ç’°å¢ƒã«ã‚ã‚ã›ã¦èµ·å‹•åœæ¢ã‚³ãƒžãƒ³ãƒ‰ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä½¿ã„åˆ†ã‘ã‚‹å¿…è¦ãŒã‚ã‚‹ [â€¦]
jun-kun 2014/06/12
oracle

SQL

tips
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«
A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
jun-kun 2014/04/29
sql

tool

database

DB

windows
ãƒªãƒ³ã‚¯
GitHub - dinedal/textql: Execute SQL against structured text like CSV or TSV
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
jun-kun 2014/02/05
ãŠã‰ã€ã‚¹ã‚´ã‚¤ãªã

sql

csv
ãƒªãƒ³ã‚¯
RDBMSã«é–¢ã™ã‚‹å…¸åž‹çš„ãªèª¤è§£ãŒçµ¶ãˆãªã„ã¨ã„ã†ç¾å®Ÿ
æ–°å…¥ç¤¾å“¡å¿…èªã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŸºæœ¬ã‚’ç†è§£ã—ã‚ˆã† - ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãªãœå¿…è¦ãªã®ï¼Ÿï¼šITproã¨ã„ã†è¨˜äº‹ã«å¯¾ã™ã‚‹ãƒ–ã‚¯ãƒžã§æ¬¡ã®ã‚ˆã†ãªIDã‚³ãƒ¼ãƒ«ãŒæ¥ãŸã€‚ï¼ˆç¾åœ¨ã¯ã‚³ãƒ¡ãƒ³ãƒˆè¿”ã—ã¸ã®ãŠç¤¼ãŒå…¥ã£ã¦ã„ã‚‹ã®ã§ã€æ–‡å—æ•°åˆ¶é™ã®ãŸã‚ã‚ªãƒªã‚¸ãƒŠãƒ«ã®ã‚³ãƒ¡ãƒ³ãƒˆã¯å°‘ã—åˆ‡ã‚Šè©°ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ï¼‰ "ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’2æ¬¡å…ƒã®è¡¨å½¢å¼ã§è¡¨ç¾"ã“ã†ã„ã†ã®ã‚‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒ2æ¬¡å…ƒæ§‹é€ ã¨ã„ã†èª¤è§£ã®ä¸€ç¨®ãªã‚“ã ã‚ã†ã‹ã€‚id:nippondanjiã•ã‚“ãŒæ›¸ã„ã¦ãŸã‚ˆã†ãªã€‚ ã•ã¦ã€ã“ã®ç–‘å•ã«å¯¾ã™ã‚‹æ£è§£ã¯å¦‚ä½•ãªã‚‹ã‚‚ã®ã ã‚ã†ã‹ï¼Ÿ ã¤ã„å…ˆæ—¥ã€Œ7ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 7ã¤ã®ä¸–ç•Œã€ã®æ›¸è©•ã§æ›¸ã„ãŸã°ã‹ã‚Šã ãŒãƒ»ãƒ»ãƒ» è¨€ã†ã¾ã§ã‚‚ãªããã®é€šã‚Šã§ã‚ã‚‹ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒ2æ¬¡å…ƒçš„ãªæ§‹é€ ã‚’æŒã£ã¦ã„ã‚‹ã¨ã„ã†ã®ã¯å…¸åž‹çš„ãªèª¤è§£ã ã€‚ï¼ˆã¡ãªã¿ã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®æ¬¡å…ƒã¯å±žæ€§ã®æ•°ã«ç‰ã—ã„ã€‚nå€‹ã®å±žæ€§ãŒã‚ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã¯næ¬¡å…ƒã€‚ï¼‰ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦ã¡ã‚ƒã‚“ã¨å¦ç¿’ã—ã¦ã„
jun-kun 2013/04/23
ãªã‚“ã¨ãªããƒœãƒ³ãƒ¤ãƒªã¨ã¯ã‚ã‹ã£ã¦ã‚‹ã¤ã‚‚ã‚Šã ã‘ã©ã€ã†ã¾ãèª¬æ˜Žå‡ºæ¥ãªã„ã€‚å¤šåˆ†ç†è§£å‡ºæ¥ã¦ãªã„ã‹ã‚‰ã ãª(^_^;)

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

database

RDBMS

sql

ã‚ã¨ã§èªã‚€

å¦ç¿’
ãƒªãƒ³ã‚¯
tweets.zipã‚’MySQLã«çªã£è¾¼ã‚“ã§SQLã‚’å¦ã¶(å°Žå…¥ç·¨) Â· ã•ã‚ˆãªã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ
April 4, 2013 Twitterã®éŽåŽ»ãƒã‚°ãŒè½ã¨ã›ã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã§ SQLã«å¦ã¶ã«ã¯ä¸åº¦ã„ã„ã‚„ã€‚ã¨ã„ã†ã“ã¨ã§ ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«OSXä¸Šã§homebrewã‚’ä½¿ã£ã¦MySQLã«å…¥ã‚Œã¦ã¿ã¾ã—ãŸã€‚ MySQL ver.5.6 (homebrew install) OS / OSX 10.8.3 ãªã«ã¯ã¨ã‚‚ã‚ã‚Œã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ Twitterã®å€‹äººè¨å®šã£ã½ã„ã¨ã“ã‚ã‹ã‚‰ ãƒãƒãƒãƒã™ã‚‹ã¨ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ãŒè²¼ã‚‰ã‚ŒãŸãƒ¡ãƒ¼ãƒ«ãŒé€ã‚‰ã‚Œã¦ãã‚‹ã®ã§ ãƒãƒãƒãƒã—ã¦tweets.zipã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€‚ tweets.csvã‚’æŽ¢ã™ tweets.zipã‚’è§£å‡ã™ã‚‹ã¨ã€ä¸èº«ãŒã“ã‚“ãªæ„Ÿã˜ã«å‡ºã¦ãã¦ index.htmlã‚’ãƒ–ãƒ©ã‚¦ã‚¶ã§é–‹ãã¨ã€éŽåŽ»ã®ãƒ„ã‚¦ã‚£ãƒ¼ãƒˆãŒè¦‹ã‚ŒãŸã‚Šã—ã¾ã™ã€‚ æ™‚é–“æ³¥æ£’ãªã®ã§ãŠã™ã™ã‚ã—ã¾ã›ã‚“ ãã—ã¦ã€tweets.csvãŒç›®çš„ã®ãƒ•ã‚¡ã‚¤ãƒ«ã§ã€ä¸èº«ã‚’é–‹ãã¨ "tweet_id","in_reply_t
jun-kun 2013/04/05
ã“ã‚Šã‚ƒãªã‹ãªã‹é¢ç™½ã„ãƒ(*^_^*)

mysql

twitter

*ã‚ã¨ã§èªã‚€

SQL

database

csv
ãƒªãƒ³ã‚¯
ã‚¤ãƒã‹ã‚‰ã¯ã˜ã‚ã‚‹ - SQL ãƒ¬ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
SQLãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒ»ã‚¬ã‚¤ãƒ‰ - ã‚¤ãƒã‹ã‚‰ã¯ã˜ã‚ã‚‹.
jun-kun 2013/01/30
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sql

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

reference
ãƒªãƒ³ã‚¯
SQLã«ã‚ˆã‚‹æ¡ä»¶ä»˜ãé‡è¤‡ãƒ‡ãƒ¼ã‚¿ã®æŠ½å‡ºã¨å˜ç´”ãªåå¯„ã›
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
jun-kun 2012/09/20
sql

tips

åå¯„ã›
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
jun-kun 2011/08/24
ã¡ã‚‡ã£ã¨é¢ç™½ã„

sql

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ãƒã‚¿

æ£è¦è¡¨ç¾

SQL-tutorial
ãƒªãƒ³ã‚¯
SHIFT the Oracle - Oracle DBA, Oracle SQL and PL/SQL Tips
Oracle DBA, Oracle SQL and PL/SQL Tips Top ï½œ Knowledgeï½œ DBæ§‹ç¯‰ï½œ æ–‡å—åˆ—é–¢æ•°ï½œ æ—¥ä»˜é–¢æ•°ï½œ é›†è¨ˆé–¢æ•°ï½œ SQLé–¢æ•°ï¼ˆã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆé †ï¼‰ SQLï¼ˆæŠ½å‡ºãƒ»æ›´æ–°ï¼‰ï½œ SQL*Plusï½œ PL/SQLï½œ Utilityï½œ Structureï½œ ã‚¹ã‚ãƒ¼ãƒžï½œ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï½œ ç”¨èªžï½œ å‚è€ƒæ›¸ SHIFT the Oracle ã‚ªãƒ©ã‚¯ãƒ«ãƒžã‚¹ã‚¿ãƒ¼ã®å–å¾—ã‚„æ¥å‹™ã§ã‚ªãƒ©ã‚¯ãƒ«ã‚’ä½¿ã£ã¦é–‹ç™ºã—ã¦ã„ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ç›®æŒ‡ã—ã¦ã„ã‚‹äººã®ãŸã‚ã®ã‚µã‚¤ãƒˆ ã‚ªãƒ©ã‚¯ãƒ«å…¥é–€è€…å‘ã‘ã® Oracle SQL å…¥é–€ã€PL/SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‹ã‚‰åˆæ©çš„ãªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»é‹ç”¨ã«é–¢ã™ã‚‹æƒ…å ±ã€SQL ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚„ã‚µãƒ³ãƒ—ãƒ«ã€Oracle Tips ã‚’å–ã‚Šæ‰±ã£ã¦ã„ã¾ã™ IT News Oracle Database 18c XE å…¬é–‹ Oracle Database Blog 2018/
jun-kun 2011/08/22
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

tips

sql

reference
ãƒªãƒ³ã‚¯
SQL Server ã§æ–‡å—åˆ—ã®åŠè§’ï¼å…¨è§’å¤‰æ› | Sunvisor Lab.
SQL Server 2005 ã®ã‚µãƒ¼ãƒãƒ¼å´ã®é–¢æ•°ã§ï¼Œæ–‡å—åˆ—ã®åŠè§’ï¼å…¨è§’å¤‰æ›ã‚’ã—ãŸã„ã¨ãšã£ã¨æ€ã£ã¦ã„ã¾ã—ãŸã€‚ãƒãƒƒãƒˆã§ã‚°ã‚°ã‚‹ã¨ï¼Œã€ŒSQL Server ã«ã¯ãã®æ©Ÿèƒ½ãŒãªã„ã®ã§ï¼ŒREPLACEé–¢æ•°ã‚’ç¾…åˆ—ã—ã¦è§£æ±ºã™ã‚‹ã—ã‹ãªã„ã€ã¨ã„ã†è¨˜äº‹ï¼ˆãƒ‡ãƒ¼ã‚¿ã®å…¨è§’åŠè§’å¤‰æ›ã€ã€ ï¼ Database Expert ï¼ ï¼ ITï¼‰ã«å½“ãŸã‚Šï¼Œãã®ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿè£…ã—ãŸè¨˜äº‹ï¼ˆSQLServerã§ã®æ–‡å—åˆ—ã®åŠè§’æ–‡å—ã‹ã‚‰å…¨è§’æ–‡å—ã¸ã®å¤‰æ›ï¼‰ã«å½“ãŸã‚Šã¾ã—ãŸã€‚ç¢ºã‹ã«T-SQLã§å®Ÿè£…ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ï¼Œãã®æ–¹æ³•ã—ã‹ãªã„ã§ã—ã‚‡ã†ã€‚ã—ã‹ã—ï¼Œã‚ã¾ã‚Šã«ã‚ã¾ã‚ŠãªåŠ›æ¥(^^; ä¸€æ–¹ï¼ŒSQL Server 2005 ã‹ã‚‰ã¯SQLCLRã¨ã„ã†ã®ãŒä½¿ãˆã‚‹ã¯ãšã§ã™ã€‚ãã‚Œã‚’ä½¿ãˆã°VB.NETã§æ›¸ã„ãŸé–¢æ•°ã‚’ï¼Œã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰ã®é–¢æ•°ã«ã§ãã‚‹ã¯ãšã€‚Accessã®MDBã‚’ä½¿ã£ã¦ã„ã‚‹å ´åˆã«ã¯ï¼Œã‚¯ã‚¨ãƒªã®ä¸ã§Access VBAã®é–¢æ•°ã‚’ä½¿ãˆã‚‹ã®ã§ï¼ŒStrConvé–¢æ•°ã‚’ä½¿ã£ã¦ç°¡å˜
jun-kun 2011/04/12
sql

SQL Server

ãƒ—ãƒã‚°ãƒ©ãƒ

SQLserver

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

åŠè§’
ãƒªãƒ³ã‚¯
SQLServerãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€
ã€SQLServerãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€ã€‘ã§ã¯ã€SqlServeråŸºç¤ŽçŸ¥è˜ã‹ã‚‰ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ãƒ»ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ã‚³ãƒ”ãƒ¼ãƒ»ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãªã©ã€SqlServerã§ä½¿ç”¨ã§ãã‚‹SQLæ–‡ãªã©ã®æƒ…å ±ã‚’ã‚ã‹ã‚Šã‚„ã™ãã”ç´¹ä»‹ã—ã¾ã™ã€‚
jun-kun 2010/01/22
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

å…¥é–€

sql

sql server

SQLserver

*ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
1GBãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ãƒ»ãƒ—ãƒãƒã‚¤ãƒ€ãƒ¼ Amusement BiG-NET | www7.big.or.jp/~pinball/discus/sqls/31963.html
jun-kun 2010/01/21
tips

memo

sql

db

*ãƒ¡ãƒ¢

ãƒ„ãƒ¼ãƒ«

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸