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

toton id:toton

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

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

æ–°ã—ã„æ¥ç•Œæ¨™æº–ã€ŒSQL99ã€è©³ç´°è§£èª¬
ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã€Javaã‚’å–ã‚Šå…¥ã‚ŒãŸ æ–°ã—ã„æ¥ç•Œæ¨™æº–ã€ŒSQL99ã€è©³ç´°è§£èª¬ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹ã‚¢ã‚¯ã‚»ã‚¹è¨€èªžã¨ã—ã¦æˆåŠŸã—ã¦ã„ã‚‹æ¥ç•Œæ¨™æº–ã® ã€ŒSQLã€ãŒã€ 7å¹´ã¶ã‚Šã«æ”¹è¨‚ã®æ™‚æœŸã‚’è¿ŽãˆãŸã€‚ æ–°ã—ãç™»å ´ã™ã‚‹ã€ŒSQL99ã€ã§ã¯ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã‚„Javaã‚’å–ã‚Šå…¥ã‚ŒãŸã‚‚ã®ã¨ãªã‚Šã€ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãªãƒ‡ãƒ¼ã‚¿ã®ã¿ãªã‚‰ãšã€ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹ä¸€èˆ¬ã«åºƒãåˆ©ç”¨ã•ã‚Œã‚‹ ã‚¢ã‚¯ã‚»ã‚¹è¨€èªžã¨ã—ã¦ã®åœ°ä½ã‚’ç›®æŒ‡ã—ãŸã‚‚ã®ã¨ãªã£ã¦ã„ã‚‹ã€‚ ã“ã“ã§ã¯ãã®è©³ç´°ã‚’3ç« ã«åˆ†ã‘ã¦èª¬æ˜Žã—ã¦ã„ã“ã† å®¤ä½æ£æ™´ï¼‹æ¾å±…ç”±ç¾Žå æ—¥æœ¬IBMã‚·ã‚¹ãƒ†ãƒ ã‚ºãƒ»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚° 2000/6/4ï¼ˆï¼ ITæŽ²è¼‰ï¼‰ 1999/10/24ï¼ˆINTEROP MAGAZINEåˆå‡ºï¼‰ ï¼ˆæœ¬è¨˜äº‹ã¯ã€ã‚½ãƒ•ãƒˆãƒãƒ³ã‚¯ãƒ»ãƒ‘ãƒ–ãƒªãƒƒã‚·ãƒ³ã‚°ç™ºè¡Œã®ã€ŒINTEROP MAGAZINEã€ 1999å¹´12æœˆå·ã‹ã‚‰3å›žé€£è¼‰ã•ã‚ŒãŸåŒåã®è¨˜äº‹ã‚’ã€ç†è€…ã€ç·¨é›†éƒ¨ã®ã”åŽšæ„ã«ã‚ˆã‚ŠæŽ²è¼‰ã®è¨±è«¾ã‚’ã„ãŸã ã„ãŸã‚‚ã®ã§ã™ã€‚ä¸€éƒ¨å†ç·¨
toton 2009/07/18
sql

db
ãƒªãƒ³ã‚¯
SQLã§FIFOã‚’å®Ÿç¾ã™ã‚‹(Firebird/MySQL/PostgreSQL) | ã‚ãƒ ãƒ©ãƒ‡ãƒ¼ãƒ“ãƒ¼ãƒ–ãƒã‚°
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åŠ é€Ÿã™ã‚‹ã€Œã‚ãƒ ãƒ©ãƒ‡ãƒ¼ãƒ“ãƒ¼ã€ã®ãƒ–ãƒã‚°ã§ã™ã€‚ã‚«ãƒ¬ãƒ¼æ—¥è¨˜ã‚’å…¼ãã¦ã¾ã™ã€‚ãªãŠè‘—è€…ã¯2010-06-01ã‚ˆã‚Šæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã«åœ¨ç±ã—ã¦ã„ã¾ã™ãŒã€æœ¬ã‚µã‚¤ãƒˆï¼ˆãƒ–ãƒã‚°ã€ã¾ãŸã¯ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆï¼‰ã«ãŠã„ã¦ç¤ºã•ã‚Œã¦ã„ã‚‹è¦‹è§£ã¯ã€ç§è‡ªèº«ã®è¦‹è§£ã§ã‚ã£ã¦ã€ã‚ªãƒ©ã‚¯ãƒ«ã®è¦‹è§£ã‚’å¿…ãšã—ã‚‚åæ˜ ã—ãŸã‚‚ã®ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã¡ã‚‡ã£ã¨å¿…è¦ãŒã‚ã£ã¦ã€ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’SQLã§æ›¸ã„ã¦ã¿ã‚‹ã€ãªã‚“ã¦ã“ã¨ã‚’ã—ã¦ã„ãŸã€‚ã€ŒFIFOã‚’SQLã§æ›¸ã„ãŸã‚‰ï¼Ÿã€ã¨ã„ã†ãƒã‚¿ã‚’æŽ¢ã—ã¦ã„ãŸã‚‰ã€æ‰‹å…ƒã®æœ¬ã«ã¯ã“ã‚“ãªã®ãŒã‚ã£ãŸã€‚ Andrew Cumming/Gordon Russell ã€ŒSQL HACKSã€(ã‚ªãƒ©ã‚¤ãƒªãƒ¼ãƒ»ã‚¸ãƒ£ãƒ‘ãƒ³, 2007) ã€ŒHACK#86 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ãƒ¥ãƒ¼ã‚’åˆ©ç”¨ã™ã‚‹ã€ ãŸã ã€ã“ã®ä¾‹ã¯ã¡ã‚‡ã£ã¨ã‚ã‹ã‚Šã«ããã€ç´”ç²‹ã«FIFOã‚’èª¬æ˜Žã—ãŸã‚Šã™ã‚‹ã®ã«ã¯ä¸å‘ãã‹ãªãƒ¼ã€ã¨åˆ¥ã®ãƒã‚¿ã‚’æŽ¢ã—ãŸã¨ã“ã‚ã€ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã‚’ç™ºè¦‹ã€‚ How to imple
toton 2008/10/25
MERGEæ–‡

