[B! SQL] shokaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shokai id:shokai

SQLã«é–¢ã™ã‚‹shokaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (17)

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

DBæ“ä½œãƒ„ãƒ¼ãƒ« Emacs DBI ã‚’ä½œã£ã¦ã¿ãŸ - æŠ€è¡“æ—¥è¨˜ï¼ kiwanami
åŽ»å¹´ã‹ã‚‰ã»ãã¼ãã¨ä½œã£ã¦ããŸã€Emacsã‹ã‚‰DBã‚’æ“ä½œã§ãã‚‹ãƒ„ãƒ¼ãƒ« Emacs DBI ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Emacs DBI ã®ç°¡å˜ãªç´¹ä»‹ ã“ã®ãƒ„ãƒ¼ãƒ«ã®ç›®çš„ã¯ã€ã‚¯ãƒã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ä¾¿åˆ©ãªDBæ“ä½œç’°å¢ƒã‚’å®Ÿç¾ã™ã‚‹ã“ã¨ã§ã™ã€‚ pgAdmin ã‚„ MySQL Query Browser ã®ã‚ˆã†ãªGUIã®è‰¯ã•ã‚’CUIã§å®Ÿç¾ã—ã¦ã¿ã‚ˆã†ã¨ã—ã¦ã¿ã¾ã—ãŸã€‚ã™ãªã‚ã¡ã€ã¼ãã®ã‹ã‚“ãŒãˆãŸã•ã„ãã‚‡ã†ã®DBãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ã¡ãªã¿ã«ã€ã“ã®ãƒ„ãƒ¼ãƒ«ã«ã¨ã£ã¦Emacsã¯ãŸã ã®å®Ÿè¡Œç’°å¢ƒã§ã™ã€‚Emacsä½¿ã‚ãªã„äººã§ã‚‚ä½¿ã†ã¨ä¾¿åˆ©ã ã¨æ€ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç”»é¢ e2wmã§3ãƒšã‚¤ãƒ³ã®ç”»é¢ æ©Ÿèƒ½æ¦‚è¦ ä»¥ä¸‹ã®ã‚ˆã†ãªæ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ Emacsã¨DBæŽ¥ç¶šå¯èƒ½ãªPerlãŒå‹•ã‘ã°ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§ã‚‚ä½•å‡¦ã§ã‚‚å‹•ã DBå®šç¾©ã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ãŒã™ãè¦‹ã‚Œã‚‹ auto-complete ã«ã‚ˆã‚‹SQLè£œå®Œ æŽ¥ç¶šå…ˆDBã«ã‹ã‚‰ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã€åž‹åã€ãƒ†ãƒ¼ãƒ–ãƒ«åã€ã‚«ãƒ©ãƒ åãªã©
shokai 2012/03/06
SQL

emacs

DB
ãƒªãƒ³ã‚¯
SQL to MongoDB Mapping Chart - MongoDB Manual v8.0
In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about Mongo DB. Terminology and Concepts The following table presents the various SQL terminology and concepts and the corresponding Mongo DB terminology and concepts.
shokai 2011/12/09
mongodbã¨sqlã®å¯¾å¿œè¡¨

MongoDB

SQL
ãƒªãƒ³ã‚¯
SOCI
SOCI is a database access library for C++ that makes the illusion of embedding SQL queries in the regular C++ code, staying entirely within the Standard C++. The idea is to provide C++ programmers a way to access SQL databases in the most natural and intuitive way. If you find existing libraries too difficult for your needs or just distracting, SOCI can be a good alternative. The simplest motivati
shokai 2009/07/14
"SOCI - The C++ Database Access Library"

boost

