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

kanbayashi id:kanbayashi

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

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

mysqldumpã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼†å¾©å…ƒ - phpspot
mysqldumpã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã€SQLãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒå¯èƒ½ã§ã™ã€‚å˜åœ¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ã™ã¹ã¦ï¼³ï¼±ï¼¬ã«ã—ã¦ãƒ†ã‚ã‚¹ãƒˆå½¢å¼ã«ä¿å˜ã§ãã¾ã™ã€‚
kanbayashi 2016/10/20
db

mysql

mysqldump

sql
ãƒªãƒ³ã‚¯
MySQLã§ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã®å€¤ã‚’ãƒªã‚»ãƒƒãƒˆã™ã‚‹æ–¹æ³• - ä¸‰åè·¯ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å‚™å¿˜éŒ²+Î±
ALTER TABLE `ãƒ†ãƒ¼ãƒ–ãƒ«å` AUTO_INCREMENT = æ¬¡ã®ç•ªå·ã«ã—ãŸã„æ•°å€¤ MySQLã§idãªã©ã®ã‚«ãƒ©ãƒ ã®å€¤ã‚’æŒ¿å…¥æ™‚ã«è‡ªå‹•çš„ã«å¢—ã‚„ã—ã¦ã„ãè¨å®šï¼ˆã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆï¼‰ã«ã—ã¦ã„ã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ãŸã ãƒ†ã‚¹ãƒˆãªã©æŒ¿å…¥ã—ãŸè¡Œã‚’å‰Šé™¤ã—ãŸå ´åˆã€ã€Œæ¯æŠœã‘ã€ãŒç™ºç”Ÿã—ã¦ã—ã¾ã„ã¾ã™ã€‚ã“ã‚Œã‚’æ”¹å–„ã™ã‚‹ã®ãŒä¸Šè¨˜ã‚³ãƒžãƒ³ãƒ‰ã§ã™ã€‚ ãŸã¨ãˆã°idã‚«ãƒ©ãƒ ã®å€¤ãŒæ¬¡ã®ã‚ˆã†ã«ãªã£ã¦ãŠã‚Šã€ã€Œ6,7,8ã€ã‚’å‰Šé™¤ã—ã€æ–°ãŸã«è¡Œã‚’æŒ¿å…¥ã—ãŸå ´åˆæ¬¡ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ id=1,2,3,4,5,6,7,8 â†“ï¼ˆæŒ¿å…¥ï¼‰ id=1,2,3,4,5,9 ãã“ã§ã€Œ6,7,8ã€ã‚’å‰Šé™¤ã—ãŸã‚ã¨ä¸Šè¨˜ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿæ–½ã—ã¦ã‚„ã‚‹ã¨æ¯æŠœã‘ãŒãªããªã‚Šã¾ã™ã€‚ id=1,2,3,4,5,6,7,8 â†“ ALTER TABLE `ãƒ†ãƒ¼ãƒ–ãƒ«å` AUTO_INCREMENT = 6 â†“ï¼ˆæŒ¿å…¥ï¼‰ id=1,2,3,4,5,6 1ç¥¨ãƒãƒãƒƒã¨æŠ¼ã—ã¦ä¸‹ã•ã„â™ªã“ã®ãƒ–ãƒã‚°
kanbayashi 2010/12/19
db

mysql

sql

auto increment