sql
ãƒªãƒ³ã‚¯
LINQ(Language Integrated Query) for PHP - Do You PHP ã¯ã¦ãƒ–ãƒ
ã™ã¿ã¾ã›ã‚“ã€‚LINQã£ã¦åˆã‚ã¦è¦‹ã¾ã—ãŸï¼ˆå¤šåˆ†ï¼‰ã€‚C#æ–¹é¢ã®æ©Ÿèƒ½ï¼ˆï¼Ÿï¼‰ã¿ãŸã„ã§ã™ã€‚ã§ã€ã“ã‚Œã‚’PHPã§éƒ¨åˆ†çš„ã«å®Ÿè£…ã—ã¦ã¿ãŸæ–¹ï¼ˆãƒ™ãƒ«ã‚®ãƒ¼ã®æ–¹ã§ã™ã‹ãï¼‰ãŒã„ã‚‰ã£ã—ã‚ƒã‚‹ã‚ˆã†ã§ã™ã€‚ Perhaps you have already heard of C# 3.5's "LINQ" component. LINQ, or Language Integrated Query, is a component inside the .NET framework which enables you to perform queries on a variety of data sources like arrays, XML, SQL server, ... These queries are defined using a syntax which is very similar to SQL. There
toton 2008/09/23
LINQ(Language Integrated Query) for PHP

php

sql
ãƒªãƒ³ã‚¯
ç‰¹é›† SQL Server 2005ã®æ–°æ©Ÿèƒ½ã€ŒSQL CLRã€ï¼ˆå‰ç·¨ï¼‰ï¼ˆ1/3ï¼‰ - ï¼ IT
ç‰¹é›† SQL Server 2005ã®æ–°æ©Ÿèƒ½ã€ŒSQL CLRã€ï¼ˆå‰ç·¨ï¼‰ SQL Serverãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’é©æ–°ã™ã‚‹SQL CLRã¨ã¯ï¼Ÿ ä¸ åšä¿Šï¼ˆMicrosoft MVP 2005 - Visual C#ï¼‰ 2005/03/09 ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒæä¾›ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚µãƒ¼ãƒã€ŒMicrosoft SQL Serverã€ï¼ˆä»¥é™ã€SQL Serverï¼‰ã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹SQL Server 2005ï¼ˆé–‹ç™ºã‚³ãƒ¼ãƒ‰åï¼šYukonï¼‰ã§ã¯ã€.NET Frameworkã®å…±é€šè¨€èªžãƒ©ãƒ³ã‚¿ã‚¤ãƒ ï¼ˆCLRï¼šCommon Language Runtimeï¼‰ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«çµ±åˆã•ã‚ŒãŸã€ŒSQL CLRã€ã¨ã„ã†æ–°æ©Ÿèƒ½ãŒæä¾›ã•ã‚Œã‚‹ã€‚ã“ã‚Œã«ã‚ˆã‚Šã€SQL Serverã¯.NETãƒ—ãƒã‚°ãƒ©ãƒ ã¨ç·Šå¯†ã«é€£æºã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ ãã“ã§æœ¬ç¨¿ã§ã¯ã€ãã®SQL CLRãŒä¸€ä½“ã©ã®ã‚ˆã†ãªã‚‚ã®ãªã®ã‹ã€ã¾ãŸãã‚Œã«ã‚ˆã£ã¦.NETã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™
toton 2008/09/13
SQL CLR

.net