SQL
ãƒªãƒ³ã‚¯
Nao Haida's weblog: ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ãƒ³ã‚°ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’å‹‰å¼·ã—ãŸã€‚ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ãŒå¿…è¦ãªç†ç”± MySQL ã§ã¯ DB ä¸Šã®ãƒ‡ãƒ¼ã‚¿é‡ãŒå¢—åŠ ã™ã‚‹ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒä½Žä¸‹ã™ã‚‹ã€‚ ä»¥ä¸‹ãŒåŽŸå› ã€‚ 1. MySQL ã§ã¯ 1åº¦ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯åŠ¹çŽ‡åŒ–ã®ãŸã‚ã«ãƒãƒƒãƒ•ã‚¡ã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã‚Œã‚‹ã€‚ 2. ãƒ‡ãƒ¼ã‚¿é‡ãŒå¢—å¤§ã™ã‚‹ã¨ã€ãƒ¡ãƒ¢ãƒªä¸Šã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µã‚¤ã‚ºã§ã¯ä¸è¶³ã€‚ 3. ãƒ‡ã‚£ã‚¹ã‚¯ I/O ãŒå¢—å¤§ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä½Žä¸‹ã¸ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ DB ã‚’åˆ†å‰²(ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°)ã—ã€ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãŒãƒ¡ãƒ¢ãƒªä¸Šã«åŽã¾ã‚‹çŠ¶æ…‹ã‚’ã‚ãƒ¼ãƒ—ã™ã‚‹ã“ã¨ã§å¯¾ç–ã™ã‚‹ã€‚ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¯ 2 ã‚¢ãƒ—ãƒãƒ¼ãƒãŒè€ƒãˆã‚‰ã‚Œã‚‹ã€‚ 1. ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§å®Ÿè£… 2. MySQL ã®ã‚µãƒãƒ¼ãƒˆæ©Ÿèƒ½ã‚’ç”¨ã„ã¦å®Ÿè£… ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°å®Ÿè£… ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯å‚ç…§ç³»ã®è² è·åˆ†æ•£ã«ã¯ãªã‚‹ãŒæ›´æ–°ç³»ã®è² è·åˆ†æ•£ã®è§£æ±ºã«
shokai 2008/04/10
RDB

DB

SQL
ãƒªãƒ³ã‚¯
Safari 3.1 ã«å®Ÿè£…ã•ã‚ŒãŸã€ŒClient-side database storage (SQL API)ã€ã¨ã¯ä½•ã‹ï¼Ÿ - ITæˆ¦è¨˜
ã¯ã˜ã‚ã« Safari 3.1 ã«ã¯ Client-side database storage ï¼ˆSQL API ã¨ã‚‚å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚ï¼‰ã¨ã„ã†æ–°ã—ã„ä»•æ§˜ãŒå®Ÿè£…ã•ã‚Œã¾ã—ãŸã€‚ ã¨ã„ã†ã‚ã‘ã§ã€ã“ã®æ–°ã—ã„ API ã«ã¤ã„ã¦è‰²ã€…èª¿ã¹ãŸã“ã¨ã‚’ç°¡å˜ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ Client-side database storage ãŒä½¿ãˆã‚‹ãƒ–ãƒ©ã‚¦ã‚¶ 2008 å¹´ 03 æœˆ 27 æ—¥ç¾åœ¨ã§ã¯ã€ Safari ç³»ã®ãƒ–ãƒ©ã‚¦ã‚¶ã®ã¿ã§ã™ã€‚ Safari 3.1 WebKit Nightly Client-side database storage ã¨ã¯ Selectors API ã¨ã¯ HTML5 ã§å®šç¾©ã•ã‚ŒãŸä»•æ§˜ã§ã™ã€‚è©³ç´°ã«é–¢ã—ã¦ã¯ã“ã¡ã‚‰ã‚’ã©ã†ãžã€‚ ç°¡å˜ã«èª¬æ˜Žã™ã‚‹ã¨ JavaScript å†…ã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ãˆã‚‹ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ã‚‚ã£ã¨ç°¡å˜ã«ã‚¤ãƒ¡ãƒ¼ã‚¸ã™ã‚‹ãŸã‚ã«ã€å®Ÿéš›ã®ã‚³ãƒ¼ãƒ‰ã‚’ç¤ºã™ã¨ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ va
shokai 2008/03/28
safari

SQL
ãƒªãƒ³ã‚¯
ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ - DB Designer 4 æ—¥æœ¬èªžåŒ–ã‚µã‚¤ãƒˆ
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ãƒ•ãƒªãƒ¼ãªERå›³ä½œæˆãƒ„ãƒ¼ãƒ«ã€ŒDBDesigner4ã€ã®æ—¥æœ¬èªžåŒ–ã‚’è©¦ã¿ã‚‹ã‚µã‚¤ãƒˆãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ ã“ã®ã‚µã‚¤ãƒˆã«ã¤ã„ã¦ bookmark ã“ã®ã‚µã‚¤ãƒˆã¯fabForceã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹DBãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã€ŒDB Designer 4ã€ã®æ—¥æœ¬èªžåŒ–ã‚’è©¦ã¿ã‚‹ã‚µã‚¤ãƒˆã§ã™ã€‚ å€‹äººãŒé‹å–¶ã™ã‚‹ã‚µã‚¤ãƒˆãªã®ã§å…¬å¼ãªã‚µã‚¤ãƒˆã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã€ŒDB Designer 4ã€ã¯GPLãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ ã€ŒDB Designer 4ã€ã«ã¤ã„ã¦ã®è©³ç´°æƒ…å ±ã¯æœ¬å®¶ã‚µã‚¤ãƒˆã‚’ã”å‚ç…§ãã ã•ã„ã€‚ fabFORCE.net DBDesigner4ã®ç‰¹å¾´ bookmark ç›´æ„Ÿçš„ãªGUIã«ã‚ˆã‚‹ERãƒ¢ãƒ‡ãƒ«å›³ã®ãƒ¢ãƒ‡ãƒªãƒ³ã‚° ERãƒ¢ãƒ‡ãƒ«å›³ã‹ã‚‰SQLæ–‡ï¼ˆCREATEã‚„DELETEï¼‰ã®è‡ªå‹•ç”Ÿæˆ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã«ã‚ˆã‚‹ERãƒ¢ãƒ‡ãƒ«å›³ã®ç”Ÿæˆ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ERãƒ¢ãƒ‡ãƒ«å›³ã®åŒæœŸåŒ–æ©Ÿèƒ½ è»½å¿«
shokai 2008/02/27
DB