auto_increment
ãƒªãƒ³ã‚¯
ã‚°ãƒ¼ã‚°ãƒ«ã«ã‚ˆã‚‹MapReduceã‚µãƒ¼ãƒ“ã‚¹ã€ŒBigQueryã€ãŒç™»å ´ã€‚SQLãƒ©ã‚¤ã‚¯ãªå‘½ä»¤ã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿æ“ä½œ
ã€Œæ•°å…†ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚‚å¯¾è©±çš„ã«ã€é«˜é€Ÿã«åˆ†æžã§ãã‚‹ã€ã€‚ã‚°ãƒ¼ã‚°ãƒ«ã¯5æœˆ19æ—¥ã«ã“ã®ã‚ˆã†ãªè¡¨ç¾ã§æ–°ã—ã„ã‚µãƒ¼ãƒ“ã‚¹ã€ŒBigQueryã€ã®ç™»å ´ã‚’ç´¹ä»‹ã™ã‚‹ã‚¨ãƒ³ãƒˆãƒªã‚’ã€ãƒ–ãƒã‚°ã«ãƒã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ ã‚°ãƒ¼ã‚°ãƒ«ãŒå…¬é–‹ã—ãŸBigQueryã¯ã€Hadoopã‚„ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ãªã©ã‚’ç”¨ã„ã¦å¤šãã®ä¼æ¥ãŒè¡ŒãŠã†ã¨ã—ã¦ã„ã‚‹å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ï¼ˆã„ã‚ã‚†ã‚‹ã€ŒBig Dataã€ï¼‰ã®åˆ†æžã‚’ã€ã‚°ãƒ¼ã‚°ãƒ«ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã§å¯èƒ½ã«ã—ã¾ã™ã€‚åˆ©ç”¨è€…ã¯Google StorageçµŒç”±ã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚’è»¢é€ã—ã€SQLãƒ©ã‚¤ã‚¯ãªå‘½ä»¤ã«ã‚ˆã£ã¦æŠ½å‡ºã‚„åˆ†æžã‚’è¡Œã„ã¾ã™ã€‚ ã¾ã‚‹ã§ã‚°ãƒ¼ã‚°ãƒ«ãŒå¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®MapReduceã‚’ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã—ã€ãã®æ©Ÿèƒ½ã‚’ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦æä¾›ã™ã‚‹ã‚ˆã†ãªã‚‚ã®ãŒBigQueryã¨ã„ãˆã¾ã™ï¼ˆãŸã ã—å…¬é–‹ã•ã‚ŒãŸã€ŒBigQueryã€ã®èª¬æ˜Žã«ã¯ã€å†…éƒ¨ã§MapReduceã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã‹ã©ã†ã‹ã®è¨˜è¿°ã¯ãªã„ã®ãŸã‚ã€MapReduceã€Œçš„ã€ãªã‚µãƒ¼ãƒ“ã‚¹ã¨è¡¨ç¾ã™ã¹ãã‹ã‚‚ã—ã‚Œ
kanbayashi 2010/05/26
google

map reduce

google storage

sql
ãƒªãƒ³ã‚¯
Microsoftã€ã€ŒWindows Azureã€ã®æ¦‚è¦ã¨æ–™é‡‘ã‚’ç™ºè¡¨
Amazonã‚„Salesforceã«å¯¾æŠ—ã™ã‚‹Microsoftã®ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã€ŒWindows Azureã€ã®æ¦‚è¦ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚ ç±³Microsoftã¯7æœˆ14æ—¥ã€ãƒ‹ãƒ¥ãƒ¼ã‚ªãƒªãƒ³ã‚ºã§é–‹å‚¬ã®å¹´æ¬¡ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒWorldwide Partner Conference 2009ã€ã«ãŠã„ã¦ã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã€ŒWindows Azure Platformã€ã®æ¦‚è¦ã¨åˆ©ç”¨ä¾¡æ ¼ã‚’ç™ºè¡¨ã—ãŸã€‚ åŒãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã¯ã€ã‚¯ãƒ©ã‚¦ãƒ‰OSã®ã€ŒWindows Azureã€ã¨ã€ŒLive Servicesã€ã€ŒMicrosoft SQL Azureã€ã€ŒMicrosoft .NET Servicesã€ã€ŒMicrosoft SharePoint Services & Dynamics CRM Servicesã€ã¨ã„ã†5ã¤ã®ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã§æ§‹æˆã•ã‚Œã‚‹ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã€‚ Windows Azureã€SQL Azureã€.NET Se
kanbayashi 2009/07/15
ã‚¯ãƒ©ã‚¦ãƒ‰OSã®ã€ŒWindows Azureã€ã€Live Servicesã£ã¦ä½•ã ï¼Ÿ

cloud coputing

cloud

ms

azure

sql
ãƒªãƒ³ã‚¯
é³¥ç£ä¿è·åŒº | places.sqlite ã®æœ€é©åŒ–ã§ Firefox 3 ã¯é€Ÿããªã‚‹â€¦ã‹ï¼Ÿ
Firefox 3 ã§ã¯å±¥æ´ã¨ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚’çµ±åˆã—ãŸ Places ã‚’å§‹ã‚ã€æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ãŒ SQLite ã§ç®¡ç†ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ä¸€ãƒ¦ãƒ¼ã‚¶ã¨ã—ã¦ã¯ä¾¿åˆ©ã«ãªã‚‹ãªã‚‰ä½•ã§ã‚‚ã„ã„ã‚“ã§ã™ãŒã€ãªã‚“ã¨ãªãæ°—ã«ãªã‚‹ã®ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã®è‚¥å¤§æ–ç‰‡åŒ–ã«ã‚ˆã‚‹é€Ÿåº¦ä½Žä¸‹ã€‚ ã“ã‚Œã‚’è§£æ¶ˆã™ã‚‹ã«ã¯ vacuum ã‚³ãƒžãƒ³ãƒ‰ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å†æ§‹ç¯‰ã™ã‚Œã°ã„ã„ã‚ˆã†ã§ã€ã“ã‚Œã¯ä»¥å‰ã« Mail.app ã®é«˜é€ŸåŒ– Tips ã¨ã—ã¦ã‚‚æµè¡Œã‚Šã¾ã—ãŸã€‚Mail.app ã®å ´åˆã‹ãªã‚ŠåŠ¹æžœãŒã‚ã‚‹ã‚ˆã†ã§ã€‚ Hawk Wings Â» Blog Archive Â» A faster way to speed up Mail.app OS X ãƒãƒƒã‚ãƒ³ã‚°! (236) SQLiteãŒåºƒã’ã‚‹ã“ã‚Œã‹ã‚‰ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ« I deleted a lot of data but the database file di
kanbayashi 2009/07/07
firefox