sql
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬26å›ž ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«ã«åˆ†æžã™ã‚‹ãƒã‚°è§£æžãƒ„ãƒ¼ãƒ«pgFouine
PostgreSQLã§ã¯ï¼Œpostgresql.confã‚’è¨å®šã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šï¼ŒSQLæ–‡ã‚„ãã®å®Ÿè¡Œæ™‚é–“ãªã©ã®æƒ…å ±ã‚’ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«è¨˜éŒ²ã§ãã‚‹ã€‚ã“ã“ã§ã¯ã“ã®ãƒã‚°ã®ã“ã¨ã‚’ã€ŒSQLãƒã‚°ã€ã¨å‘¼ã¶ã“ã¨ã«ã—ã‚ˆã†ã€‚å˜ã«ã€Œãƒã‚°ã€ã¨ã„ã†ã¨ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°(WALãƒã‚°)ã¨æ··åŒã™ã‚‹æã‚ŒãŒã‚ã‚‹ã‹ã‚‰ã§ã‚ã‚‹ã€‚ SQLãƒã‚°ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªè¨˜éŒ²ãŒæ®‹ã‚‹ã€‚ LOG: statement: INSERT INTO history (tidï¼Œbidï¼Œaidï¼Œdeltaï¼Œmtime) VALUES (4ï¼Œ1ï¼Œ25891ï¼Œ8417ï¼ŒCURRENT_TIMESTAMP); LOG: duration: 72.786 ms
toton 2008/09/11
pgFouineã‚’ä½¿ãˆã°SQLãƒã‚°ã‚’ç´ æ—©ãè§£æžã—ï¼Œãƒ¬ãƒãƒ¼ãƒˆã‚’ä½œæˆã§ãã‚‹ã€‚

db

sql

postgresql
ãƒªãƒ³ã‚¯
Technical documentation
This browser is no longer supported. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
toton 2008/09/11
æ¤œç´¢

sql
ãƒªãƒ³ã‚¯
iar - ActiveRecordã‚’ä½¿ã£ãŸå¯¾è©±åž‹ã®SQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ - 2nd life (ç§»è»¢ã—ã¾ã—ãŸ)
æ˜¨æ—¥ã®mysqlarã«ã€ã€Žæ‹ã¨ãƒãƒƒã‚¯ã¯ã‚¢ã‚¸ãƒ£ã‚¤ãƒ«ãŒå‘½ï¼ã€ã§æœ‰åãªã‹ãšã²ã“ã•ã‚“ãŒpatchã‚’æ›¸ã„ã¦ä¸‹ã•ã‚Šã€ã‹ã¤iar (Interactive ActiveRecord) ã¨ã„ã†ã‚ãƒ£ãƒƒãƒãƒ¼ãªåå‰ã‚’ã¤ã‘ã¦ãã‚Œã¾ã—ãŸã€‚åå‰é‡è¦ï¼ MySQLã˜ã‚ƒãªã„ã¨å‹•ã‹ãªã„ã‹ãªãƒ¼ã€ã¨æ€ã£ã¦ãŸã‚“ã§ã™ãŒã€adapterå·®ã—æ›¿ãˆãŸã ã‘ã§ä»–ã§ã‚‚æ™®é€šã«å‹•ãã‚ˆï¼ã¨ã„ã†ã‚ã‘ã§sqliteã‚„postgresqlãªã‚“ã‹ã§ã‚‚å‹•ãã¾ã™ã€‚ä»–ã«ã‚‚firebird sqlserverã§ã‚‚å‹•ãã‹ã‚‚ã€‚ èµ·å‹•ã¯ iar -a sqlite -t db/development.db ãªã‚“ã‹ã§ã€‚ç‰¹ã«sqliteã®å¯¾è©±ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã¯è²§å¼±ãªã®ã§ã‹ãªã‚Šå¬‰ã—ã„ã‹ã‚‚ã€‚ã‚½ãƒ¼ã‚¹ã¯ http://rails2u.com/misc/iar.txt ã«ç½®ã„ã¦ãŠãã¾ã—ãŸã€‚ ã§ã€ã¡ã‚‡ã£ã¨ã—ãŸ irb tipsã€‚é€šå¸¸ irb ã§ã¯æˆ»ã‚Šå€¤ã®inspectã—ãŸå€¤ã‚’è¡¨ç¤ºã—ã¦ã
toton 2008/09/06
sql
ãƒªãƒ³ã‚¯
SQL Code Formatter
Click HERE to view desktop version/add-in version for ssms/vs of SQL Pretty Printer. Click HERE to try FREE ONLINE SQL beautifier, also known as Instant SQL Formatter. Instant SQL Formatter is a free online sql tidy tool, actually, it not only can beautify your sql but also can turn your formatted sql into html code, so you can post coloured sql code in your blog, forum,wiki and any website easily
toton 2008/09/02
SQLã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã€æ•´å½¢/ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ

db