ERå›³

SQL
ãƒªãƒ³ã‚¯
fabFORCE.net - DBDesigner 4
General Information - What is DBDesigner 4? DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. It combines professional features and a clear and simple user interface to offer the most efficient way to handle your databases. DBDesigner 4 compares to products like Oracle's Designerï¿½, IBM's Rational
shokai 2008/02/27
DB

ERå›³

SQL
ãƒªãƒ³ã‚¯
Navicat.jpã€€â€•ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ãƒ»é‹ç”¨ã‚’ã‚ˆã‚Šç°¡å˜ã«ã‚¹ãƒ ãƒ¼ã‚ºã«â€•
Percona ServerÂ¥131,800ï½ž Navicat Premium Navicat Premiumã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ãƒ„ãƒ¼ãƒ«ã§ã‚ã‚Šã€ä¸€ã¤ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã€MySQLã€Redisã€MariaDBã€Mongo DBã€SQL Serverã€Oracleã€PostgreSQLãŠã‚ˆã³SQâ€¦ MariaDBÂ¥33,000ï½ž Navicat for MySQL Navicat for MySQLã¯ã€MySQL/MariaDBç®¡ç†ãŠã‚ˆã³é–‹ç™ºã«éš›ã—ã€ç†æƒ³çš„ãªã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã™ã€‚ä¸€ã¤ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã€åŒæ™‚ã«MySQLãŠã‚ˆã³MariaDBã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼â€¦ Mongo DB AtlasÂ¥33,000ï½ž Navicat for Mongo DB Navicat for Mongo DBã¯ã€Mongo DBãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã€ç®¡ç†ã€é–‹ç™ºã‚’è¡Œã†ä¸Šã§éžå¸¸ã«å®ŸåŠ¹æ€§ã®ã‚ã‚‹GUIã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã‚’æä¾›ã—ã¦ã„ã¾
shokai 2008/02/21
SQL
ãƒªãƒ³ã‚¯
é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ - é»’çŒ« SQL Studio (æ±Žç”¨SQLé–‹ç™ºç’°å¢ƒ/é–‹ç™ºãƒ„ãƒ¼ãƒ«/ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ)
é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯å¼•ã£è¶Šã—ã¾ã—ãŸã€‚ æ–°ã—ã„ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯ã“ã¡ã‚‰ â†’ http://kuronekosoft.ewinds.net/ 5ç§’å¾Œã«è‡ªå‹•çš„ã«ã‚¸ãƒ£ãƒ³ãƒ—ã—ã¾ã™ã€‚ â– é»’çŒ« SQL Studio é»’çŒ« SQL Studio ã¯ã€ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ãªæ±Žç”¨SQLé–‹ç™ºç’°å¢ƒã§ã™ã€‚é»’çŒ« SQL Studio ã«ã¯ã€SQLã‚’æ‰‹æ—©ãä½œã‚‹ãŸã‚ã®å…¥åŠ›æ”¯æ´æ©Ÿèƒ½ã‚„ã€ä½œã£ãŸSQLã‚’ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦ã¾ã¨ã‚ã¦ç®¡ç†ã™ã‚‹æ©Ÿèƒ½ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ â– é»’çŒ« SQL Studio ã®ç‰¹å¾´ 1. ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶š ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã«ADOã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ãŸã‚ã€OLE DB ãƒ—ãƒãƒã‚¤ãƒ€(ã‚ã‚‹ã„ã¯ODBCãƒ‰ãƒ©ã‚¤ãƒã§ã‚‚å¯èƒ½)ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã»ã¨ã‚“ã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§OLE DB ãƒ—ãƒãƒã‚¤ãƒ€(ã¾ãŸã¯ODBCãƒ‰ãƒ©ã‚¤ãƒ)ãŒåˆ©ç”¨å¯èƒ½ãªãŸã‚ã€å®Ÿè³ªã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
shokai 2007/07/19
ãªã‹ãªã‹è‰¯ã•ãã†ãªGUI