*tips

sql

sqlite
ãƒªãƒ³ã‚¯
ã€YQL é€Ÿæ”»ãƒ¬ãƒ“ãƒ¥ãƒ¼ã€‘ç±³ Yahoo! ãŒ SQL ã£ã½ãè‰²ã‚“ãªãƒ‡ãƒ¼ã‚¿ã‚’å–ã£ã¦ã“ã‚Œã‚‹APIã‚’å‡ºã—ãŸ - ã¦ã£ãç…®ãƒ–ãƒã‚°
ç±³ Yahoo! ãŒ Yahoo! Pipes ã¿ãŸã„ã«è‡ªç”±åº¦ãŒé«˜ãã¦ã€ã¾ãŸã¡ã‚‡ã£ã¨æ¯›è‰²ãŒé•ã†ã‚µãƒ¼ãƒ“ã‚¹ãŒå‡ºã¦ããŸã€‚é¡Œã—ã¦ã€Yahoo! Query Languageã€‚YQL ã¨å‘¼ã¶ã‚ˆã†ã ã€‚SQL é¢¨ã®è¨€èªžã‚’ REST ã§æŠ•ã’ã¦ã€çµæžœã‚’ XML ã‚„ JSON ã§å—ã‘å–ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚å…·ä½“çš„ã«ã‚„ã£ã¦ã¿ãªã„ã¨åˆ†ã‹ã‚Šã«ãã„ã®ã§ã€ã¨ã‚Šã‚ãˆãšè©¦ã—ã¦ã¿ãŸã€‚RSS ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿å–å¾—YQL ã‚’ä½¿ã£ã¦ RSS ã‹ã‚‰æœ€æ–°ã®ã‚¿ã‚¤ãƒˆãƒ«10å€‹ã‚’å–ã£ã¦ãã¦ã¿ã‚‹ã€‚ã“ã‚“ãª YQL ã«ãªã‚‹ã‚‰ã—ã„ã€‚ select title from rss where url='http://d.hatena.ne.jp/nitoyon/rss' rss ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ select ã‚’ç™ºè¡Œã—ã¦ã„ã‚‹ã€‚å®Ÿéš›ã«ã“ã® YQL ã‚’è©¦ã™ã«ã¯ YQL ç”¨ã® console ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã‚ˆã„ã€‚ï¼ˆâ€»è¦ãƒã‚°ã‚¤ãƒ³ï¼‰console ã®å·¦ä¸Šã« YQL ã‚’å…¥åŠ›ã—ã¦
kanbayashi 2008/12/16
*ã“ã‚Œã¯ã™ã”ã„

sql

yahoo

yql

rss

yahoo pipes
ãƒªãƒ³ã‚¯
Wikipedia Data Download Page
../ jawiki-latest-all-titles-in-ns0.gz 20-Dec-2025 19:30 15443719 jawiki-latest-all-titles-in-ns0.gz-rss.xml 20-Dec-2025 19:30 775 jawiki-latest-all-titles.gz 20-Dec-2025 19:31 28596076 jawiki-latest-all-titles.gz-rss.xml 20-Dec-2025 19:31 754 jawiki-latest-babel.sql.gz 20-Dec-2025 17:09 7629 jawiki-latest-babel.sql.gz-rss.xml 20-Dec-2025 19:30 751 jawiki-latest-category.sql.gz 20-Dec-2025 17:07 4
kanbayashi 2008/07/20
wikipedia

download

data

sql

db
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
kanbayashi 2006/10/16
db

mySQL

sql

*ã“ã‚Œã¯ã™ã”ã„
ãƒªãƒ³ã‚¯
1