sql
ãƒªãƒ³ã‚¯
ã‚ªãƒ¬ã‚ªãƒ¬SQLã®ä½œã‚Šæ–¹ã€œMySQLç·¨ã€œ - ã‚ˆãã®ã¯ã¦ãª
ã‚ªãƒ¬ã‚ªãƒ¬è¨€èªžå…¨ç››æœŸã®ç‚Žæš‘ã®å€™ã€ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ã€‚ ã‚ªãƒ¬ã‚ªãƒ¬SQLã®ä½œã‚Šæ–¹ã€œPostgreSQLç·¨ã€œã«ç¶šãã€ã‚ªãƒ¬ã‚ªãƒ¬SQLã®ä½œã‚Šæ–¹ã€œMySQLç·¨ã€œã¨ã„ã†äº‹ã§ MySQLã«ã€è‡ªä½œã®SQLé–¢æ•°(UDF)ã‚’çµ„ã¿è¾¼ã‚€ã‚„ã‚Šæ–¹ã‚’ç°¡å˜ã«ç´¹ä»‹ã—ã¾ã™ã€‚ MySQLã¯åã®é€šã‚Šã€ç§ã®SQLãªã®ã§ã‚ªãƒ¬ã‚ªãƒ¬SQLã«ã¯æŒã£ã¦ã“ã„ã§ã™ãã€‚ ç°¡å˜ã«è¨€ãˆã° select oreore(); select oreore(column1, column2) from table1; è‡ªåˆ†ã§å®šç¾©ã—ãŸCè¨€èªžã®oreoreé–¢æ•°ã‚’DBã«çµ„ã¿è¾¼ã‚“ã§ä½¿ãŠã†ã¨ã„ã†äº‹ã§ã™ã€‚ æœ€çµ‚ç›®æ¨™ã¯ã€SQLã®çµæžœã§JSONã‚’è¿”ãã†ã¨æ€ã„ã¾ã™ã€‚ select json(a, b) from c;ã®çµæžœã§ { "aaa" : 1, "bbb" : "abc" } å›ºå®šå€¤ã‚’è¿”ã™é–¢æ•° æ—©é€Ÿã€å›ºå®šã§999ã‚’è¿”ã™é–¢æ•°ã‚’ä½œã£ã¦ã¿ã¾ã™ã€‚ â€»ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯MySQL5.
toton 2008/08/08
UDF

sql
ãƒªãƒ³ã‚¯
P6Spy Open Source Software
Download version 1.3. Released November 30, 2003. Alan Arvesen fixed the "String Index Out Of Bounds" error (bug 238, 239, 246, etc.) Alan Arvesen added a major new feature: a solution to DataSources. The biggest probl em with DataSources is that, unlike plain Drivers, they are not managed by the DriverManager but rather something else. "Something Else" usually means "your app server." The app ser
toton 2008/04/06
jdbc logger

java