SQL

tool
ãƒªãƒ³ã‚¯
Facebook Developers
The web is social. Developers just like you have built applications on Facebook Platform that millions of people use everyday. Join our developer community and help make the web even more social. Develop Meaningful AppsConnect users and solve real-world probl ems with your applications. Build a business by offering users valuable experiences. Join an Active Community Building great applications is e
shokai 2007/03/17
SQLã£ã½ã„æ§‹æ–‡ã§ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹API

Facebook

API

SQL
ãƒªãƒ³ã‚¯
HugeDomains.com
Captcha security check traksy.com is for sale Please prove you're not a robot View Price Processing
shokai 2006/11/10
Maxã§iTuensã®ãƒ—ãƒ¬ã‚¤ãƒªã‚¹ãƒˆã„ã˜ã‚‹

Max-MSP

iTunes

XML

SQL
ãƒªãƒ³ã‚¯
Web2.0ãƒŠãƒ“: SQL-DESIGNERãŒã‚¹ã‚´ã‚¤
ã„ã„ãï¼ 0 ãƒ„ã‚¤ãƒ¼ãƒˆ B! ã¯ã¦ãƒ– 447 Pocket 2 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆæ™‚ã«ERå›³ã‚’ã‹ãã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ãŒã€SQL-designerã¨ã„ã†ã‚¦ã‚§ãƒ–ãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ãŒéžå¸¸ã«ä½¿ã„ã‚„ã™ã„ãã€ãƒ‡ã‚¶ã‚¤ãƒ³çš„ã«ã‚‚ç¶ºéº—ã§ä¾¿åˆ©ã€‚ MSprojectç‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã‚’è¡Œã†å°‚ç”¨ã‚½ãƒ•ãƒˆã¯éžå¸¸ã«å¤šãã‚ã‚‹ãŒã€ã©ã‚Œã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¿…è¦ã ã£ãŸã‚Šã€è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ãŒå¿…è¦ã ã£ãŸã‚Šã€ã‚½ãƒ•ãƒˆãŒé‡ã‹ã£ãŸã‚Šã€ç’°å¢ƒä¾å˜ãŒæ¿€ã—ã‹ã£ãŸã‚Šã—ã¦ã€ä½¿ã„ã«ãã„ã€‚ ä½¿ã„ã‹ãŸã¯ç°¡å˜ã§ã€ ï¼‘ï¼Žã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«ã„ã£ã¦ ï¼’ï¼Žãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’è¿½åŠ ã™ã‚‹ ï¼“ï¼Žãƒ—ãƒªãƒ³ãƒˆã‚¢ã‚¦ãƒˆorXMLã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ ã ã‘ã€‚ ãƒ‡ãƒ¼ã‚¿ã®åž‹ãªã©ã‚‚é¸æŠžã§ãã¦ã€è¨è¨ˆãŒçµ‚ã‚ã£ãŸã‚‰ã€SQLæ–‡ã‚’ãã®ã¾ã¾ç™ºè¡Œã—ãŸã‚Šã€ä½œã£ãŸEQå›³ã‚’XMLã§ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã‚„ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚Javascriptãƒ™ãƒ¼ã‚¹ãªã®ã§ã€ã‚ã‚“ã©ãã•ã„ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚„ç’°å¢ƒä¾å˜ã‚‚ãªã—ã€‚ ã‚¦ã‚§ãƒ–ä¸Šã§ã‚„ã‚‹ã®ã¯ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
shokai 2006/10/29
SQL

tool