sql
ãƒªãƒ³ã‚¯
Tagã®æ¤œç´¢ã«MySQLã®å…¨æ–‡æ¤œç´¢ã‚’ä½¿ã† : blog.nomadscafe.jp
Tagã®æ¤œç´¢ã«MySQLã®å…¨æ–‡æ¤œç´¢ã‚’ä½¿ã† Tags with MySQL fulltextã‚’å‚è€ƒã«ã—ã¦è©¦ã—ã¦ã¿ãŸã€‚ Femoã®ä¸ã§ã€ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ãŸã®ã«ç¶šã„ã¦ã€ã€Œå®Œäº†ã€ã‚„ã€Œfinishã€ã¨è¨€ã£ãŸã‚¿ã‚°ãŒã¤ã„ã¦ã„ã‚‹å ´åˆè¡¨ç¤ºã—ãªã„ã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’è€ƒãˆã¦ã„ã‚‹ã€‚ ãã†ãªã£ã¦ãã‚‹ã¨ã€SQLã‚’ã©ã†æ›¸ã‘ã°ã„ã„ã®ã‹ã€ã¾ãŸè¤‡é›‘ãªSQLã‚’æ§‹ç¯‰ã—ãŸã¨ãã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯å¤§ä¸ˆå¤«ãªã®ã‹ã¨å¿ƒé…ã€‚ãã“ã§ã€ä¸Šè¨˜ã®URLã‚’å‚è€ƒã«ã—ãªãŒã‚‰MySQLã®å…¨æ–‡æ¤œç´¢ã«æ³¨ç›®ã€‚ create table ft_tags( id int unsigned not null auto_increment primary key, tags text, unpack text, fulltext (unpack) ) ã¨è¨€ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã€‚ ã“ã“ã«ã€ my @tags = ( q/task femo/, q/femo mail t
toton 2008/03/02
åŠè§’ã‚¹ãƒšãƒ¼ã‚¹åŒºåˆ‡ã‚Šã®ã‚¿ã‚°å…¥åŠ› 16 é€²ã§ Full Text Search

sql

search

tag

folksonomy
ãƒªãƒ³ã‚¯
[ThinkIT] PostgreSQLã¨Oracleã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç›¸äº’ç§»è¡Œãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ç¬¬5å›žï¼šSQLæ–‡ã®ç§»è¡Œï¼ˆ2ï¼‰ (1/2)
Oracleã®éšŽå±¤å•ã„åˆã‚ã›ã‚’PostgreSQLã§å®Ÿç¾ã™ã‚‹ã«ã¯ã€connectbyï¼ˆï¼‰ã‚’ä½¿ã„ã¾ã™ã€‚ å›³8ã®ã‚ˆã†ãªè¡¨ãŒã‚ã£ãŸã¨ã—ã¾ã—ã‚‡ã†ã€‚æ‹…å½“è€…ãƒžã‚¹ã‚¿ã®MGR_IDåˆ—ã¯ã€å„è¡Œã®æ‹…å½“è€…ã«ã¨ã£ã¦ã€ä¸Šå¸ã¨ãªã‚‹æ‹…å½“è€…ã®IDã‚’è¡¨ã—ã¦ã„ã¾ã™ã€‚
toton 2008/03/02
PostgreSQLã§ã®å†å¸°sql (sql99 WITH RECURSIVE)(oracle connect by)

sql
ãƒªãƒ³ã‚¯
UNIX ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€ ç¨šå†…åŒ—æ˜Ÿå¦åœ’çŸæœŸå¤§å¦ ä¸¸å±±ä¸äºŒå¤«
ç¨šå†…åŒ—æ˜Ÿå¦åœ’çŸæœŸå¤§å¦ çµŒå–¶æƒ…å ±å¦ç§‘ ä¸¸å±±ä¸äºŒå¤« 1994å¹´ 8æœˆ 5æ—¥ Contents åºç« ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¦‚è¦³ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯æƒ…å ±ã‚’ã©ã®ã‚ˆã†ã«çµ„ç¹”ã—ã¦ã„ã‚‹ã‹ æƒ…å ±ã®ã„ã‚Œã‚‚ã®ã¨ã—ã¦ã®ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã€ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ã¨ã¯ ã™ã¹ã¦ã®é–¢ä¿‚ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã‚ã‚‹ é–¢ä¿‚æ¼”ç®— ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã®æ¨™æº–è¨€èªžï¼³ï¼±ï¼¬ æœ¬æ›¸ã§ã®SQLã®æ‰±ã„æ–¹ã®ç‰¹å¾´ Select selectã®åŸºæœ¬å½¢ ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰æŒ‡å®šã—ãŸé …ç›®ã‚’æŠœãå‡ºã™ select è¦‹å‡ºã—ã®å¤‰æ›´ã®ï¼’ã¤ã®æ–¹æ³• è¡Œå†…ã¸ã®æ–‡å—åˆ—ã®è¡¨ç¤º é …ç›®ãƒªã‚¹ãƒˆä¸ã®å¼ from å¥ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ç© whereå¥ æ¤œç´¢æ¡ä»¶ã®æŒ‡å®š è«–ç†æ¼”ç®— ãƒªã‚¹ãƒˆ nullå€¤ æ–‡å—åˆ—ã®æ¯”è¼ƒã€€likeã¨ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰ ã‚¸ãƒ§ã‚¤ãƒ³ ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµåˆ é …ç›®åã®ä¿®é£¾ ä¸‰ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚¸ãƒ§ã‚¤ãƒ³ ãƒ†ãƒ¼ãƒ–ãƒ«åã®ã‚¨ã‚¤ãƒªã‚¢ã‚¹ï¼ˆåˆ¥åï¼‰ è‡ªå·±è‡ªèº«ã¨ã®ã‚¸ãƒ§ã‚¤ãƒ³ ã‚µãƒ–ãƒ»ã‚¯ã‚§ãƒªãƒ¼
toton 2007/09/21
ç¨šå†…åŒ—æ˜Ÿå¦åœ’çŸæœŸå¤§å¦ ä¸¸å±±ä¸äºŒå¤«1994å¹´

db

sql

programming

*****
ãƒªãƒ³ã‚¯
é€†å¼•ãSQLæ¯”è¼ƒ
Works > é€†å¼•ãSQLæ¯”è¼ƒ é€†å¼•ãSQLæ¯”è¼ƒ [Â å…±é€šäº‹é …Â ]Â [Â ORACLEÂ ]Â [Â MSSQLÂ ]Â [Â SSAÂ ]Â [Â PostgresÂ ]Â [Â MySQLÂ ]Â [Â JetÂ ]Â Last Updated. 14-May-2006 Since 08-May-2001 â– ã¯ã˜ã‚ã« è¤‡æ•°ã® RDBMS ã‚’ä½¿ã£ãŸçµŒé¨“ãŒã‚ã‚‹äººãªã‚‰ã€ãŠã‚ã‹ã‚Šã‹ã¨æ€ã„ã¾ã™ãŒã€SQL ã¯ RDBMS ã«ã‚ˆã£ã¦ç•°ãªã‚‹éƒ¨åˆ†ãŒçµæ§‹ã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã¯å„ RDBMS ã«ãŠã‘ã‚‹ åŸºæœ¬çš„ãªæ©Ÿèƒ½ï¼ˆä¸»ã«SQLã«ã¤ã„ã¦ï¼‰ã®æ¦‚è¦ã‚’ã€é€†å¼•ãã§ã€ã‹ã¤å¹³æ˜“ãªè¨€è‘‰ã§é–²è¦§ ã™ã‚‹äº‹ã‚’ç›®çš„ã«ä½œã£ãŸãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã™ã€‚ ç‰¹å®šã® RDBMS ã‚’æŒã¡ä¸Šã’ãŸã‚Šã€è²¶ã‚ãŸã‚Šã™ã‚‹ã®ãŒç›®çš„ã§ã¯ãªã„ã®ã§èª¤è§£ãªãã‚ˆã†ã€‚ ã¾ãŸã€é–“é•ã„ã«ã¤ã„ã¦ã®ã”æŒ‡æ‘˜ã‚„ã€Žã“ã†ã—ãŸæ–¹ãŒåŠ¹çŽ‡çš„ã ã€ãªã©ã®ã”æ„è¦‹ã‚‚å¤§æ“è¿Žã§ã™ã€‚ å¯¾è±¡ã¨ã—ã¦ã„ã‚‹ã®ã¯ä»¥ä¸‹ã® RDBMSã§
toton 2007/09/21
db

sql
ãƒªãƒ³ã‚¯
æ¡ä»¶æŒ‡å®šã¨é‡è¤‡ãƒã‚§ãƒƒã‚¯å¾Œã®ã‚«ã‚¦ãƒ³ãƒˆ
#2å›žç”è€…ã§ã™ã€‚ >ã“ã®SQLã‚’ã¡ã‚‡ã“ã£ã¨å¤‰æ›´ã™ã‚Œã° >ã™ãå‡ºæ¥ã‚‹ã®ã‹ãªãã¨æ€ã£ã¦ãŸã®ã§ã™ãŒ ã‚„ã‚ŠãŸã„ã¨è¨€ã£ã¦ã„ã‚‹ã“ã¨ã¨ã‚„ã£ã¦ã„ã‚‹ã“ã¨ãŒã€é•ã£ã¦ã„ã¾ã™ã‚ˆï¼Ÿ ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã«ã‚ˆã£ã¦ã€ä¸€è¦‹ã€è¿‘ã„çµæžœãŒå¾—ã‚‰ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«è¦‹ãˆã¦ã„ã‚‹ã ã‘ã§ã€ã‚„ã£ã¦ã„ã‚‹ã“ã¨ã¯ãƒ‡ã‚¿ãƒ©ãƒ¡ãªã‚“ã§ã™ã‘ã©ï¼Ÿ #2ã§ç¤ºã—ãŸSQLã¯ã€åˆ†è§£ã™ã‚Œã°MySQL 4.1ã§ã‚‚ã™ãã«å¿œç”¨ãŒåˆ©ãã—ã€å¤šãã®ãƒ’ãƒ³ãƒˆãŒå«ã¾ã‚Œã¦ã„ãŸã¯ãšãªã®ã«ã€è¦‹å‘ãã‚‚ã•ã‚Œãªã‹ã£ãŸã‚ˆã†ã§ã¾ã£ãŸãä¸æœ¬æ„ã§ã™ã€‚ MySQL 4.1ã§ä½¿ãˆãªã„ã®ã¯ã€ã‚¤ãƒ³ãƒ©ã‚¤ãƒ³ãƒ“ãƒ¥ãƒ¼ã ã‘ãªã®ã§ã€ã“ã‚Œã‚’ä¸€æ™‚è¡¨ã«ã™ã‚Œã°ä½¿ãˆã¾ã™ã€‚ ã€è¡¨å®šç¾©ï¼†ãƒ‡ãƒ¼ã‚¿ã€‘ create table t1 (id int, code char(1), process char(4)); insert into t1 values (100,'A','a001'), (100,'A','a001'), (100,'A','a00
toton 2007/09/21
sql
ãƒªãƒ³ã‚¯
ãƒ†ãƒ¼ãƒ–ãƒ«ã®çµåˆã«ã¤ã„ã¦ - Bug Catharsis
ã¤çµåˆã®åŸºç¤Ž(MSDN) çµåˆã¯ã€FROM å¥ã§ã‚‚ WHERE å¥ã§ã‚‚æŒ‡å®šã§ãã¾ã™ã€‚FROM å¥ã§çµåˆæ¡ä»¶ã‚’æŒ‡å®šã™ã‚‹ã¨ã€WHERE å¥ã§ä»–ã®æ¤œç´¢æ¡ä»¶ãŒæŒ‡å®šã•ã‚ŒãŸå ´åˆã«åŒºåˆ¥ã—ã‚„ã™ããªã‚Šã¾ã™ã€‚çµåˆã‚’æŒ‡å®šã™ã‚‹å ´åˆã€FROM å¥ã§æŒ‡å®šã™ã‚‹ã“ã¨ã‚’ãŠå‹§ã‚ã—ã¾ã™ã€‚ ã ã‚ˆããˆã€‚JOINå¥ã‚’ä½¿ã£ã¦ã®çµåˆã€‚ãã‚ŒãŒãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã§ã—ã‚‡ã†ã€‚ WHEREå¥ã«çµåˆæ¡ä»¶ãŒã‚ã‚‹ã¨ã€å¯èªæ€§ãŒæ‚ªãã¦ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ€§æ‚ªã™ãŽã ã¨æ€ã†(ãŠã¾ã‘ã«ç›®ã‚‚ç–²ã‚Œã‚‹ã—)ã€‚ ã“ã‚Œã¯SQL Serverã«é™ã£ãŸè©±ã§ã¯ãªãã€Oracleã®å ´åˆã§ã‚‚ã€ä»–ã®RDBã§ã‚‚åŒã˜ã“ã¨ã€‚ ãã‚“ãªã‚ã‘ã§ã€FROMå¥ã§JOINã«ã‚ˆã‚‹çµåˆã‚’ã—ã¦ã„ãŸã ããŸã„ãƒ»ãƒ»ãƒ»ã€‚ WHEREå¥ã§æŒ‡å®šã™ã‚‹çµåˆæ¡ä»¶ã‚„ã€çµåˆã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚‚ã‚ˆã‚‹ã‚“ã ã‘ã©ã€ æ¦‚ãã€WHEREå¥ã§çµåˆæ¡ä»¶ã‚’æŒ‡å®šã™ã‚‹ã¨ãƒã‚¹ãƒˆãƒ«ãƒ¼ãƒ—çµåˆ*1ã—æ˜“ãã€ FROMå¥ã§çµåˆæ¡ä»¶ã‚’æŒ‡å®šã™ã‚‹ã¨ãƒãƒƒã‚·ãƒ¥çµåˆ*2ã—æ˜“ã„ã®ã§ã¯ãª
toton 2007/09/12
JOIN ON(xxx and yyy) ã¨ã‹ã§æ›¸ã‘ï¼ã¨ã„ã†ã€‚å‹‰å¼·ã«ãªã‚Šã¾ã—ãŸ

sql
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
toton 2007/09/01
ï¼ˆNested Sets Modelï¼‰ "ã€€å…¨è¡Œã‚’æ›´æ–°å¯¾è±¡ã¨ã™ã‚‹ã®ã§ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå¤šå°‘æ°—ãŒã‹ã‚Šãªã¨ã“ã‚ã§ã™ãŒ" ã£ã¦ã®ã¯ã‚¹ã‚±ãƒ¼ãƒ«ã™ã‚‹ã®ã ã‚ã†ã‹

sql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
toton 2007/06/07
éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’SQLã§æ‰±ã† æœ¨æ§‹é€ å†å¸°sql

sql
ãƒªãƒ³ã‚¯
æ–°ã—ã„æ¥ç•Œæ¨™æº–ã€ŒSQL99ã€è©³ç´°è§£èª¬
ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã€Javaã‚’å–ã‚Šå…¥ã‚ŒãŸ æ–°ã—ã„æ¥ç•Œæ¨™æº–ã€ŒSQL99ã€è©³ç´°è§£èª¬ ç¬¬ä¸€ç« ã€€é«˜åº¦ãªãƒ‡ãƒ¼ã‚¿æ“ä½œï¼ˆ2ï¼‰ é«˜åº¦ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«æ“ä½œ SQLã§ã¯ã€ä»¥å‰ã‚ˆã‚Šã‚‚è¤‡é›‘ã§é«˜åº¦ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«æ“ä½œãŒå¯èƒ½ã«ãªã£ã¦ã„ã‚‹ã€‚ã“ã‚Œã«ã‚ˆã‚Šã€1ã¤ã®SQLæ–‡ã§é«˜åº¦ãªå‡¦ç†ãŒè¡¨ç¾ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ãã†ã—ãŸæ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã™ã‚‹ã€‚ â– å…±é€šè¡¨å¼ WITHå¥ SELECTæ–‡ã®çµæžœã‚‚ã€Œè¡¨ã€ãªã®ã§ã€è¡¨åã‚’æ›¸ãã¨ã“ã‚ã«ã¯SELECTæ–‡ã‚’ãã®ã¾ã¾æ›¸ãã“ã¨ãŒã§ãã‚‹ã€‚ã“ã‚Œã¯ã™ã§ã«SQL92ãŒå°Žå…¥ã—ã¦ã„ã‚‹ã€Œè¡¨å¼ã€ã¨ã„ã†æ¦‚å¿µã§ã€SELECTæ–‡ã®FROMå¥ã®ä¸ã«ã‚‚SELECTæ–‡ã‚’æ›¸ãã“ã¨ãŒã§ãã‚‹ã€‚æ¬¡ã®ä¾‹ã¯è²©å£²å®Ÿç¸¾è¡¨ã‹ã‚‰åœ°åŸŸã”ã¨ã«æœˆãƒ»è£½å“åˆ¥å£²ä¸Šé¡ã®ãã®åœ°åŸŸã®å£²ä¸Šã«å ã‚ã‚‹æ¯”çŽ‡ï¼ˆç™¾åˆ†çŽ‡ï¼‰ã‚’æ±‚ã‚ã¦ã„ã‚‹ã€‚æ¯”çŽ‡ã‚’è¨ˆç®—ã™ã‚‹ãŸã‚ã®åˆ†æ¯ï¼ˆãã®åœ°åŸŸã®å£²ä¸Šé¡åˆè¨ˆï¼‰ã‚’FROMå¥ä¸ã®SELECTæ–‡ã§è¨ˆç®—ã—ã¦ã„ã‚‹ã“ã¨ã«æ³¨ç›®ã—ã¦ã„ãŸã ããŸã„ã€‚ SELECT S.åœ°åŸŸå
toton 2007/06/06
å†å¸°SQL

sql
ãƒªãƒ³ã‚¯
å†å¸°SQL part2 - ãƒ—ãƒã‚°ãƒ©ãƒžã®æ€ç´¢
yuuntim ã•ã‚“ã€åŠå¹´å‰ã«æ›¸ã„ãŸè¨˜äº‹ã€Œå†å¸°SQLã€ã®ã‚³ãƒ¡ãƒ³ãƒˆã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ æœ€è¿‘ã¯OOAã‹ã‚‰ã©ã‚“ã©ã‚“é›¢ã‚Œã¦æ¥å‹™å±‹ã•ã‚“ã«ãªã£ãŸçµŒé¨“ã‚‚è¸ã¾ãˆã¦ã€ã‚‚ã†ä¸€åº¦è€ƒãˆã‚’æ•´ç†ã—ã¦ã¿ã¾ã™ã€‚ ã€ï¼‘ã€‘å†å¸°ï¼³ï¼±ï¼¬ã¯ãƒ„ãƒªãƒ¼æ§‹é€ ã®æƒ…å ±ã‚’æ¤œç´¢ã™ã‚‹æ™‚ã«ä½¿ãˆã‚‹ ã‚ã®æ™‚ã¯å†å¸°ï¼³ï¼±ï¼¬ã®æ„å‘³ã‚„ä½¿ã„é“ãŒå…¨ãåˆ†ã‹ã£ã¦ã„ãªã‹ã£ãŸã€‚ã—ã‹ã—ã€ä»Šã®ä»•äº‹ã®ãŠã‹ã’ã§ã€å†å¸°ï¼³ï¼±ï¼¬ã¯é‡è¦ã§ã‚ã‚Šã€è‰²ã‚“ãªæ‰€ã§ä½¿ãˆã‚‹ã“ã¨ã‚’çµŒé¨“ã—ãŸã€‚ å†å¸°ï¼³ï¼±ï¼¬ãŒä½¿ã‚ã‚Œã‚‹å…·ä½“ä¾‹ã¯äºŒã¤ã™ãã«æ€ã„ã¤ãã€‚ ä¸€ã¤ã¯ã€å€‹äººã®çµ„ç¹”æƒ…å ±ãŒéšŽå±¤æ§‹é€ ã«ãªã£ã¦ã„ã‚‹å ´åˆã€ã‚‚ã†ä¸€ã¤ã¯ã€å•†å“ãŒã‚«ãƒ†ã‚´ãƒ©ã‚¤ã‚ºã•ã‚Œã¦ã„ã¦ã‚«ãƒ†ã‚´ãƒªæƒ…å ±ãŒéšŽå±¤æ§‹é€ ã«ãªã£ã¦ã„ã‚‹å ´åˆã ã€‚ çµ„ç¹”æ§‹é€ ã®ä¾‹ã¯ã€ã‚¢ãƒŠãƒ‘ã‚¿ã®ãƒ‘ãƒ¼ãƒ†ã‚£ãã®ã‚‚ã®ã§ã€å†å¸°æ§‹é€ ã«ãªã£ã¦ã„ã‚‹ã€‚ ã©ã¡ã‚‰ã«ã›ã‚ˆã€çµ„ç¹”ãƒžã‚¹ã‚¿ã¨ã‹ã‚«ãƒ†ã‚´ãƒªãƒžã‚¹ã‚¿ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«éšŽå±¤æ§‹é€ ã®æƒ…å ±ãŒãƒ„ãƒªãƒ¼æ§‹é€ ã§ä¿æŒã•ã‚Œã¦ã„ã‚‹æ™‚ã«æœ‰åŠ¹ã«ãªã‚‹ã€‚ ä½†ã—ã€å½“ç„¶ã®ã“ã¨ãªãŒã‚‰éšŽå±¤ãŒæ·±ã„ã»ã©ã€å†å¸°ï¼³ï¼±ï¼¬
toton 2007/06/06
oracleã ã¨connect byå¥ã€‚éšŽå±¤æ§‹é€ ã«æœ‰åŠ¹ã€‚

sql
ãƒªãƒ³ã‚¯
1