WebService
ãƒªãƒ³ã‚¯
ãƒãƒƒã‚«ãƒ¼ã®é‡‘é‰±è„ˆã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã®æ£ä½“
æœ€è¿‘ï¼Œã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã®å±é™ºæ€§ã«ã¤ã„ã¦èªžã‚‰ã‚Œã‚‹æ©Ÿä¼šãŒå¢—ãˆã¦ã„ã‚‹ãŒï¼ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ£ä½“ï¼Œãã®å•é¡Œç‚¹ï¼Œãã—ã¦ãã‚Œã‚’é˜²ããŸã‚ã®æ–¹ç–ã«ã¤ã„ã¦è©³ã—ãç†è§£ã—ã¦ã„ã‚‹äººã¯ã¾ã å¤šããªã„ã€‚ã“ã“ã§ã¯ï¼ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ã‹ã‚’æ˜Žç¢ºã«å®šç¾©ã—ï¼Œã©ã®ã‚ˆã†ã«ã—ã¦è¡Œã‚ã‚Œã‚‹ã‹ã‚’èª¬æ˜Žã—ï¼ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰çµ„ç¹”ã‚’å®ˆã‚‹æ–¹æ³•ã‚’èªè€…ã«ä¼ãˆã‚‹ã“ã¨ã«ã‚ˆã£ã¦ï¼Œã“ã®çŠ¶æ³ã‚’æ”¹å–„ã—ãŸã„ã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ä½•ã‹ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ï¼Œã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã‚‹ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ»ã‚¨ãƒ©ãƒ¼ãŒåŽŸå› ã¨ãªã£ã¦å¼•ãèµ·ã“ã•ã‚Œã‚‹ãœã„å¼±æ€§ï¼Œã¾ãŸã¯æ¬ é™¥ã§ã‚ã‚‹ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¯ï¼Œãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒå…¥åŠ›ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã£ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒSQLã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ä½œæˆã—ï¼Œãã‚Œã‚’SQL Serverã«é€ä¿¡ã—ã¦å®Ÿè¡Œã™ã‚‹å ´åˆã«ç™ºç”Ÿã™ã‚‹ã€‚ã“ã®æ¬ é™¥ãŒåŠã¼ã™å½±éŸ¿ã¯ï¼Œã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ»ã‚¨ãƒ©ãƒ¼ã®æ€§è³ªã«ã‚ˆã£ã¦æ§˜ã€…ã§ã‚ã‚‹ã€‚ å…·ä½“çš„ã«è¨€ã†ã¨ï¼Œãã®å½±éŸ¿ã¯ï¼Œã‚¨
shokai 2006/10/05
SQL

SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: viã®ä¸ã§SQLã‚’å®Ÿè¡Œã™ã‚‹
ã“ã‚“ã«ã¡ã¯ï¼Œttsuruoka ã§ã™ï¼Ž vi ã®ä¸ã§ SQL ã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ãŒã§ãã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ï¼Œ dbext.vimã‚’ç´¹ä»‹ã—ã¾ã™ï¼Ž æ©Ÿèƒ½(ä¸€éƒ¨) - ex ã‚³ãƒžãƒ³ãƒ‰ã§ SQL æ–‡ã‚’å…¥åŠ›ã—ã¦ï¼Œãã®çµæžœã‚’å–å¾— :Select user_id from users order by rand() limit 7 Result ãƒãƒƒãƒ•ã‚¡ã«çµæžœãŒè¡¨ç¤ºã•ã‚Œã¾ã™ - é¸æŠžã—ãŸãƒ†ã‚ã‚¹ãƒˆéƒ¨åˆ†ã®SQLã‚’å®Ÿè¡Œ // ãƒ—ãƒã‚°ãƒ©ãƒ ä¸ã®SQL $query = "SELECT * FROM users LIMIT 10"; // å¤‰æ•°ãŒå«ã¾ã‚Œã¦ã„ã‚‹å ´åˆ $query = "SELECT * FROM users LIMIT $n"; // ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ãƒ¼ãŒå«ã¾ã‚Œã¦ã„ã‚‹å ´åˆ $query = "SELECT * FROM users LIMIT ?"; php ç‰ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ SQL ã‚’
shokai 2006/09/26
xyzzyã«ã‚‚æ¬²ã—ã„

vi

SQL
ãƒªãƒ³ã‚¯
SQL::Translator, The SQL Fairy
SQL::Translator is a group of Perl modules that manipulate structured data definitions (mostly database schemas) in interesting ways, such as converting among different dialects of CREATE syntax (e.g., MySQL-to-Oracle), visualizations of schemas (pseudo-ER diagrams: GraphViz or GD), automatic code generation (using Class::DBI), converting non-RDBMS files to SQL schemas (xSV text files, Excel sprea
shokai 2006/08/11
ãƒã‚´ãŒãã‚‚ã™ ã„ã‚„ã‹ã‚ã„ã„ã‹ã‚‚ã—ã‚Œãªã„

SQL

SQLFairy

Perl
ãƒªãƒ³ã‚¯
Amazon.co.jp: åˆã‚ã¦ã®SQL: Alan Beaulieu (è‘—), æ ªå¼ä¼šç¤¾ã‚¯ã‚¤ãƒ¼ãƒ— (ç¿»è¨³): æœ¬
shokai 2006/05/02
SQL

MySQL

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

RDB
ãƒªãƒ³ã‚¯
1