Applied Mathematics 7 (2015)
¼ø¶È»ñÎÁ/13
¤ò¥Æ¥ó¥×¥ì¡¼¥È¤Ë¤·¤ÆºîÀ®
³«»Ï¹Ô:
#CONTENTS
// Âè 13 ²ó -- ¥Ç¡¼¥¿¥Ù¡¼¥¹ÆþÌç (SQLite)
* ¥Ç¡¼¥¿¤Î¼è¤ê°·¤¤¤Ë¤Ä¤¤¤Æ [#s15f7577]
¤¢¤ëÄøÅÙÂ絬ÌϤÀ¤Ã¤¿¤êÊ£»¨¤À¤Ã¤¿¤ê¤¹¤ë¥Ç¡¼¥¿¤ò½èÍý¤¹¤ë¤³...
¤è¤¯¤¢¤ë¤³¤È¤Ç¤¢¤ë¤Î¤Ç¡¤¤³¤¦¤·¤¿¥Ç¡¼¥¿¤ò¡Ö¤É¤Î¤è¤¦¤ËÊݸ...
¤É¤Î¤è¤¦¤Ë¼è¤ê½Ð¤¹¤«¡×¤È¤¤¤¦»ëÅÀ¤Ç¤¤Á¤ó¤Èª¤¨¤Æ°ìÄê¤Îµ¬...
¤³¤¦¤·¤¿¹Í¤¨Êý¤¬°ìÂΤηÁ¤ò¤È¤Ã¤¿¤â¤Î¤¬°Ê²¼¤Ë½Ò¤Ù¤ë¥Ç¡¼¥¿...
* ¥Ç¡¼¥¿¥Ù¡¼¥¹(¥½¥Õ¥È¥¦¥§¥¢)¤È¤Ï [#p43c1b32]
Â绨ÇĤ˸À¤¨¤Ð¡¤¼ý½¸¤µ¤ì¤¿¥Ç¡¼¥¿¤Î½¸¹çÂΤ½¤Î¤â¤Î¤ò»Ø¤¹.
¤Þ¤¿¤Ï¡¤¥Ç¡¼¥¿¤òÊݸ¤¹¤ë¤³¤È¡¤¤Þ¤¿¡¤°ìÄê¤Î¥ë¡¼¥ë¤Ë¤½¤Ã¤Æ...
¥Ç¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢¤Î¶¯¤ß¤Ï¤Þ¤º¤Ï¤½¤ÎÈÆÍÑÀ¡¤¤Ä¤Þ¤ê...
¤Þ¤¿¡¤¥Ç¡¼¥¿¤ò¼è¤ê°·¤¦¤³¤È¤ËÆò½¤·¤Æ¤¤¤ë¤³¤È¤Ë¤è¤ê¡¤Áàºî...
¤¿¤À¡¤¤³¤¦¤·¤¿¹âµ¡Ç½À¤Ï¥½¥Õ¥È¥¦¥§¥¢¤ÎÈîÂç²½¡¤ÈÑ»¨¤µ¤È¶¯...
&br;&br;
&ref(/materials/warning.png);
¤è¤Ã¤Æ¡¤¡Ö¤½¤Î¥Ç¡¼¥¿¹½Â¤¤Ë¤Î¤ß¡×Æò½¤·¤¿¸¤¤¥×¥í¥°¥é¥à¤Î...
ÈÆÍѥǡ¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢¤è¤ê¤âÍ¥½¨¤Ç¤¢¤ë¤³¤È¤Ï½¼Ê¬¤Ë...
ÂоݤȤ¹¤ë¥Ç¡¼¥¿¤Î¼è°·¤Ë¤½¤â¤½¤â¥Ç¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢...
¤Þ¤º¤ÏºÇ½é¤Ë¸¡Æ¤¤·¤¿¤Û¤¦¤¬¤¤¤¤¤À¤í¤¦¡¥
** ¥Ç¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢¤Î¼ïÎà [#a5fd080b]
Èó¾ï¤ËÂ绨ÇĤËʬ¤±¤ë¤Î¤Ê¤é¤Ð¡¤´Ê°×¤Ê¤â¤Î¤«¤éÈó¾ï¤ËÂ絬ÌÏ...
- ɽ·×»»¥½¥Õ¥È¡¤Ã±¤Ê¤ë¥Æ¥¥¹¥È¥Õ¥¡¥¤¥ë+Unix¥³¥Þ¥ó¥É·² Åù...
- RDBMS(¥ê¥ì¡¼¥·¥ç¥Ê¥ë¥Ç¡¼¥¿¥Ù¡¼¥¹´ÉÍý¥·¥¹¥Æ¥à): ¥Ç¡¼¥¿¥Ù...
¥½¥Õ¥È¥¦¥§¥¢¤È¤·¤Æ¤Ï´Ê°×¤Ê¤â¤Î¤Ï¥é¥¤¥Ö¥é¥ê¡¤¥³¥Þ¥ó¥É¤È¤·...
- ¹½Â¤·¿¥¹¥È¥ì¡¼¥¸(NoSQL): ĶÂ絬ÌϤʥǡ¼¥¿¤ä¡¤¥ê¥¢¥ë¥¿¥¤...
RDB(¥ê¥ì¡¼¥·¥ç¥Ê¥ë¥Ç¡¼¥¿¥Ù¡¼¥¹)¤Ç¤Ï°·¤¤¤Ë¤¯¤¤¥Ç¡¼¥¿¤ò¼è¤ê...
Áàºî¤¬ SQL ¤Ç¤Þ¤«¤Ê¤¨¤Ê¤¤¤È¤¤¤¦¤³¤È¤Ç¤â¤¢¤ë¤Î¤Ç¡¤NoSQL (N...
** ¥Ç¡¼¥¿¤Îµ¬ÌϤȥǡ¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢¤Î´Ø·¸ [#ra039ee9]
*** ¥Ç¡¼¥¿¤¬Ã±½ã¡¤¤â¤·¤¯¤Ïµ¬ÌϤ¬¾®¤µ¤¤¾ì¹ç [#s626c12e]
Á´¥Ç¡¼¥¿¤¬¥³¥ó¥½¡¼¥ë²èÌÌ 1Ëç¤ËÆþ¤ê¤¤ë¥±¡¼¥¹¤Ê¤É¡¤¥Ç¡¼¥¿...
¤½¤¦¤·¤¿¾ì¹ç¤Ï̵Íý¤Ë¥Ç¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢¤òƳÆþ¤·¤Ê¤¯...
¤³¤¦¤·¤¿¾ì¹ç¤Ïñ¤Ê¤ë¥Æ¥¥¹¥È¥Õ¥¡¥¤¥ë¤Ë¥Ç¡¼¥¿¤òǼ¤á¤Æ¤ª¤¯...
¤Þ¤¿¡¤Î㤨¤Ðñ½ã¤Ê´Ñ¬¥Ç¡¼¥¿¤¬¿ô»ú¤Çʤó¤Ç¤¤¤ë¤À¤±¡¤¤È¤¤...
¿ôÃͲòÀÏ¡¤¿ôÃÍ·×»»¤Ê¤É¤Î¾ì¹ç¤Ï¤³¤¦¤·¤¿¥±¡¼¥¹¤¬Â¿¤½¤¦¤À¡¥
*** ¥Ç¡¼¥¿¤¬¤¢¤ëÄøÅÙÊ£»¨¡¤¤â¤·¤¯¤Ïµ¬ÌϤ¬¾¯¤·Â礤¤¾ì¹ç [#...
¸½¼ÂŪ¤ÊÁÛÄê¤È¤·¤Æ¤Ï½»½êÏ¿¤ä¥½¥Õ¥È¥¦¥§¥¢¤ÎÍÍ¡¹¤ÊÀßÄêÊݸ...
¤³¤ì¤°¤é¤¤¤Îµ¬ÌϤ«¤é¡¤¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÍøÍѤò¸¡Æ¤¤¹¤ë²ÁÃͤ¬...
¤¿¤À¤·¡¤Ê£»¨¤µ¤äµ¬ÌϤ¬¤½¤ì¤Û¤É¤Ç¤â¤Ê¤¤¤³¤ÎÃʳ¬¤Ç¤Ï¡¤
- SQLite ¤Ê¤É¤Î¡¤RDBMS ¤Î¤Ê¤«¤Ç¤â¥µ¡¼¥Ð¥·¥¹¥Æ¥à¤Ç¤Ï¤Ê¤¤¤è...
- ñ¤Ê¤ëÀ°Íý¤·¤¿¥Æ¥¥¹¥È¥Õ¥¡¥¤¥ë + ¾®¤µ¤Ê¥·¥§¥ë¥¹¥¯¥ê¥×¥È...
~
¤°¤é¤¤¤¬(¿ÍŪÅêÆþ¥³¥¹¥È¤ÎÌ̤«¤é¤â)ŬÀڤȹͤ¨¤é¤ì¤ë¡¥
*** ¥Ç¡¼¥¿¤¬Ê£»¨¡¤¤â¤·¤¯¤ÏÂ絬ÌϤʾì¹ç [#df50520e]
¤â¤¦¾¯¤·¥Ç¡¼¥¿¤¬Ê£»¨¡¤¤â¤·¤¯¤ÏÂ絬ÌϤʥ±¡¼¥¹¤Ï¤³¤Á¤é¤Ë¤Ê...
¶ñÂÎŪ¤Ë¤Ï¡¤²ñ¼Ò¤Î³Æ¼ï¶È̳Íѥǡ¼¥¿¤ä¥ª¥ó¥é¥¤¥ó¥·¥ç¥Ã¥Ô¥ó...
¤¬ÁÛÄêÂоݤÀ¤í¤¦¤«¡¥
¤³¤¦¤·¤¿µ¬ÌϤǤϼç¤Ë RDBMS ¤¬»È¤ï¤ì¤Æ¤¤¤ë¡¥
¤¿¤À¤·¡¤¶áǯ¤Ç¤Ï¥³¥ó¥Ô¥å¡¼¥¿¤ÎÀǽ¸þ¾å¤Ë¤è¤ê¡¤Ã±¤Ê¤ë¥Æ¥...
*** ¥Ç¡¼¥¿¤¬Ä¶Ê£»¨¡¤¤â¤·¤¯¤ÏĶÂ絬ÌϤʾì¹ç [#o8552b48]
¥Ç¡¼¥¿¤¬Èó¾ï¤ËÊ£»¨¤À¤Ã¤¿¤ê¤½¤Î¹½Â¤¤¬²òÀÏÁ°¤ÏÉÔÌÀ¤À¤Ã¤¿¤ê...
¥µ¡¼¥Ð 1Âæ¤Ë¼ý¤Þ¤é¤Ê¤¤¤°¤é¤¤Â絬ÌϤÀ¤Ã¤¿¤ê¤¹¤ë¾ì¹ç¡¤RDB ...
¤³¤¦¤·¤¿¾ì¹ç¤Ï¹½Â¤·¿¥¹¥È¥ì¡¼¥¸(NoSQL)¥µ¡¼¥Ð¤¬»È¤ï¤ì¤ë¡¥
* SQLite [#s5224e0c]
Ëܼø¶È¤ÇÍѤ¤¤ë SQLite ¤È¤Ï¡¤RDBMS ¤Î¤Ê¤«¤Ç¤âºÇ¤â·ÚÎ̤ǹ...
¥µ¡¼¥Ð¤Ç¤Ï¤Ê¤¤¤¿¤áÊ£»¨¤Ê¥¤¥ó¥¹¥È¡¼¥ëºî¶È¤¬ÉÔÍפǡ¤¤¹¤°»È...
¤Þ¤¿¡¤¥Ç¡¼¥¿¥Ù¡¼¥¹°ì¤Ä¤Ë¤Ä¤¥Õ¥¡¥¤¥ë¤ò°ì¤Äºî¤ëÊý¼°¤Î¤¿¤á...
¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÁàºî¤Ï SQL ¤Ç¹Ô¤¦¤¿¤á¡¤Â¾¤Î RDBMS ¤È¤¢¤Þ¤ê...
¤¿¤À¤·¡¤¥Ç¡¼¥¿¤Î¡Ö·¿¡×ÀßÄê¤òÍ׵ᤷ¤Ê¤¤¤È¤¤¤¦Í»Ä̤µ¤ò»ý¤Ä...
¼ç¤Ë»È¤ï¤ì¤ë¥Ð¡¼¥¸¥ç¥ó¤Ï 2·ÏÅý¤È 3·ÏÅý¤Ç¤¢¤ë¤¬¡¤¤³¤³¤Ç¤Ï ...
ºåÂç¤Î¶µ°é·×»»µ¡¥·¥¹¥Æ¥à¾å¤Ç¤Ï¡¢cygwin, linux(vmware) ¤Î...
** »ñÎÁ [#p07448da]
- [[&ref(/materials/JNorth_arrow-right-sm.png); SQLite:ht...
SQLite ¤ÎËÜ²È web ¤Ç¤¢¤ë¡¥
SQLite ¤ò¥À¥¦¥ó¥í¡¼¥É¤¹¤ë¤³¤È¤â¤Ç¤¤ë¤¬¡¤cygwin ¤ä Linux ...
&br;&br;
- SQLite ÆþÌç Âè2ÈÇ: Ãø À¾Âô ľÌÚ, æƱ˼Ò(2009).&br;
¾å¤ÎËÜ²È web ¤Ç¤â¾Ò²ð¤µ¤ì¤Æ¤¤¤ë½ñÀҤǤ¢¤ë¡¥ÂêÌܤÎÄ̤ꡤÆþ...
¤¿¤À¤·¡¤ÆþÌç¼Ô¤Ë¤ÏÆñ²ò¤«¤È»×¤ï¤ì¤ëÆâÍƤϺܤäƤ¤¤Ê¤¤(¤È¤¯...
&br;&br;
- ¡ÉSQLite ÆþÌç¡É ¤È¤¤¤¦¥¡¼¥ï¡¼¥É¤Ç¸¡º÷¤·¤Æ½Ð¤Æ¤¯¤ë¤è¤¦¤Ê ...
ÃúÇ«¤Ë½ñ¤«¤ì¤¿Ê¬¤«¤ê¤ä¤¹¤¤¤â¤Î¤â¤¢¤ê¡¤ÂçÊѰ٤ˤʤë¤Î¤Ç¸«...
** SQLite ¤ÎÁàºî [#lcc58404]
&ref(./how-to-treat-db-via-sqlite.png,,50%);&br;
CENTER:SQLite ¤Ï¥é¥¤¥Ö¥é¥ê¡¢¤â¤·¤¯¤Ï¥³¥Þ¥ó¥É¤«¤é¥Ç¡¼¥¿¥Ù...
&br;&br;
¾¤ÎÃø̾¤Ê RDBMS ¤Ï¥½¥Õ¥È¥¦¥§¥¢¤È¤·¤Æ¤Ï¥µ¡¼¥Ð·Á¼°¤ò¤È¤ë¤³...
¤³¤ì¤Ï¡¢¥Í¥Ã¥È¥ï¡¼¥¯±Û¤·¤Ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò°·¤¦¤¿¤á¤Ë¤Ï¤³¤Î...
¤¢¤ëÄøÅÙÂ礤ʵ¬ÌϤΥǡ¼¥¿¥Ù¡¼¥¹¤Ç¤Ï(ÍøÍѼԤ¬Ê£¿ô¤Ë¤Ê¤ë¤³...
¤·¤«¤·¡¢¥µ¡¼¥Ð¤ò¥¤¥ó¥¹¥È¡¼¥ë¡¢²ÔƯ¤µ¤»¤ë¤¿¤á¤Ë¤Ï¥·¥¹¥Æ¥à...
¤³¤ì¤ËÂФ·¡¢SQLite ¤Ï¥µ¡¼¥Ð·Á¼°¤Ç¤Ï¤Ê¤¯¡¢Ã±¤Ê¤ë¥³¥Þ¥ó¥É¡¢...
Ëܼø¶È¤Ç¤Ï¡¢¤â¤Ã¤È¤â´Êñ¤Ê¥³¥Þ¥ó¥É¤«¤é¤ÎÁàºî¤ò»ý¤Ã¤Æ³Ø¤Ö...
** SQLite ¤ÇÍѤ¤¤ë¸À¸ì [#pd483af2]
&ref(./SQLite-commands.png,,70%);&br;
CENTER:SQLite ¤ÇÍѤ¤¤ë¸À¸ì¤Ë¤ÏÆó¼ïÎढ¤ë
&br;&br;
SQLite ¤ò»È¤Ã¤Æ¤ÎÁàºî¤Ë¤Ï¡¢°Ê²¼¤ÎÆó¼ïÎब¤¢¤ê¡¢¤½¤ì¤¾¤ì¤Ë...
&br;&br;
- SQLite ¤½¤Î¤â¤Î¤ÎÁàºî: ³Æ¼ïÀßÄê¤ÎÊѹ¹¡¢É½¼¨¤Ê¤É¡¥
''SQLite ¥³¥Þ¥ó¥É'' ¤È¸Æ¤Ð¤ì¤ë¥³¥Þ¥ó¥É¤òÍѤ¤¤ë¡¥
SQLite ¥³¥Þ¥ó¥É¤Ï .(¥Ô¥ê¥ª¥É)¤Ç»Ï¤Þ¤ëñ¸ì¤Ç¤¢¤ë¤³¤È¤¬ÆÃħ...
&br;&br;
- ¥Ç¡¼¥¿¥Ù¡¼¥¹½èÍý: ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ø¤ÎÁàºî¡¥¥Æ¡¼¥Ö¥ë¤ÎºîÀ®...
¤³¤ì¤Ë¤Ï ''SQL ¥³¥Þ¥ó¥É'' ¤òÍѤ¤¤ë¡¥
SQL ¥³¥Þ¥ó¥É¤Ï¤¢¤ë¤Æ¤¤¤Éµ¬³Ê²½¤µ¤ì¤Æ¤ª¤ê((Àµ³Î¤Ë¤Ï¡¢¤¿¤Ó...
* SQLite ¤Ë¤ª¤±¤ë¥Ç¡¼¥¿¤Î¼è°·¤¤ [#j06ef921]
&ref(./database-table-data-diagram.png,,70%);&br;
CENTER:SQLite ¤Ç¤Î¥Ç¡¼¥¿¤Î¼è°·¤¤. 1¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ¤Ë...
&br;&br;
Ä̾ï¤Ï¡¢RDBMS ¤Ç¤Ï°ì¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ¤Ë¡¤¥Æ¡¼¥Ö¥ë(ɽ)...
¤½¤Î¥Æ¡¼¥Ö¥ë¤ÎÃæ¤Ë°ì¹Ô¤º¤Ä·è¤Þ¤Ã¤¿·Á¼°¤Ç¥Ç¡¼¥¿¤òÆþ¤ì¤ë(¤µ...
¥Æ¡¼¥Ö¥ë¤ÏÃíÌܤ¹¤ë¥Ç¡¼¥¿¤ÎʬÎऴ¤È(Î㤨¤Ð¸ÜµÒ¥ê¥¹¥È¤òʤÙ...
¤³¤Î¤è¤¦¤Ë¡¤¥ê¥¹¥È¥¢¥Ã¥×¤Ç¤¤ë¾ðÊó¤ò¥Æ¡¼¥Ö¥ë¤È¤·¤Æʤ١¤...
¤Ê¤ª¡¢SQLite ¤Ç¤Ï°ì¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò°ì¤Ä¤Î¥Õ¥¡¥¤¥ë¤ËÆþ¤ì...
&br;&br;
¤³¤Î¼ø¶È¤Ç¤Ï¡¢Çä¾å¤ò´ÉÍý¤¹¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤òÁÛÄꤷ¤Æ¤ß¤ë¡¥
¶ñÂÎŪ¤Ë¤Ï¡¢°ì¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ¤Ë ¾¦ÉʾðÊó¤Î¥Æ¡¼¥Ö¥ë¡¢...
¤½¤Î¤Ä¤â¤ê¤Ç°Ê²¼¤òÆɤ߿ʤá¤Æ¤ß¤è¤¦¡¥
&br;&br;
* SQLite3 ¤Îµ¯Æ°¡¢½ªÎ» [#t73682db]
** ¥³¥Þ¥ó¥É¤«¤é SQLite ¤òµ¯Æ°¤¹¤ë = ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ø¤ÎÀܳ ...
SQLite ¤Î¥³¥Þ¥ó¥É¤Ï¡¢°ú¿ô¤Ëʸ»úÎó¤òÍ¿¤¨¤ë¤È¤½¤Î̾Á°¤Î¥Ç¡¼...
¤â¤·¤½¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬¤Ê¤±¤ì¤Ð¿·µ¬¤Ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬ºî¤é¤ì...
¤¿¤È¤¨¤Ð ''db1'' ¤È¤¤¤¦Ì¾Á°¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºî¤ë¤È¤¹¤ë¤È¡¢
> ''sqlite3␣db1''
<
¤ÈÆþÎϤ¹¤ì¤Ð¤è¤¤.
sqlite (ver.3) ¤¬µ¯Æ°¤·¤Æ¥³¥Þ¥ó¥É¼õÉե⡼¥É¤Ë¤Ê¤ë(¥×¥í¥ó...
&ref(/materials/notes.png); (¼Â½¬) ¾å¤Î¤è¤¦¤Ë¤·¤Æ SQLite ...
µ¯Æ°¤·¤¿¤é¤½¤Î¤Þ¤Þ¤Ë¤·¤Æ¡¢¼¡¤Î¼Â½¬¤Þ¤ÇÀè¤ØÆɤ߿ʤá¤è¤¦¡¥
** SQLite ¤Î½ªÎ» [#c4bfe91e]
µ¯Æ°¤·¤¿¡¡SQLite ¤ò½ªÎ»¤¹¤ë¤Ë¤Ï¡¢
> ''.exit''
<
¤â¤·¤¯¤Ï
> ''.quit''
<
¤Ç¤è¤¤¡£
¤½¤ì¤¾¤ì°ìʸ»úÌܤ¬¥Ô¥ê¥ª¥É¤Ç¤¢¤ë¤³¤È¤ËÃí°Õ¤·¤è¤¦¡£
&br;&br;
* SQLite3 ¤ÎÀßÄê [#cdc2dce2]
SQLite ¤òµ¯Æ°¤·¤Æ¤«¤é¡¢¤Þ¤º¤Ï
> ''.show''
<
¤È¤·¤Æ¤ß¤è¤¦¡¥
¸½ºß¤ÎÀßÄê¾õ¶·¤¬°Ê²¼¤Î¤è¤¦¤Ëɽ¼¨¤µ¤ì¤ë(¤â¤Á¤í¤ó¡¢ÆâÍƤÏÀß...
echo: off
eqp: off
explain: off
headers: off
mode: list
nullvalue: ""
output: stdout
separator: "|"
stats: off
width:
¸«¤Æ¿ä¬¤Ç¤¤ë¤è¤¦¤Ë¡¢¤¤¤í¤¤¤íÀßÄê¤Ï¤¢¤ë¤¬¡¢¤Þ¤º¤Ï°Ê²¼¤Î...
> ''.explain␣on''
<
¤³¤ì¤Ï¡¢²èÌ̽ÐÎϤò¤ï¤«¤ê¤ä¤¹¤¯¤¹¤ëÀßÄê¤Ç¤¢¤ê¡¢ÂÐÏÃŪ¤ËÁà...
&br;
&ref(/materials/notes.png); (¼Â½¬) ''.show'' ¥³¥Þ¥ó¥É¤ò»î...
&br;&br;
* SQLite3 ¤Ç¤Î¥Æ¡¼¥Ö¥ë¡ÖñÆÈ¡×Áàºî [#mb594e23]
** ¥Æ¡¼¥Ö¥ë¤òºî¤ë [#b33dd5ed]
¥ê¥ì¡¼¥·¥ç¥Ê¥ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ¿È¤ÎËܼÁ¤Ï¥Ç¡¼¥¿¤òÎóµó¤·¤¿...
¤¿¤À¤·¡¢°ì¤Ä¤Î¥Æ¡¼¥Ö¥ë¤ÎÃæ¤ËÎóµó¤µ¤ì¤ë¥Ç¡¼¥¿¤Ï¤¹¤Ù¤ÆƱ¤¸...
¤½¤Î¹½Â¤¤Ï¡¢¥Æ¡¼¥Ö¥ëºîÀ®»þ¤ËÄêµÁ¤·¤Æ¤ä¤ëɬÍפ¬¤¢¤ë¡£
SQLite ¤Ç¤Î¥Æ¡¼¥Ö¥ë¤ÎºîÀ®»þ¤Ë¤ª¤±¤ë¥Ç¡¼¥¿¤ÎÄêµÁ¤Ï´Êñ¤À¡¥
¤·¤«¤â¥Ç¡¼¥¿¤Î·¿¤ÎÄêµÁ¤ò¾Êά¤¹¤ë¤³¤È¤â¤Ç¤¤ë¤Î¤Ç¡¢¼ÂÍÑŪ...
> ''CREATE␣TABLE␣¥Æ¡¼¥Ö¥ë̾␣(id␣I...
<
&br;
&ref(/materials/warning.png); SQLite3 ¤Ï ; (¥»¥ß¥³¥í¥ó)¤ò...
Á´Éô 1 ¹Ô¤ÇÆþÎϤ¹¤ëɬÍפϤʤ¤¡¥¿Í´Ö¤Ë¤È¤Ã¤Æʬ¤«¤ê°×¤¤¤È¤³...
&br;
&ref(/materials/warning.png); ´·½¬¤È¤·¤Æ SQL Ì¿Îá¤ÏÂçʸ»ú...
ÂÐÏÃŪ¤ËÆþÎϤ¹¤ë¤È¤¤ÏÌÌÅݤÀ¤í¤¦¤«¤é¡¢µ¤¤Ë¤»¤º¤Ë¾®Ê¸»ú¤Î...
&br;
&ref(/materials/warning.png); ¤³¤³¤Ç¤Ï ÊÑ¿ô̾1 ¤ò id ¤È·è...
¤¿¤À¤·¡¢´·¤ì¤Æ¤¤¤Ê¤¤¤¦¤Á¤Ï¤³¤¦¤·¤Æ¤ª¤¯¤È¤Ê¤Ë¤«¤È¸å¤Ç½õ¤«...
&br;
&ref(/materials/warning.png); id ¤Î¸å¤Î ''INTEGER PRIMARY...
id ¤È¤¤¤¦ÊÑ¿ô¤ò¡ÖÀ°¿ô¡×¤Ç¡Ö¤³¤ì¤ò¼ç¥¡¼¤È¤·¤Æ¡×¡Ö¥Ç¡¼¥¿ºï...
¼ç¥¡¼¤È¤¤¤¦¤Î¤Ï¡¢Â绨ÇĤ˸À¤¨¤Ð¡¢¤½¤Îɽ¤ÎÃæ¤Ç¤³¤ÎÊÑ¿ô¤Ë...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë¤·¤Æ¡¢¤Þ¤º¤Ï...
> ''CREATE␣TABLE␣fruits␣(id␣INTEG...
<
¾å¤ÎÃí°Õ¤Ç½ñ¤¤¤¿¤è¤¦¤Ë¡¢°ì¹Ô¤Ç°ìµ¤¤ËÆþÎϤ¹¤ëɬÍפϤʤ¤¡¥...
&br;&br;
** ¥Æ¡¼¥Ö¥ë¤òºï½ü¤¹¤ë [#o1a7fb94]
ºî¤Ã¤¿¥Æ¡¼¥Ö¥ë¤òºï½ü¤¹¤ë¤Î¤Ï´Êñ¤Ç¡¢
> ''DROP␣TABLE␣¥Æ¡¼¥Ö¥ë̾;''
<
¤À¤±¤ÇÎɤ¤¡¥
&br;
&ref(/materials/warning.png); ¤³¤Î´Êñ¤ÊÁàºî¤Ç¤¢¤Ã¤µ¤êÂç...
&br;&br;
** ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¤É¤ó¤Ê¥Æ¡¼¥Ö¥ë¤¬Í¤ë¤«¸«¤Æ¤ß¤ë [#a67e2731]
°ì¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¤ÏÊ£¿ô¤Î¥Æ¡¼¥Ö¥ë¤ò³ÊǼ¤Ç¤¤ë¡¥
¤½¤³¤Ç¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹Ãæ¤Ë¤É¤ó¤Ê¥Æ¡¼¥Ö¥ë¤¬¤¢¤ë¤«Ä´¤Ù¤ëÊýË¡...
¤³¤ì¤Ï .tables Ì¿Îá(SQLite Ì¿Îá)¤ò»È¤Ã¤Æ
> ''.tables''
<
¤È¤¹¤ë¤À¤±¤Ç¤è¤¤¡¥
&br;
&ref(/materials/notes.png); (¼Â½¬) ¾å¤Î ''.tables'' ¥³¥Þ...
&br;&br;
** ¥Æ¡¼¥Ö¥ë¤Ë¥Ç¡¼¥¿¤òÄɲ乤ë [#k67cfd64]
¤µ¤Æ¡¢¥Æ¡¼¥Ö¥ë¤¬´û¤Ë¸ºß¤¹¤ë¤Ê¤é¤Ð¤½¤³¤Ë¥Ç¡¼¥¿¤òÄɲäǤ...
¥Ç¡¼¥¿¤ÎÄÉ²Ã¤Ï INSERT Ì¿Îá¤ò»È¤Ã¤Æ°Ê²¼¤Î¤è¤¦¤Ë¹Ô¤¦¡¥
> ''INSERT␣INTO␣¥Æ¡¼¥Ö¥ë̾␣VALUES(NULL,...
<
&br;
&ref(/materials/warning.png); ¤³¤¦¤¹¤ë¤È¡¢ÊÑ¿ô id ¤ÏÏ¢ÈÖ...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë¤·¤Æ¡¢ fruit...
> ''INSERT␣INTO␣fruits␣VALUES(NULL, "ba...
> ''INSERT␣INTO␣fruits␣VALUES(NULL, "st...
> ''INSERT␣INTO␣fruits␣VALUES(NULL, "ap...
> ''INSERT␣INTO␣fruits␣VALUES(NULL, "wa...
<
&br;
&ref(/materials/warning.png); ¤â¤Á¤í¤ó¡¢Â¾¤Î¥Æ¡¼¥Ö¥ë¤ä¥Ç...
ɬÍפˤʤ俤éÄ´¤Ù¤è¤¦¡¥
&br;&br;
** ¥Æ¡¼¥Ö¥ë¤Î¥Ç¡¼¥¿¤òɽ¼¨¤¹¤ë, ¼è¤ê½Ð¤¹ [#m956bc1b]
¥Æ¡¼¥Ö¥ë¤ËÆþ¤Ã¤Æ¤¤¤ë¥Ç¡¼¥¿¤ò¤Þ¤º¤Ï¸«¤Æ¤ß¤¿¤¤¤È¤¤¤¦¾ì¹ç¤Ï
SELECT Ì¿Îá¤ò»È¤Ã¤Æ°Ê²¼¤Î¤è¤¦¤Ë¤¹¤ë¡¥
> ''SELECT␣*␣FROM␣¥Æ¡¼¥Ö¥ë̾;''
<
&br;
&ref(/materials/warning.png); ¾å¤ÎÀßÄê¤Ç ''.explain on'' ...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¾å¤Î ''SELECT'' ¥³¥Þ¥ó...
¤¤¤ë¤³¤È¤ò³Îǧ¤·¤è¤¦¡¥
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë¤Ï¤º¤À¡¥
id name pric
---- ------------- ----
1 banana 100
2 strawberry 200
3 apple 150
4 water melon 1500
&br;
¤µ¤é¤Ë¡¢¾ò·ï¤ò»ØÄꤷ¤Æ¥Ç¡¼¥¿¤ò¸«¤Æ¤ß¤¿¤¤¤È¤¤¤¦¾ì¹ç¤Ï¡¢
SELECT Ì¿Îá¤Ë WHERE ¶ç¤òÄɲ䷤ưʲ¼¤Î¤è¤¦¤Ë¤¹¤ë¡¥
> ''SELECT␣*␣FROM␣¥Æ¡¼¥Ö¥ë̾␣WHER...
<
WHERE ¤Î¤¢¤È¤Ë³¤¯¡Ö¾ò·ï¡×¤Ï¤¤¤í¤¤¤í¤È½ÀÆð¤Ë»ØÄê¤Ç¤¤ë¡¥
¤³¤³¤ÇÀâÌÀ¤¹¤ë¤Ë¤Ï¿¤¹¤®¤ë¤Î¤Ç¡¢°Ê²¼¤ÎÆóÎã¤ò¤ß¤Æ¤Þ¤º¤Ï´¶...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î ''SELECT'' ¥³¥Þ¥ó...
> ''SELECT␣*␣FROM␣fruits␣WHERE	...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë¤Ï¤º¤À¡¥
id name pric
---- ------------- ----
4 water melon 1500
&br;
¤µ¤é¤Ëº£Å٤ϡ¢fruits ¥Æ¡¼¥Ö¥ëÃæ¤Ç̾Á°¤¬ "¤Û¤Ë¤ã¤é¤énana" ...
> ''SELECT␣*␣FROM␣fruits␣WHERE	...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë¤Ï¤º¤À¡¥
id name pric
---- ------------- ----
1 banana 100
&ref(/materials/warning.png); LIKE Ãæ¤Î % ¤Ï¡ÖǤ°Õ¤Îʸ»ú...
&br;
¤µ¤é¤Ë¡¢¹àÌܤ¹¤Ù¤Æ¤Ç¤Ï¤Ê¤¯¡¢°ìÉô¤Î¹àÌܤÀ¤±¸«¤¿¤¤¤È¤¤¤¦¾ì...
> ''SELECT␣¸«¤¿¤¤¹àÌÜ̾1, ¸«¤¿¤¤¹àÌÜ̾2, ... ␣...
<
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î ''SELECT'' ¥³¥Þ¥ó...
> ''SELECT␣price␣FROM␣fruits;''
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë¤Ï¤º¤À¡¥
pric
----
100
200
150
1500
&br;&br;
** ¥Æ¡¼¥Ö¥ë¤Î¥Ç¡¼¥¿¤ò½¤Àµ¤¹¤ë [#a6b2841a]
¥Æ¡¼¥Ö¥ë¤Ë³ÊǼ¤µ¤ì¤Æ¤¤¤ë¥Ç¡¼¥¿¤ò½¤Àµ¤¹¤ë¤Ë¤Ï¡¢REPLACE Ì¿...
ÅÔ¹ç¤Ë¹ç¤ï¤»¤Æ¹¥¤¤ÊÊý¤ò»È¤ª¤¦¡¥
&br;
¤Þ¤º REPLACE ¤Ï¡¢¼¡¤Î¤è¤¦¤Ë»È¤¦¡¥
> ''REPLACE␣INTO␣¥Æ¡¼¥Ö¥ë̾␣VALUES(idÈÖ...
<
&ref(/materials/warning.png); REPLACE Ì¿Îá¤ò»È¤Ã¤¿»þ¡¢¤½...
¤½¤Î°Õ¿Þ¤¬¤Ê¤¤¾ì¹ç¤Ï´Ö°ã¤¤¤Î¤â¤È¤Ë¤Ê¤ë¤Î¤Çα°Õ¤·¤è¤¦¡¥
&br;
¼¡¤Ë¡¢UPDATE ¤Î»È¤¤Êý¤À¤¬¡¢¼¡¤Î¤è¤¦¤Ë¤¹¤ë¡¥
> ''UPDATE␣¥Æ¡¼¥Ö¥ë̾␣SET␣ÊÑ¿ô̾n=ÊÑ¿ôn...
<
&ref(/materials/warning.png); WHERE °Ê¹ß¤ò¾Êά¤¹¤ë¤È¡¢¥Ç...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë UPDATE ¥³¥Þ...
> ''UPDATE␣fruits␣SET␣price=2000␣...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢SELECT ¥³¥Þ¥ó¥É¤Ç¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë...
id name pric
---- ------------- ----
1 banana 100
2 strawberry 200
3 apple 150
4 water melon 2000
&br;
&ref(/materials/notes.png); (¼Â½¬:±þÍÑ) ¤µ¤é¤Ë¼¡¤Î¤è¤¦¤Ë ...
ñ²Á¤¬ 300±ß̤Ëþ¤Î¾¦ÉʤòÇܤËÃ;夲¤·¤è¤¦¡¥
> ''UPDATE␣fruits␣SET␣price=2*price\...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢SELECT ¥³¥Þ¥ó¥É¤Ç¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë...
id name pric
---- ------------- ----
1 banana 200
2 strawberry 400
3 apple 300
4 water melon 2000
&br;&br;
** ¥Æ¡¼¥Ö¥ë¤Î¥Ç¡¼¥¿¤òºï½ü¤¹¤ë [#bd6f849c]
¥Æ¡¼¥Ö¥ëÃæ¤Î¥Ç¡¼¥¿¤òºï½ü¤¹¤ë¤Ë¤Ï¡¢UPDATE ¥³¥Þ¥ó¥É¤Ë»÷¤¿ D...
> ''DELETE␣FROM␣¥Æ¡¼¥Ö¥ë̾␣WHERE␣...
<
&ref(/materials/warning.png); ¤³¤ì¤â WHERE °Ê¹ß¤ò¾Êά¤¹¤ë...
¤Ä¤Þ¤ê¡¢''¥Ç¡¼¥¿¤¬Á´Éô¾Ã¤¨¤Æ¤·¤Þ¤¦!'' ¤Î¤Ç¡¢´Ö°ã¤¨¤Æ¤½¤¦...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë DELETE ¥³¥Þ...
strawberry ¤Ë¤Ä¤¤¤Æ¤Î¾ðÊó¤òºï½ü¤·¤è¤¦¡¥
> ''DELETE␣FROM␣fruits␣WHERE␣id=2...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢SELECT ¥³¥Þ¥ó¥É¤Ç¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë...
id name pric
---- ------------- ----
1 banana 200
3 apple 300
4 water melon 2000
&ref(/materials/warning.png); °ìÅٻȤï¤ì¤¿ id ÈÖ¹æ 2 ¤¬·ç...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë INSERT ¥³¥Þ...
·çÈÖ id ¤¬¤É¤Î¤è¤¦¤Ë°·¤ï¤ì¤ë¤«ÇÄ°®¤·¤è¤¦¡¥
> ''INSERT␣INTO␣fruits␣VALUES(NULL, "or...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢SELECT ¥³¥Þ¥ó¥É¤Ç¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë...
id name pric
---- ------------- ----
1 banana 200
3 apple 300
4 water melon 2000
5 orange 400
&ref(/materials/warning.png); ¼«Æ°Ï¢ÈÖµ¡Ç½¤òÍѤ¤¤ë¤È id ...
&br;&br;
* SQLite3 ¤Ç¤Î¥Æ¡¼¥Ö¥ë¤Î¡ÖÁê¸ßºîÍѤò¹Íθ¤·¤¿¡×Áàºî [#n3c0...
¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ç¤Î¥Æ¡¼¥Ö¥ëÁê¸ßºîÍѤδðËܤϡ¢²¿¤«¤Î¹àÌܤò¶¦...
Æñ¤·¤¯¤Ï¤Ê¤¤¤¬¤ä¤Ã¤Æ¤ß¤Ê¤¤¤È¼Â´¶¤·¤Ë¤¯¤¤¤Î¤Ç¡¢¼Â½¬¤òÄ̤¸...
** ½àÈ÷ [#q9378e89]
¼Â½¬¤òÄ̤¸¤Æ³Ø¤Ö¤¿¤á¤Ë¡¢¾¯¤·½àÈ÷¤ò¤·¤è¤¦¡¥
¶ñÂÎŪ¤Ë¤Ï¡¢¤â¤¦Æó¤Ä¡¢Â¾¤Î¥Æ¡¼¥Ö¥ë¤òƱ¤¸¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë CREATE ¥³¥Þ...
&br;
¤Þ¤º°ì¤ÄÌܤϡ¢¸ÜµÒ¥ê¥¹¥È¤òʤ٤¿ customers ¥Æ¡¼¥Ö¥ë¤Ç¤¢¤ë¡¥
¸ÜµÒ¤È¤·¤Æ 3¿Í¤Û¤É¥Ç¡¼¥¿¤òÆþ¤ì¤Æ¤ª¤³¤¦¡¥
> ''CREATE␣TABLE␣customers␣(id␣IN...
> ''INSERT␣INTO␣customers␣VALUES(NULL,"...
> ''INSERT␣INTO␣customers␣VALUES(NULL,"...
> ''INSERT␣INTO␣customers␣VALUES(NULL,"...
<
SELECT Ì¿Îá¤ÇÃæ¿È¤ò¤ß¤ë¤È¼¡¤Î¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤Ï¤º¤À¡¥
id name
---- -------------
1 john
2 tom
3 mike
&br;
Æó¤ÄÌܤϡ¢Çä¾å¥ê¥¹¥È¤òʤ٤¿ sales ¥Æ¡¼¥Ö¥ë¤Ç¤¢¤ë¡¥
Çä¾å¥ê¥¹¥È¤Ï¡¢&br;
''id, ¸ÜµÒid, ¾¦ÉÊid, Çä¤ì¤¿¸Ä¿ô'' &br;
¤È¤·¤Æ¤ª¤³¤¦¡¥
> ''CREATE␣TABLE␣sales␣(id␣INTEGE...
<
¤µ¤Æ¡¢5 ²ó¤ÎÇä¾å¤²¾ðÊó¤òÆþ¤ì¤Æ¤ª¤³¤¦¡¥
> ''INSERT␣INTO␣sales␣VALUES(NULL,2,5,3...
> ''INSERT␣INTO␣sales␣VALUES(NULL,1,1,1...
> ''INSERT␣INTO␣sales␣VALUES(NULL,2,3,2...
> ''INSERT␣INTO␣sales␣VALUES(NULL,2,1,4...
> ''INSERT␣INTO␣sales␣VALUES(NULL,3,4,1...
<
SELECT Ì¿Îá¤Ç sales ¥Æ¡¼¥Ö¥ë¤ÎÃæ¿È¤ò¤ß¤ë¤È¼¡¤Î¤è¤¦¤Ë¤Ê¤Ã...
id customer_id frui quan
---- ------------- ---- ----
1 2 5 3
2 1 1 1
3 2 3 2
4 2 1 4
5 3 4 10
&br;
&ref(/materials/warning.png); ¤³¤Î sales ¥Æ¡¼¥Ö¥ë¤Ï¾¤Î¥Æ...
** ¶¦Ä̾ðÊó¤ò¤â¤È¤Ë¥Æ¡¼¥Ö¥ë¤ò¹çÂΤµ¤»¤ë [#r013e739]
¤³¤ì¤Ç¤³¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¤Ï·× 3¤Ä¤Î¥Æ¡¼¥Ö¥ë¤¬Í¤ë¤Ï¤º¤Ç¤¢...
°ì±þ¡¢''.tables'' ¥³¥Þ¥ó¥É¤Ç
> ''.tables''
<
¤È¤¹¤ë¤È¡¢
customers fruits sales
¤È½ÐÎϤµ¤ì¤ë¤³¤È¤ò³Îǧ¤·¤è¤¦¡¥
¤³¤Î 3¤Ä¤Î¥Æ¡¼¥Ö¥ë¤Î¤¦¤Á¾¤Î¥Æ¡¼¥Ö¥ë¤Î¾ðÊó¤ò°úÍѤ¹¤ë·Á¤Ë...
sales ¥Æ¡¼¥Ö¥ë¤Ë¾¤Î¥Æ¡¼¥Ö¥ë¤Î¾ðÊó¤ò¹çÂÎ(join)¤µ¤»¤Æ¤ß¤è...
¶ñÂÎŪ¤Ë¤Ï¡¢SELECT ¤È°ì½ï¤Ë''JOIN'' Ì¿Îá¤ò»È¤Ã¤Æ¡¢¹çÂΤµ...
ʸˡ¤È¤·¤Æ¤Ï¼¡¤Î¤è¤¦¤Ê´¶¤¸¤À¡¥
> ''SELECT␣*␣FROM␣¥Æ¡¼¥Ö¥ë̾1''
> ''␣JOIN␣¥Æ¡¼¥Ö¥ë̾2␣ON␣¥Æ¡¼¥Ö¥ë...
<
ºÇ¸å¤Î = ¤Ç·Ò¤¬¤ì¤Æ¤¤¤ëÆó¤Ä¤Î¹àÌܤ¬¡¢¤³¤Î¥Æ¡¼¥Ö¥ë´Ö¤Ç¶¦ÄÌ...
¤Þ¤¢¡¢¼¡¤Î¼Â½¬¤ò¤ä¤Ã¤Æ¤ß¤¿¤Û¤¦¤¬¤ï¤«¤ê¤ä¤¹¤¤¤À¤í¤¦¡¥
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë, sales ¥Æ¡¼...
> ''SELECT␣*␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
<
¤¹¤ë¤È¡¢¼¡¤Î¤è¤¦¤Ê´¶¤¸¤Ç¥Ç¡¼¥¿¤¬ÆÀ¤é¤ì¤ë¤Ï¤º¤Ç¤¢¤ë¡¥
id customer_id fruit_id quantity id ...
---- ------------- ------------- ------------- ----...
1 2 5 3 2 ...
2 1 1 1 1 ...
3 2 3 2 2 ...
4 2 1 4 2 ...
5 3 4 10 3 ...
Á´ÂΤΡ¢Âè2¹àÌÜ(sales ¥Æ¡¼¥Ö¥ë¤Î customer_id) ¤ÈÂè5¹àÌÜ(c...
&br;
¤³¤ì¤Ç¤Ï¸«¤Ë¤¯¤¤¡¢¤È¤¤¤¦¤è¤¦¤Ç¤¢¤ì¤Ð½ÐÎϤò¸«¤ä¤¹¤¤¤â¤Î¤À...
Î㤨¤Ð¼¡¤Î¤è¤¦¤Ê´¶¤¸¤À¡¥
> ''SELECT␣sales.id, name, fruit_id, quantity''
> ''␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
<
¼¡¤Î¤è¤¦¤Ê½ÐÎϤ¬ÆÀ¤é¤ì¤ë¤Ï¤º¤À¡¥
id name fruit_id quantity
---- ------------- ------------- -------------
1 tom 5 3
2 john 1 1
3 tom 3 2
4 tom 1 4
5 mike 4 10
&ref(/materials/warning.png); ¥Æ¡¼¥Ö¥ë¤ò¹çÂΤµ¤»¤ë¤È¡¢Æ±...
¤³¤ì¤òÛ£Ëæ¤Ëµ½Ò¤·¤ÆÌ¿Î᤹¤ë¤È¥¨¥é¡¼¤Ë¤Ê¤ë¤Î¤Ç¡¢¤½¤¦¤¤¤¦...
¾å¤ÎÎã¤Ç¤â SELECT ¤ÎÂÐ¾Ý¤Ç sales.id ¤È¤·¤Æ¶èÊ̤·¤Æ¤¤¤ë¤Î...
&br;
*** JOIN ¤Ï¤¤¤¯¤Ä¤Ç¤â¤¤¤±¤ë! [#c6a70b65]
JOIN ¤Ï¤¤¤¯¤Ä¤Ç¤â¥Æ¡¼¥Ö¥ë¤ò¹çÂΤµ¤»¤é¤ì¤ë¡¥
ñ¤Ë¸å¤í¤Ë³¤±¤Æµ½Ò¤¹¤ì¤Ð¤¤¤¤¤À¤±¤Ç¤¢¤ë¡¥
¼¡¤Î¼Â½¬¤Ç³Î¤«¤á¤è¤¦¡¥
&br;
&ref(/materials/notes.png); (¼Â½¬) sales ¥Æ¡¼¥Ö¥ë¤ÎÇä¾å¾ð...
¶ñÂÎŪ¤Ë¤ÏÀè¤ÎÎã¤Ë¤µ¤é¤Ë¤â¤¦°ì²ó join ¤ò¤¹¤ì¤ÐÎɤ¤¡¥
> ''SELECT␣*␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
> ''␣JOIN␣fruits␣ON␣sales.fruit_i...
<
¤¹¤ë¤È¡¢(²£¤ËŤ¤¤¬)¼¡¤Î¤è¤¦¤Ê½ÐÎϤòÆÀ¤ë¤Ï¤º¤À¡¥
id customer_id fruit_id quantity id ...
---- ------------- ------------- ------------- ----...
1 2 5 3 2 ...
2 1 1 1 1 ...
3 2 3 2 2 ...
4 2 1 4 2 ...
5 3 4 10 3 ...
&br;
¤ï¤«¤ê¤ä¤¹¤¯¤¹¤ë¤Ê¤é¤Ð¡¢¼¡¤Î¤è¤¦¤Ê´¶¤¸¤«¡¥
> ''SELECT␣sales.id, customers.name, fruits.name, p...
> ''␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
> ''␣JOIN␣fruits␣ON␣sales.fruit_i...
<
¤¹¤ë¤È¡¢¼¡¤Î¤è¤¦¤Êʬ¤«¤ê°×¤¤½ÐÎϤòÆÀ¤ë¤À¤í¤¦¡¥
id name name price quan
---- ------------- ------------- ------------- ----
1 tom orange 400 3
2 john banana 200 1
3 tom apple 300 2
4 tom banana 200 4
5 mike water melon 2000 10
¤³¤ì¤ò¤ß¤ì¤Ð¡¢Î㤨¤ÐÂè4²óÌܤμè°ú¤¤Ç¤Ï tom ¤¬200±ß¤Î¥Ð¥Ê...
&br;
&ref(/materials/warning.png); ¤³¤ó¤ÊÌÌÅݤʤ³¤È¤ò¤·¤Ê¤¤¤Ç...
¤·¤«¤·¤½¤ì¤ò¤ä¤ë¤È¡¢ÅÓÃæ¤Ç²¿¤«¤òÊѹ¹¤¹¤ë¤È²áµî¤Î¥Ç¡¼¥¿¤È...
¤¢¤ëÍó¤Ç¤Ï tom ¤È½ñ¤Â¾¤ÎÍó¤Ç¤Ï ton ¤ÈµºÜ¥ß¥¹¤¹¤ë¤ÈÊÌ¿Í...
¾¦ÉʾðÊó¤Ï¾¦Éʥơ¼¥Ö¥ëñÆȤǡ¢¸ÜµÒ¾ðÊó¤Ï¸ÜµÒ¥Æ¡¼¥Ö¥ëñÆÈ...
¾¤Î¥Æ¡¼¥Ö¥ë¤«¤é»²¾È¤Ç¤¤ë¡¢¤È¤¤¤¦¤Î¤¬ RDB ¤Î¥Ý¥¤¥ó¥È¤Ê¤Î...
¤³¤ì¤Ï¥Ç¡¼¥¿¤Î´ÉÍý¤Î¡Ö°ÂÁ´À¡×¤ò°ÕÌ£¤¹¤ë¡¥
¥Ç¡¼¥¿¤¬Â¿¤¯¡¢Ê£»¨¤Ë¤Ê¤ì¤Ð¤Ê¤ë¤Û¤É¤³¤Î¤³¤È¤Î½ÅÍ×À¤ÏÁý¤¹...
&br;
¤µ¤Æ¡¢¤µ¤é¤Ë¥Ç¡¼¥¿¤ò¸«¤ë¤À¤±¤Ç¤Ï¤Ê¤¯¤Æ¡¢¤¹¤³¤·²Ã¹©¤·¤Æ¤ß...
> ''SELECT␣sales.id, customers.name, fruits.name, p...
> ''␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
> ''␣JOIN␣fruits␣ON␣sales.fruit_i...
<
¤¹¤ë¤È¼¡¤Î¤è¤¦¤Ë¡¢Ã±²Áx¸Ä¿ô=¾®·× ¤â¥ê¥¹¥È¥¢¥Ã¥×¤Ç¤¤ë¡¥
id name name price quan...
---- ------------- ------------- ------------- ----...
1 tom orange 400 3 ...
2 john banana 200 1 ...
3 tom apple 300 2 ...
4 tom banana 200 4 ...
5 mike water melon 2000 10 ...
&br;
(±þÍÑ) ¤µ¤Æ¡¢¤µ¤é¤Ë¡¢Ã¯¤Ë¤¤¤¯¤éÀÁµá¤¹¤ë¤Ù¤¤«¤â¹ç·×¤ò¸«¤Æ...
¸ÜµÒ¾ðÊó¤ò¤â¤È¤Ë¤Þ¤È¤á¤ë¤ï¤±¤À¤¬¡¢¤³¤ì¤Ë¤Ï ''GROUP BY'' ...
¤Ê¤ª¡¢¹ç·×¤Ë¤Ïñ¤Ê¤ë ''SUM'' ¤È¤¤¤¦Ì¿Î᤬»È¤¨¤ë¡¥
> ''SELECT␣customers.name, &color(red){SUM(price*qu...
> ''␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
> ''␣JOIN␣fruits␣ON␣sales.fruit_i...
> ''␣&color(red){GROUP␣BY};␣customers.i...
<
¤¹¤ë¤È¡¢¼¡¤Î¤è¤¦¤Ê½ÐÎϤòÆÀ¤ë¤³¤È¤¬¤Ç¤¤ë¡¥
name sum(price*qua
---- -------------
john 200
tom 2600
mike 20000
¤³¤ì¤Ç¡¢¤À¤ì¤Ë¹ç·×¤Ç¤¤¤¯¤é»Ùʧ¤Ã¤Æ¤â¤é¤¨¤Ð¤è¤¤¤«¡¢°ìÌÜÎÆ...
&br;&br;
* ºÇ¸å¤Ë [#d2dd1cd3]
º£²ó¤Ï SQLite ¤ò¥³¥Þ¥ó¥É¥é¥¤¥ó¤«¤éľÀÜÁàºî¤·¤Æ RDBMS ¤ÎÆþ...
RDB ¤ò¼ÂÍѤ˶¡¤¹¤ë¾ì¹ç¤Ï¡¤¥é¥¤¥Ö¥é¥ê·Ðͳ¤«¥µ¡¼¥Ð·Ðͳ¤È¤Ê...
¤½¤¦¤¤¤Ã¤¿ºÝ¤Ë¤è¤¯¤ï¤«¤é¤Ê¤¯¤Ê¤Ã¤¿¤é¡¤º£²ó¤Î¤è¤¦¤ËľÀÜ¥³...
&br;&br;
* Report: ¥ì¥Ý¡¼¥È [#f50a4c0c]
°Ê²¼¤Î²ÝÂê¤Ë¤Ä¤¤¤Æǽ¤¦¸Â¤ê¸ÌÀ¤ÊÄ´ºº¤È¹Í»¡¤ò¹Ô¤¤¡¤
&br;
''AppliedMath7-Report-13''
&br;
¤È¤¤¤¦Âê̾¤ò¤Ä¤±¤Æ e-mail ¤Ë¤Æ¶µ´±°¸¤Ë¥ì¥Ý¡¼¥È¤È¤·¤ÆÄó½Ð...
** Exercises: ²ÝÂê [#of5ea7ec]
+ ¾å¤Î¼Â½¬¤ò³¤±¤Æ¡¢¤µ¤é¤Ë¡¢¤É¤Î¾¦Éʤ¬¹ç·×¤Ç¤¤¤¯¤ÄÇä¤ì¤¿...
&br;&br;
+ SQLite ¤Ç¡¢¥Õ¥¡¥¤¥ë¤«¤é¥Ç¡¼¥¿¤òÆɤ߹þ¤àÊýË¡¤òÄ´¤Ù¤è¡¥
&br;&br;
+ SQLite ¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò GUI ¤ÇÁàºî¤Ç¤¤ë¥¢¥×¥ê¥±¡¼¥·¥ç...
¤½¤¦¤¤¤Ã¤¿Êª¤òõ¤·¡¤¤½¤Î¤¦¤Á¤Î°ì¤Ä¤ÇÎɤ¤¤Î¤Ç¼ÂºÝ¤ËÁàºî¤·...
&br;&br;
+ ¼«Ê¬¤ÎÀ¸³è¤ÎÃæ¤Ç SQLite ¤òÍøÍѤ¹¤ë¤ÈÊØÍø¤Ë¤Ê¤ê¤½¤¦¤Ê¥·...
&br;&br;
* about Icons, ClipArts [#fc36f792]
For details, see [[&ref(/materials/JNorth_arrow-right-sm....
// ¨¬¨¨®¨¯¨°¨±¨²¨³¨´¨µ¨¶
// ¥³¥Þ¥ó¥É¥é¥¤¥óÆþÎϤϡֹÔƬ¤ò > ¤Ç»Ï¤á¤ë¡×.
// ¥³¥Þ¥ó¥É¥é¥¤¥ó½ÐÎϤϡֹÔƬ¤ò¥Ö¥é¥ó¥¯¤Ç»Ï¤á¤ë¡×.
// ¼Â½¬¥¢¥¤¥³¥ó
// &ref(/materials/notes.png);
// Ãí°Õ¥¢¥¤¥³¥ó
// &ref(/materials/warning.png);
// Link ¥¢¥¤¥³¥ó
// &ref(/materials/JNorth_arrow-right-sm.png);
// OK ¥¢¥¤¥³¥ó
// &ref(/materials/OK.png);
// NG ¥¢¥¤¥³¥ó
// &ref(/materials/NG.png);
// ¥µ¥ó¥×¥ë¥¢¥¤¥³¥ó
// &ref(/materials/Gnome-Preferences.png);
// Âçʸ»ú¤Ç¤Î¶¯Ä´
// CENTER:&size(24){''¤Û¤²¤Û¤²''};
// programu source ɽµ
// #highlighter(language=ruby,number=on,cache=on){{}}
// ¥Ñ¥¤¥×
// ¦
// ¶õÇòµ¹æ
// ␣
// ¥¿¥Öµ¹æ
// ␉
½ªÎ»¹Ô:
#CONTENTS
// Âè 13 ²ó -- ¥Ç¡¼¥¿¥Ù¡¼¥¹ÆþÌç (SQLite)
* ¥Ç¡¼¥¿¤Î¼è¤ê°·¤¤¤Ë¤Ä¤¤¤Æ [#s15f7577]
¤¢¤ëÄøÅÙÂ絬ÌϤÀ¤Ã¤¿¤êÊ£»¨¤À¤Ã¤¿¤ê¤¹¤ë¥Ç¡¼¥¿¤ò½èÍý¤¹¤ë¤³...
¤è¤¯¤¢¤ë¤³¤È¤Ç¤¢¤ë¤Î¤Ç¡¤¤³¤¦¤·¤¿¥Ç¡¼¥¿¤ò¡Ö¤É¤Î¤è¤¦¤ËÊݸ...
¤É¤Î¤è¤¦¤Ë¼è¤ê½Ð¤¹¤«¡×¤È¤¤¤¦»ëÅÀ¤Ç¤¤Á¤ó¤Èª¤¨¤Æ°ìÄê¤Îµ¬...
¤³¤¦¤·¤¿¹Í¤¨Êý¤¬°ìÂΤηÁ¤ò¤È¤Ã¤¿¤â¤Î¤¬°Ê²¼¤Ë½Ò¤Ù¤ë¥Ç¡¼¥¿...
* ¥Ç¡¼¥¿¥Ù¡¼¥¹(¥½¥Õ¥È¥¦¥§¥¢)¤È¤Ï [#p43c1b32]
Â绨ÇĤ˸À¤¨¤Ð¡¤¼ý½¸¤µ¤ì¤¿¥Ç¡¼¥¿¤Î½¸¹çÂΤ½¤Î¤â¤Î¤ò»Ø¤¹.
¤Þ¤¿¤Ï¡¤¥Ç¡¼¥¿¤òÊݸ¤¹¤ë¤³¤È¡¤¤Þ¤¿¡¤°ìÄê¤Î¥ë¡¼¥ë¤Ë¤½¤Ã¤Æ...
¥Ç¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢¤Î¶¯¤ß¤Ï¤Þ¤º¤Ï¤½¤ÎÈÆÍÑÀ¡¤¤Ä¤Þ¤ê...
¤Þ¤¿¡¤¥Ç¡¼¥¿¤ò¼è¤ê°·¤¦¤³¤È¤ËÆò½¤·¤Æ¤¤¤ë¤³¤È¤Ë¤è¤ê¡¤Áàºî...
¤¿¤À¡¤¤³¤¦¤·¤¿¹âµ¡Ç½À¤Ï¥½¥Õ¥È¥¦¥§¥¢¤ÎÈîÂç²½¡¤ÈÑ»¨¤µ¤È¶¯...
&br;&br;
&ref(/materials/warning.png);
¤è¤Ã¤Æ¡¤¡Ö¤½¤Î¥Ç¡¼¥¿¹½Â¤¤Ë¤Î¤ß¡×Æò½¤·¤¿¸¤¤¥×¥í¥°¥é¥à¤Î...
ÈÆÍѥǡ¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢¤è¤ê¤âÍ¥½¨¤Ç¤¢¤ë¤³¤È¤Ï½¼Ê¬¤Ë...
ÂоݤȤ¹¤ë¥Ç¡¼¥¿¤Î¼è°·¤Ë¤½¤â¤½¤â¥Ç¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢...
¤Þ¤º¤ÏºÇ½é¤Ë¸¡Æ¤¤·¤¿¤Û¤¦¤¬¤¤¤¤¤À¤í¤¦¡¥
** ¥Ç¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢¤Î¼ïÎà [#a5fd080b]
Èó¾ï¤ËÂ绨ÇĤËʬ¤±¤ë¤Î¤Ê¤é¤Ð¡¤´Ê°×¤Ê¤â¤Î¤«¤éÈó¾ï¤ËÂ絬ÌÏ...
- ɽ·×»»¥½¥Õ¥È¡¤Ã±¤Ê¤ë¥Æ¥¥¹¥È¥Õ¥¡¥¤¥ë+Unix¥³¥Þ¥ó¥É·² Åù...
- RDBMS(¥ê¥ì¡¼¥·¥ç¥Ê¥ë¥Ç¡¼¥¿¥Ù¡¼¥¹´ÉÍý¥·¥¹¥Æ¥à): ¥Ç¡¼¥¿¥Ù...
¥½¥Õ¥È¥¦¥§¥¢¤È¤·¤Æ¤Ï´Ê°×¤Ê¤â¤Î¤Ï¥é¥¤¥Ö¥é¥ê¡¤¥³¥Þ¥ó¥É¤È¤·...
- ¹½Â¤·¿¥¹¥È¥ì¡¼¥¸(NoSQL): ĶÂ絬ÌϤʥǡ¼¥¿¤ä¡¤¥ê¥¢¥ë¥¿¥¤...
RDB(¥ê¥ì¡¼¥·¥ç¥Ê¥ë¥Ç¡¼¥¿¥Ù¡¼¥¹)¤Ç¤Ï°·¤¤¤Ë¤¯¤¤¥Ç¡¼¥¿¤ò¼è¤ê...
Áàºî¤¬ SQL ¤Ç¤Þ¤«¤Ê¤¨¤Ê¤¤¤È¤¤¤¦¤³¤È¤Ç¤â¤¢¤ë¤Î¤Ç¡¤NoSQL (N...
** ¥Ç¡¼¥¿¤Îµ¬ÌϤȥǡ¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢¤Î´Ø·¸ [#ra039ee9]
*** ¥Ç¡¼¥¿¤¬Ã±½ã¡¤¤â¤·¤¯¤Ïµ¬ÌϤ¬¾®¤µ¤¤¾ì¹ç [#s626c12e]
Á´¥Ç¡¼¥¿¤¬¥³¥ó¥½¡¼¥ë²èÌÌ 1Ëç¤ËÆþ¤ê¤¤ë¥±¡¼¥¹¤Ê¤É¡¤¥Ç¡¼¥¿...
¤½¤¦¤·¤¿¾ì¹ç¤Ï̵Íý¤Ë¥Ç¡¼¥¿¥Ù¡¼¥¹¥½¥Õ¥È¥¦¥§¥¢¤òƳÆþ¤·¤Ê¤¯...
¤³¤¦¤·¤¿¾ì¹ç¤Ïñ¤Ê¤ë¥Æ¥¥¹¥È¥Õ¥¡¥¤¥ë¤Ë¥Ç¡¼¥¿¤òǼ¤á¤Æ¤ª¤¯...
¤Þ¤¿¡¤Î㤨¤Ðñ½ã¤Ê´Ñ¬¥Ç¡¼¥¿¤¬¿ô»ú¤Çʤó¤Ç¤¤¤ë¤À¤±¡¤¤È¤¤...
¿ôÃͲòÀÏ¡¤¿ôÃÍ·×»»¤Ê¤É¤Î¾ì¹ç¤Ï¤³¤¦¤·¤¿¥±¡¼¥¹¤¬Â¿¤½¤¦¤À¡¥
*** ¥Ç¡¼¥¿¤¬¤¢¤ëÄøÅÙÊ£»¨¡¤¤â¤·¤¯¤Ïµ¬ÌϤ¬¾¯¤·Â礤¤¾ì¹ç [#...
¸½¼ÂŪ¤ÊÁÛÄê¤È¤·¤Æ¤Ï½»½êÏ¿¤ä¥½¥Õ¥È¥¦¥§¥¢¤ÎÍÍ¡¹¤ÊÀßÄêÊݸ...
¤³¤ì¤°¤é¤¤¤Îµ¬ÌϤ«¤é¡¤¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÍøÍѤò¸¡Æ¤¤¹¤ë²ÁÃͤ¬...
¤¿¤À¤·¡¤Ê£»¨¤µ¤äµ¬ÌϤ¬¤½¤ì¤Û¤É¤Ç¤â¤Ê¤¤¤³¤ÎÃʳ¬¤Ç¤Ï¡¤
- SQLite ¤Ê¤É¤Î¡¤RDBMS ¤Î¤Ê¤«¤Ç¤â¥µ¡¼¥Ð¥·¥¹¥Æ¥à¤Ç¤Ï¤Ê¤¤¤è...
- ñ¤Ê¤ëÀ°Íý¤·¤¿¥Æ¥¥¹¥È¥Õ¥¡¥¤¥ë + ¾®¤µ¤Ê¥·¥§¥ë¥¹¥¯¥ê¥×¥È...
~
¤°¤é¤¤¤¬(¿ÍŪÅêÆþ¥³¥¹¥È¤ÎÌ̤«¤é¤â)ŬÀڤȹͤ¨¤é¤ì¤ë¡¥
*** ¥Ç¡¼¥¿¤¬Ê£»¨¡¤¤â¤·¤¯¤ÏÂ絬ÌϤʾì¹ç [#df50520e]
¤â¤¦¾¯¤·¥Ç¡¼¥¿¤¬Ê£»¨¡¤¤â¤·¤¯¤ÏÂ絬ÌϤʥ±¡¼¥¹¤Ï¤³¤Á¤é¤Ë¤Ê...
¶ñÂÎŪ¤Ë¤Ï¡¤²ñ¼Ò¤Î³Æ¼ï¶È̳Íѥǡ¼¥¿¤ä¥ª¥ó¥é¥¤¥ó¥·¥ç¥Ã¥Ô¥ó...
¤¬ÁÛÄêÂоݤÀ¤í¤¦¤«¡¥
¤³¤¦¤·¤¿µ¬ÌϤǤϼç¤Ë RDBMS ¤¬»È¤ï¤ì¤Æ¤¤¤ë¡¥
¤¿¤À¤·¡¤¶áǯ¤Ç¤Ï¥³¥ó¥Ô¥å¡¼¥¿¤ÎÀǽ¸þ¾å¤Ë¤è¤ê¡¤Ã±¤Ê¤ë¥Æ¥...
*** ¥Ç¡¼¥¿¤¬Ä¶Ê£»¨¡¤¤â¤·¤¯¤ÏĶÂ絬ÌϤʾì¹ç [#o8552b48]
¥Ç¡¼¥¿¤¬Èó¾ï¤ËÊ£»¨¤À¤Ã¤¿¤ê¤½¤Î¹½Â¤¤¬²òÀÏÁ°¤ÏÉÔÌÀ¤À¤Ã¤¿¤ê...
¥µ¡¼¥Ð 1Âæ¤Ë¼ý¤Þ¤é¤Ê¤¤¤°¤é¤¤Â絬ÌϤÀ¤Ã¤¿¤ê¤¹¤ë¾ì¹ç¡¤RDB ...
¤³¤¦¤·¤¿¾ì¹ç¤Ï¹½Â¤·¿¥¹¥È¥ì¡¼¥¸(NoSQL)¥µ¡¼¥Ð¤¬»È¤ï¤ì¤ë¡¥
* SQLite [#s5224e0c]
Ëܼø¶È¤ÇÍѤ¤¤ë SQLite ¤È¤Ï¡¤RDBMS ¤Î¤Ê¤«¤Ç¤âºÇ¤â·ÚÎ̤ǹ...
¥µ¡¼¥Ð¤Ç¤Ï¤Ê¤¤¤¿¤áÊ£»¨¤Ê¥¤¥ó¥¹¥È¡¼¥ëºî¶È¤¬ÉÔÍפǡ¤¤¹¤°»È...
¤Þ¤¿¡¤¥Ç¡¼¥¿¥Ù¡¼¥¹°ì¤Ä¤Ë¤Ä¤¥Õ¥¡¥¤¥ë¤ò°ì¤Äºî¤ëÊý¼°¤Î¤¿¤á...
¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÁàºî¤Ï SQL ¤Ç¹Ô¤¦¤¿¤á¡¤Â¾¤Î RDBMS ¤È¤¢¤Þ¤ê...
¤¿¤À¤·¡¤¥Ç¡¼¥¿¤Î¡Ö·¿¡×ÀßÄê¤òÍ׵ᤷ¤Ê¤¤¤È¤¤¤¦Í»Ä̤µ¤ò»ý¤Ä...
¼ç¤Ë»È¤ï¤ì¤ë¥Ð¡¼¥¸¥ç¥ó¤Ï 2·ÏÅý¤È 3·ÏÅý¤Ç¤¢¤ë¤¬¡¤¤³¤³¤Ç¤Ï ...
ºåÂç¤Î¶µ°é·×»»µ¡¥·¥¹¥Æ¥à¾å¤Ç¤Ï¡¢cygwin, linux(vmware) ¤Î...
** »ñÎÁ [#p07448da]
- [[&ref(/materials/JNorth_arrow-right-sm.png); SQLite:ht...
SQLite ¤ÎËÜ²È web ¤Ç¤¢¤ë¡¥
SQLite ¤ò¥À¥¦¥ó¥í¡¼¥É¤¹¤ë¤³¤È¤â¤Ç¤¤ë¤¬¡¤cygwin ¤ä Linux ...
&br;&br;
- SQLite ÆþÌç Âè2ÈÇ: Ãø À¾Âô ľÌÚ, æƱ˼Ò(2009).&br;
¾å¤ÎËÜ²È web ¤Ç¤â¾Ò²ð¤µ¤ì¤Æ¤¤¤ë½ñÀҤǤ¢¤ë¡¥ÂêÌܤÎÄ̤ꡤÆþ...
¤¿¤À¤·¡¤ÆþÌç¼Ô¤Ë¤ÏÆñ²ò¤«¤È»×¤ï¤ì¤ëÆâÍƤϺܤäƤ¤¤Ê¤¤(¤È¤¯...
&br;&br;
- ¡ÉSQLite ÆþÌç¡É ¤È¤¤¤¦¥¡¼¥ï¡¼¥É¤Ç¸¡º÷¤·¤Æ½Ð¤Æ¤¯¤ë¤è¤¦¤Ê ...
ÃúÇ«¤Ë½ñ¤«¤ì¤¿Ê¬¤«¤ê¤ä¤¹¤¤¤â¤Î¤â¤¢¤ê¡¤ÂçÊѰ٤ˤʤë¤Î¤Ç¸«...
** SQLite ¤ÎÁàºî [#lcc58404]
&ref(./how-to-treat-db-via-sqlite.png,,50%);&br;
CENTER:SQLite ¤Ï¥é¥¤¥Ö¥é¥ê¡¢¤â¤·¤¯¤Ï¥³¥Þ¥ó¥É¤«¤é¥Ç¡¼¥¿¥Ù...
&br;&br;
¾¤ÎÃø̾¤Ê RDBMS ¤Ï¥½¥Õ¥È¥¦¥§¥¢¤È¤·¤Æ¤Ï¥µ¡¼¥Ð·Á¼°¤ò¤È¤ë¤³...
¤³¤ì¤Ï¡¢¥Í¥Ã¥È¥ï¡¼¥¯±Û¤·¤Ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò°·¤¦¤¿¤á¤Ë¤Ï¤³¤Î...
¤¢¤ëÄøÅÙÂ礤ʵ¬ÌϤΥǡ¼¥¿¥Ù¡¼¥¹¤Ç¤Ï(ÍøÍѼԤ¬Ê£¿ô¤Ë¤Ê¤ë¤³...
¤·¤«¤·¡¢¥µ¡¼¥Ð¤ò¥¤¥ó¥¹¥È¡¼¥ë¡¢²ÔƯ¤µ¤»¤ë¤¿¤á¤Ë¤Ï¥·¥¹¥Æ¥à...
¤³¤ì¤ËÂФ·¡¢SQLite ¤Ï¥µ¡¼¥Ð·Á¼°¤Ç¤Ï¤Ê¤¯¡¢Ã±¤Ê¤ë¥³¥Þ¥ó¥É¡¢...
Ëܼø¶È¤Ç¤Ï¡¢¤â¤Ã¤È¤â´Êñ¤Ê¥³¥Þ¥ó¥É¤«¤é¤ÎÁàºî¤ò»ý¤Ã¤Æ³Ø¤Ö...
** SQLite ¤ÇÍѤ¤¤ë¸À¸ì [#pd483af2]
&ref(./SQLite-commands.png,,70%);&br;
CENTER:SQLite ¤ÇÍѤ¤¤ë¸À¸ì¤Ë¤ÏÆó¼ïÎढ¤ë
&br;&br;
SQLite ¤ò»È¤Ã¤Æ¤ÎÁàºî¤Ë¤Ï¡¢°Ê²¼¤ÎÆó¼ïÎब¤¢¤ê¡¢¤½¤ì¤¾¤ì¤Ë...
&br;&br;
- SQLite ¤½¤Î¤â¤Î¤ÎÁàºî: ³Æ¼ïÀßÄê¤ÎÊѹ¹¡¢É½¼¨¤Ê¤É¡¥
''SQLite ¥³¥Þ¥ó¥É'' ¤È¸Æ¤Ð¤ì¤ë¥³¥Þ¥ó¥É¤òÍѤ¤¤ë¡¥
SQLite ¥³¥Þ¥ó¥É¤Ï .(¥Ô¥ê¥ª¥É)¤Ç»Ï¤Þ¤ëñ¸ì¤Ç¤¢¤ë¤³¤È¤¬ÆÃħ...
&br;&br;
- ¥Ç¡¼¥¿¥Ù¡¼¥¹½èÍý: ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ø¤ÎÁàºî¡¥¥Æ¡¼¥Ö¥ë¤ÎºîÀ®...
¤³¤ì¤Ë¤Ï ''SQL ¥³¥Þ¥ó¥É'' ¤òÍѤ¤¤ë¡¥
SQL ¥³¥Þ¥ó¥É¤Ï¤¢¤ë¤Æ¤¤¤Éµ¬³Ê²½¤µ¤ì¤Æ¤ª¤ê((Àµ³Î¤Ë¤Ï¡¢¤¿¤Ó...
* SQLite ¤Ë¤ª¤±¤ë¥Ç¡¼¥¿¤Î¼è°·¤¤ [#j06ef921]
&ref(./database-table-data-diagram.png,,70%);&br;
CENTER:SQLite ¤Ç¤Î¥Ç¡¼¥¿¤Î¼è°·¤¤. 1¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ¤Ë...
&br;&br;
Ä̾ï¤Ï¡¢RDBMS ¤Ç¤Ï°ì¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ¤Ë¡¤¥Æ¡¼¥Ö¥ë(ɽ)...
¤½¤Î¥Æ¡¼¥Ö¥ë¤ÎÃæ¤Ë°ì¹Ô¤º¤Ä·è¤Þ¤Ã¤¿·Á¼°¤Ç¥Ç¡¼¥¿¤òÆþ¤ì¤ë(¤µ...
¥Æ¡¼¥Ö¥ë¤ÏÃíÌܤ¹¤ë¥Ç¡¼¥¿¤ÎʬÎऴ¤È(Î㤨¤Ð¸ÜµÒ¥ê¥¹¥È¤òʤÙ...
¤³¤Î¤è¤¦¤Ë¡¤¥ê¥¹¥È¥¢¥Ã¥×¤Ç¤¤ë¾ðÊó¤ò¥Æ¡¼¥Ö¥ë¤È¤·¤Æʤ١¤...
¤Ê¤ª¡¢SQLite ¤Ç¤Ï°ì¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò°ì¤Ä¤Î¥Õ¥¡¥¤¥ë¤ËÆþ¤ì...
&br;&br;
¤³¤Î¼ø¶È¤Ç¤Ï¡¢Çä¾å¤ò´ÉÍý¤¹¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤òÁÛÄꤷ¤Æ¤ß¤ë¡¥
¶ñÂÎŪ¤Ë¤Ï¡¢°ì¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ¤Ë ¾¦ÉʾðÊó¤Î¥Æ¡¼¥Ö¥ë¡¢...
¤½¤Î¤Ä¤â¤ê¤Ç°Ê²¼¤òÆɤ߿ʤá¤Æ¤ß¤è¤¦¡¥
&br;&br;
* SQLite3 ¤Îµ¯Æ°¡¢½ªÎ» [#t73682db]
** ¥³¥Þ¥ó¥É¤«¤é SQLite ¤òµ¯Æ°¤¹¤ë = ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ø¤ÎÀܳ ...
SQLite ¤Î¥³¥Þ¥ó¥É¤Ï¡¢°ú¿ô¤Ëʸ»úÎó¤òÍ¿¤¨¤ë¤È¤½¤Î̾Á°¤Î¥Ç¡¼...
¤â¤·¤½¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬¤Ê¤±¤ì¤Ð¿·µ¬¤Ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤¬ºî¤é¤ì...
¤¿¤È¤¨¤Ð ''db1'' ¤È¤¤¤¦Ì¾Á°¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºî¤ë¤È¤¹¤ë¤È¡¢
> ''sqlite3␣db1''
<
¤ÈÆþÎϤ¹¤ì¤Ð¤è¤¤.
sqlite (ver.3) ¤¬µ¯Æ°¤·¤Æ¥³¥Þ¥ó¥É¼õÉե⡼¥É¤Ë¤Ê¤ë(¥×¥í¥ó...
&ref(/materials/notes.png); (¼Â½¬) ¾å¤Î¤è¤¦¤Ë¤·¤Æ SQLite ...
µ¯Æ°¤·¤¿¤é¤½¤Î¤Þ¤Þ¤Ë¤·¤Æ¡¢¼¡¤Î¼Â½¬¤Þ¤ÇÀè¤ØÆɤ߿ʤá¤è¤¦¡¥
** SQLite ¤Î½ªÎ» [#c4bfe91e]
µ¯Æ°¤·¤¿¡¡SQLite ¤ò½ªÎ»¤¹¤ë¤Ë¤Ï¡¢
> ''.exit''
<
¤â¤·¤¯¤Ï
> ''.quit''
<
¤Ç¤è¤¤¡£
¤½¤ì¤¾¤ì°ìʸ»úÌܤ¬¥Ô¥ê¥ª¥É¤Ç¤¢¤ë¤³¤È¤ËÃí°Õ¤·¤è¤¦¡£
&br;&br;
* SQLite3 ¤ÎÀßÄê [#cdc2dce2]
SQLite ¤òµ¯Æ°¤·¤Æ¤«¤é¡¢¤Þ¤º¤Ï
> ''.show''
<
¤È¤·¤Æ¤ß¤è¤¦¡¥
¸½ºß¤ÎÀßÄê¾õ¶·¤¬°Ê²¼¤Î¤è¤¦¤Ëɽ¼¨¤µ¤ì¤ë(¤â¤Á¤í¤ó¡¢ÆâÍƤÏÀß...
echo: off
eqp: off
explain: off
headers: off
mode: list
nullvalue: ""
output: stdout
separator: "|"
stats: off
width:
¸«¤Æ¿ä¬¤Ç¤¤ë¤è¤¦¤Ë¡¢¤¤¤í¤¤¤íÀßÄê¤Ï¤¢¤ë¤¬¡¢¤Þ¤º¤Ï°Ê²¼¤Î...
> ''.explain␣on''
<
¤³¤ì¤Ï¡¢²èÌ̽ÐÎϤò¤ï¤«¤ê¤ä¤¹¤¯¤¹¤ëÀßÄê¤Ç¤¢¤ê¡¢ÂÐÏÃŪ¤ËÁà...
&br;
&ref(/materials/notes.png); (¼Â½¬) ''.show'' ¥³¥Þ¥ó¥É¤ò»î...
&br;&br;
* SQLite3 ¤Ç¤Î¥Æ¡¼¥Ö¥ë¡ÖñÆÈ¡×Áàºî [#mb594e23]
** ¥Æ¡¼¥Ö¥ë¤òºî¤ë [#b33dd5ed]
¥ê¥ì¡¼¥·¥ç¥Ê¥ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ¿È¤ÎËܼÁ¤Ï¥Ç¡¼¥¿¤òÎóµó¤·¤¿...
¤¿¤À¤·¡¢°ì¤Ä¤Î¥Æ¡¼¥Ö¥ë¤ÎÃæ¤ËÎóµó¤µ¤ì¤ë¥Ç¡¼¥¿¤Ï¤¹¤Ù¤ÆƱ¤¸...
¤½¤Î¹½Â¤¤Ï¡¢¥Æ¡¼¥Ö¥ëºîÀ®»þ¤ËÄêµÁ¤·¤Æ¤ä¤ëɬÍפ¬¤¢¤ë¡£
SQLite ¤Ç¤Î¥Æ¡¼¥Ö¥ë¤ÎºîÀ®»þ¤Ë¤ª¤±¤ë¥Ç¡¼¥¿¤ÎÄêµÁ¤Ï´Êñ¤À¡¥
¤·¤«¤â¥Ç¡¼¥¿¤Î·¿¤ÎÄêµÁ¤ò¾Êά¤¹¤ë¤³¤È¤â¤Ç¤¤ë¤Î¤Ç¡¢¼ÂÍÑŪ...
> ''CREATE␣TABLE␣¥Æ¡¼¥Ö¥ë̾␣(id␣I...
<
&br;
&ref(/materials/warning.png); SQLite3 ¤Ï ; (¥»¥ß¥³¥í¥ó)¤ò...
Á´Éô 1 ¹Ô¤ÇÆþÎϤ¹¤ëɬÍפϤʤ¤¡¥¿Í´Ö¤Ë¤È¤Ã¤Æʬ¤«¤ê°×¤¤¤È¤³...
&br;
&ref(/materials/warning.png); ´·½¬¤È¤·¤Æ SQL Ì¿Îá¤ÏÂçʸ»ú...
ÂÐÏÃŪ¤ËÆþÎϤ¹¤ë¤È¤¤ÏÌÌÅݤÀ¤í¤¦¤«¤é¡¢µ¤¤Ë¤»¤º¤Ë¾®Ê¸»ú¤Î...
&br;
&ref(/materials/warning.png); ¤³¤³¤Ç¤Ï ÊÑ¿ô̾1 ¤ò id ¤È·è...
¤¿¤À¤·¡¢´·¤ì¤Æ¤¤¤Ê¤¤¤¦¤Á¤Ï¤³¤¦¤·¤Æ¤ª¤¯¤È¤Ê¤Ë¤«¤È¸å¤Ç½õ¤«...
&br;
&ref(/materials/warning.png); id ¤Î¸å¤Î ''INTEGER PRIMARY...
id ¤È¤¤¤¦ÊÑ¿ô¤ò¡ÖÀ°¿ô¡×¤Ç¡Ö¤³¤ì¤ò¼ç¥¡¼¤È¤·¤Æ¡×¡Ö¥Ç¡¼¥¿ºï...
¼ç¥¡¼¤È¤¤¤¦¤Î¤Ï¡¢Â绨ÇĤ˸À¤¨¤Ð¡¢¤½¤Îɽ¤ÎÃæ¤Ç¤³¤ÎÊÑ¿ô¤Ë...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë¤·¤Æ¡¢¤Þ¤º¤Ï...
> ''CREATE␣TABLE␣fruits␣(id␣INTEG...
<
¾å¤ÎÃí°Õ¤Ç½ñ¤¤¤¿¤è¤¦¤Ë¡¢°ì¹Ô¤Ç°ìµ¤¤ËÆþÎϤ¹¤ëɬÍפϤʤ¤¡¥...
&br;&br;
** ¥Æ¡¼¥Ö¥ë¤òºï½ü¤¹¤ë [#o1a7fb94]
ºî¤Ã¤¿¥Æ¡¼¥Ö¥ë¤òºï½ü¤¹¤ë¤Î¤Ï´Êñ¤Ç¡¢
> ''DROP␣TABLE␣¥Æ¡¼¥Ö¥ë̾;''
<
¤À¤±¤ÇÎɤ¤¡¥
&br;
&ref(/materials/warning.png); ¤³¤Î´Êñ¤ÊÁàºî¤Ç¤¢¤Ã¤µ¤êÂç...
&br;&br;
** ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¤É¤ó¤Ê¥Æ¡¼¥Ö¥ë¤¬Í¤ë¤«¸«¤Æ¤ß¤ë [#a67e2731]
°ì¤Ä¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¤ÏÊ£¿ô¤Î¥Æ¡¼¥Ö¥ë¤ò³ÊǼ¤Ç¤¤ë¡¥
¤½¤³¤Ç¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹Ãæ¤Ë¤É¤ó¤Ê¥Æ¡¼¥Ö¥ë¤¬¤¢¤ë¤«Ä´¤Ù¤ëÊýË¡...
¤³¤ì¤Ï .tables Ì¿Îá(SQLite Ì¿Îá)¤ò»È¤Ã¤Æ
> ''.tables''
<
¤È¤¹¤ë¤À¤±¤Ç¤è¤¤¡¥
&br;
&ref(/materials/notes.png); (¼Â½¬) ¾å¤Î ''.tables'' ¥³¥Þ...
&br;&br;
** ¥Æ¡¼¥Ö¥ë¤Ë¥Ç¡¼¥¿¤òÄɲ乤ë [#k67cfd64]
¤µ¤Æ¡¢¥Æ¡¼¥Ö¥ë¤¬´û¤Ë¸ºß¤¹¤ë¤Ê¤é¤Ð¤½¤³¤Ë¥Ç¡¼¥¿¤òÄɲäǤ...
¥Ç¡¼¥¿¤ÎÄÉ²Ã¤Ï INSERT Ì¿Îá¤ò»È¤Ã¤Æ°Ê²¼¤Î¤è¤¦¤Ë¹Ô¤¦¡¥
> ''INSERT␣INTO␣¥Æ¡¼¥Ö¥ë̾␣VALUES(NULL,...
<
&br;
&ref(/materials/warning.png); ¤³¤¦¤¹¤ë¤È¡¢ÊÑ¿ô id ¤ÏÏ¢ÈÖ...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë¤·¤Æ¡¢ fruit...
> ''INSERT␣INTO␣fruits␣VALUES(NULL, "ba...
> ''INSERT␣INTO␣fruits␣VALUES(NULL, "st...
> ''INSERT␣INTO␣fruits␣VALUES(NULL, "ap...
> ''INSERT␣INTO␣fruits␣VALUES(NULL, "wa...
<
&br;
&ref(/materials/warning.png); ¤â¤Á¤í¤ó¡¢Â¾¤Î¥Æ¡¼¥Ö¥ë¤ä¥Ç...
ɬÍפˤʤ俤éÄ´¤Ù¤è¤¦¡¥
&br;&br;
** ¥Æ¡¼¥Ö¥ë¤Î¥Ç¡¼¥¿¤òɽ¼¨¤¹¤ë, ¼è¤ê½Ð¤¹ [#m956bc1b]
¥Æ¡¼¥Ö¥ë¤ËÆþ¤Ã¤Æ¤¤¤ë¥Ç¡¼¥¿¤ò¤Þ¤º¤Ï¸«¤Æ¤ß¤¿¤¤¤È¤¤¤¦¾ì¹ç¤Ï
SELECT Ì¿Îá¤ò»È¤Ã¤Æ°Ê²¼¤Î¤è¤¦¤Ë¤¹¤ë¡¥
> ''SELECT␣*␣FROM␣¥Æ¡¼¥Ö¥ë̾;''
<
&br;
&ref(/materials/warning.png); ¾å¤ÎÀßÄê¤Ç ''.explain on'' ...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¾å¤Î ''SELECT'' ¥³¥Þ¥ó...
¤¤¤ë¤³¤È¤ò³Îǧ¤·¤è¤¦¡¥
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë¤Ï¤º¤À¡¥
id name pric
---- ------------- ----
1 banana 100
2 strawberry 200
3 apple 150
4 water melon 1500
&br;
¤µ¤é¤Ë¡¢¾ò·ï¤ò»ØÄꤷ¤Æ¥Ç¡¼¥¿¤ò¸«¤Æ¤ß¤¿¤¤¤È¤¤¤¦¾ì¹ç¤Ï¡¢
SELECT Ì¿Îá¤Ë WHERE ¶ç¤òÄɲ䷤ưʲ¼¤Î¤è¤¦¤Ë¤¹¤ë¡¥
> ''SELECT␣*␣FROM␣¥Æ¡¼¥Ö¥ë̾␣WHER...
<
WHERE ¤Î¤¢¤È¤Ë³¤¯¡Ö¾ò·ï¡×¤Ï¤¤¤í¤¤¤í¤È½ÀÆð¤Ë»ØÄê¤Ç¤¤ë¡¥
¤³¤³¤ÇÀâÌÀ¤¹¤ë¤Ë¤Ï¿¤¹¤®¤ë¤Î¤Ç¡¢°Ê²¼¤ÎÆóÎã¤ò¤ß¤Æ¤Þ¤º¤Ï´¶...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î ''SELECT'' ¥³¥Þ¥ó...
> ''SELECT␣*␣FROM␣fruits␣WHERE	...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë¤Ï¤º¤À¡¥
id name pric
---- ------------- ----
4 water melon 1500
&br;
¤µ¤é¤Ëº£Å٤ϡ¢fruits ¥Æ¡¼¥Ö¥ëÃæ¤Ç̾Á°¤¬ "¤Û¤Ë¤ã¤é¤énana" ...
> ''SELECT␣*␣FROM␣fruits␣WHERE	...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë¤Ï¤º¤À¡¥
id name pric
---- ------------- ----
1 banana 100
&ref(/materials/warning.png); LIKE Ãæ¤Î % ¤Ï¡ÖǤ°Õ¤Îʸ»ú...
&br;
¤µ¤é¤Ë¡¢¹àÌܤ¹¤Ù¤Æ¤Ç¤Ï¤Ê¤¯¡¢°ìÉô¤Î¹àÌܤÀ¤±¸«¤¿¤¤¤È¤¤¤¦¾ì...
> ''SELECT␣¸«¤¿¤¤¹àÌÜ̾1, ¸«¤¿¤¤¹àÌÜ̾2, ... ␣...
<
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î ''SELECT'' ¥³¥Þ¥ó...
> ''SELECT␣price␣FROM␣fruits;''
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë¤Ï¤º¤À¡¥
pric
----
100
200
150
1500
&br;&br;
** ¥Æ¡¼¥Ö¥ë¤Î¥Ç¡¼¥¿¤ò½¤Àµ¤¹¤ë [#a6b2841a]
¥Æ¡¼¥Ö¥ë¤Ë³ÊǼ¤µ¤ì¤Æ¤¤¤ë¥Ç¡¼¥¿¤ò½¤Àµ¤¹¤ë¤Ë¤Ï¡¢REPLACE Ì¿...
ÅÔ¹ç¤Ë¹ç¤ï¤»¤Æ¹¥¤¤ÊÊý¤ò»È¤ª¤¦¡¥
&br;
¤Þ¤º REPLACE ¤Ï¡¢¼¡¤Î¤è¤¦¤Ë»È¤¦¡¥
> ''REPLACE␣INTO␣¥Æ¡¼¥Ö¥ë̾␣VALUES(idÈÖ...
<
&ref(/materials/warning.png); REPLACE Ì¿Îá¤ò»È¤Ã¤¿»þ¡¢¤½...
¤½¤Î°Õ¿Þ¤¬¤Ê¤¤¾ì¹ç¤Ï´Ö°ã¤¤¤Î¤â¤È¤Ë¤Ê¤ë¤Î¤Çα°Õ¤·¤è¤¦¡¥
&br;
¼¡¤Ë¡¢UPDATE ¤Î»È¤¤Êý¤À¤¬¡¢¼¡¤Î¤è¤¦¤Ë¤¹¤ë¡¥
> ''UPDATE␣¥Æ¡¼¥Ö¥ë̾␣SET␣ÊÑ¿ô̾n=ÊÑ¿ôn...
<
&ref(/materials/warning.png); WHERE °Ê¹ß¤ò¾Êά¤¹¤ë¤È¡¢¥Ç...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë UPDATE ¥³¥Þ...
> ''UPDATE␣fruits␣SET␣price=2000␣...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢SELECT ¥³¥Þ¥ó¥É¤Ç¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë...
id name pric
---- ------------- ----
1 banana 100
2 strawberry 200
3 apple 150
4 water melon 2000
&br;
&ref(/materials/notes.png); (¼Â½¬:±þÍÑ) ¤µ¤é¤Ë¼¡¤Î¤è¤¦¤Ë ...
ñ²Á¤¬ 300±ß̤Ëþ¤Î¾¦ÉʤòÇܤËÃ;夲¤·¤è¤¦¡¥
> ''UPDATE␣fruits␣SET␣price=2*price\...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢SELECT ¥³¥Þ¥ó¥É¤Ç¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë...
id name pric
---- ------------- ----
1 banana 200
2 strawberry 400
3 apple 300
4 water melon 2000
&br;&br;
** ¥Æ¡¼¥Ö¥ë¤Î¥Ç¡¼¥¿¤òºï½ü¤¹¤ë [#bd6f849c]
¥Æ¡¼¥Ö¥ëÃæ¤Î¥Ç¡¼¥¿¤òºï½ü¤¹¤ë¤Ë¤Ï¡¢UPDATE ¥³¥Þ¥ó¥É¤Ë»÷¤¿ D...
> ''DELETE␣FROM␣¥Æ¡¼¥Ö¥ë̾␣WHERE␣...
<
&ref(/materials/warning.png); ¤³¤ì¤â WHERE °Ê¹ß¤ò¾Êά¤¹¤ë...
¤Ä¤Þ¤ê¡¢''¥Ç¡¼¥¿¤¬Á´Éô¾Ã¤¨¤Æ¤·¤Þ¤¦!'' ¤Î¤Ç¡¢´Ö°ã¤¨¤Æ¤½¤¦...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë DELETE ¥³¥Þ...
strawberry ¤Ë¤Ä¤¤¤Æ¤Î¾ðÊó¤òºï½ü¤·¤è¤¦¡¥
> ''DELETE␣FROM␣fruits␣WHERE␣id=2...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢SELECT ¥³¥Þ¥ó¥É¤Ç¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë...
id name pric
---- ------------- ----
1 banana 200
3 apple 300
4 water melon 2000
&ref(/materials/warning.png); °ìÅٻȤï¤ì¤¿ id ÈÖ¹æ 2 ¤¬·ç...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë INSERT ¥³¥Þ...
·çÈÖ id ¤¬¤É¤Î¤è¤¦¤Ë°·¤ï¤ì¤ë¤«ÇÄ°®¤·¤è¤¦¡¥
> ''INSERT␣INTO␣fruits␣VALUES(NULL, "or...
<
¤¦¤Þ¤¯¤¤¤Ã¤Æ¤¤¤ì¤Ð¡¢SELECT ¥³¥Þ¥ó¥É¤Ç¼¡¤Î¤è¤¦¤Ëɽµ¤µ¤ì¤ë...
id name pric
---- ------------- ----
1 banana 200
3 apple 300
4 water melon 2000
5 orange 400
&ref(/materials/warning.png); ¼«Æ°Ï¢ÈÖµ¡Ç½¤òÍѤ¤¤ë¤È id ...
&br;&br;
* SQLite3 ¤Ç¤Î¥Æ¡¼¥Ö¥ë¤Î¡ÖÁê¸ßºîÍѤò¹Íθ¤·¤¿¡×Áàºî [#n3c0...
¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ç¤Î¥Æ¡¼¥Ö¥ëÁê¸ßºîÍѤδðËܤϡ¢²¿¤«¤Î¹àÌܤò¶¦...
Æñ¤·¤¯¤Ï¤Ê¤¤¤¬¤ä¤Ã¤Æ¤ß¤Ê¤¤¤È¼Â´¶¤·¤Ë¤¯¤¤¤Î¤Ç¡¢¼Â½¬¤òÄ̤¸...
** ½àÈ÷ [#q9378e89]
¼Â½¬¤òÄ̤¸¤Æ³Ø¤Ö¤¿¤á¤Ë¡¢¾¯¤·½àÈ÷¤ò¤·¤è¤¦¡¥
¶ñÂÎŪ¤Ë¤Ï¡¢¤â¤¦Æó¤Ä¡¢Â¾¤Î¥Æ¡¼¥Ö¥ë¤òƱ¤¸¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÃæ...
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë CREATE ¥³¥Þ...
&br;
¤Þ¤º°ì¤ÄÌܤϡ¢¸ÜµÒ¥ê¥¹¥È¤òʤ٤¿ customers ¥Æ¡¼¥Ö¥ë¤Ç¤¢¤ë¡¥
¸ÜµÒ¤È¤·¤Æ 3¿Í¤Û¤É¥Ç¡¼¥¿¤òÆþ¤ì¤Æ¤ª¤³¤¦¡¥
> ''CREATE␣TABLE␣customers␣(id␣IN...
> ''INSERT␣INTO␣customers␣VALUES(NULL,"...
> ''INSERT␣INTO␣customers␣VALUES(NULL,"...
> ''INSERT␣INTO␣customers␣VALUES(NULL,"...
<
SELECT Ì¿Îá¤ÇÃæ¿È¤ò¤ß¤ë¤È¼¡¤Î¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤Ï¤º¤À¡¥
id name
---- -------------
1 john
2 tom
3 mike
&br;
Æó¤ÄÌܤϡ¢Çä¾å¥ê¥¹¥È¤òʤ٤¿ sales ¥Æ¡¼¥Ö¥ë¤Ç¤¢¤ë¡¥
Çä¾å¥ê¥¹¥È¤Ï¡¢&br;
''id, ¸ÜµÒid, ¾¦ÉÊid, Çä¤ì¤¿¸Ä¿ô'' &br;
¤È¤·¤Æ¤ª¤³¤¦¡¥
> ''CREATE␣TABLE␣sales␣(id␣INTEGE...
<
¤µ¤Æ¡¢5 ²ó¤ÎÇä¾å¤²¾ðÊó¤òÆþ¤ì¤Æ¤ª¤³¤¦¡¥
> ''INSERT␣INTO␣sales␣VALUES(NULL,2,5,3...
> ''INSERT␣INTO␣sales␣VALUES(NULL,1,1,1...
> ''INSERT␣INTO␣sales␣VALUES(NULL,2,3,2...
> ''INSERT␣INTO␣sales␣VALUES(NULL,2,1,4...
> ''INSERT␣INTO␣sales␣VALUES(NULL,3,4,1...
<
SELECT Ì¿Îá¤Ç sales ¥Æ¡¼¥Ö¥ë¤ÎÃæ¿È¤ò¤ß¤ë¤È¼¡¤Î¤è¤¦¤Ë¤Ê¤Ã...
id customer_id frui quan
---- ------------- ---- ----
1 2 5 3
2 1 1 1
3 2 3 2
4 2 1 4
5 3 4 10
&br;
&ref(/materials/warning.png); ¤³¤Î sales ¥Æ¡¼¥Ö¥ë¤Ï¾¤Î¥Æ...
** ¶¦Ä̾ðÊó¤ò¤â¤È¤Ë¥Æ¡¼¥Ö¥ë¤ò¹çÂΤµ¤»¤ë [#r013e739]
¤³¤ì¤Ç¤³¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¤Ï·× 3¤Ä¤Î¥Æ¡¼¥Ö¥ë¤¬Í¤ë¤Ï¤º¤Ç¤¢...
°ì±þ¡¢''.tables'' ¥³¥Þ¥ó¥É¤Ç
> ''.tables''
<
¤È¤¹¤ë¤È¡¢
customers fruits sales
¤È½ÐÎϤµ¤ì¤ë¤³¤È¤ò³Îǧ¤·¤è¤¦¡¥
¤³¤Î 3¤Ä¤Î¥Æ¡¼¥Ö¥ë¤Î¤¦¤Á¾¤Î¥Æ¡¼¥Ö¥ë¤Î¾ðÊó¤ò°úÍѤ¹¤ë·Á¤Ë...
sales ¥Æ¡¼¥Ö¥ë¤Ë¾¤Î¥Æ¡¼¥Ö¥ë¤Î¾ðÊó¤ò¹çÂÎ(join)¤µ¤»¤Æ¤ß¤è...
¶ñÂÎŪ¤Ë¤Ï¡¢SELECT ¤È°ì½ï¤Ë''JOIN'' Ì¿Îá¤ò»È¤Ã¤Æ¡¢¹çÂΤµ...
ʸˡ¤È¤·¤Æ¤Ï¼¡¤Î¤è¤¦¤Ê´¶¤¸¤À¡¥
> ''SELECT␣*␣FROM␣¥Æ¡¼¥Ö¥ë̾1''
> ''␣JOIN␣¥Æ¡¼¥Ö¥ë̾2␣ON␣¥Æ¡¼¥Ö¥ë...
<
ºÇ¸å¤Î = ¤Ç·Ò¤¬¤ì¤Æ¤¤¤ëÆó¤Ä¤Î¹àÌܤ¬¡¢¤³¤Î¥Æ¡¼¥Ö¥ë´Ö¤Ç¶¦ÄÌ...
¤Þ¤¢¡¢¼¡¤Î¼Â½¬¤ò¤ä¤Ã¤Æ¤ß¤¿¤Û¤¦¤¬¤ï¤«¤ê¤ä¤¹¤¤¤À¤í¤¦¡¥
&br;
&ref(/materials/notes.png); (¼Â½¬) ¼¡¤Î¤è¤¦¤Ë, sales ¥Æ¡¼...
> ''SELECT␣*␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
<
¤¹¤ë¤È¡¢¼¡¤Î¤è¤¦¤Ê´¶¤¸¤Ç¥Ç¡¼¥¿¤¬ÆÀ¤é¤ì¤ë¤Ï¤º¤Ç¤¢¤ë¡¥
id customer_id fruit_id quantity id ...
---- ------------- ------------- ------------- ----...
1 2 5 3 2 ...
2 1 1 1 1 ...
3 2 3 2 2 ...
4 2 1 4 2 ...
5 3 4 10 3 ...
Á´ÂΤΡ¢Âè2¹àÌÜ(sales ¥Æ¡¼¥Ö¥ë¤Î customer_id) ¤ÈÂè5¹àÌÜ(c...
&br;
¤³¤ì¤Ç¤Ï¸«¤Ë¤¯¤¤¡¢¤È¤¤¤¦¤è¤¦¤Ç¤¢¤ì¤Ð½ÐÎϤò¸«¤ä¤¹¤¤¤â¤Î¤À...
Î㤨¤Ð¼¡¤Î¤è¤¦¤Ê´¶¤¸¤À¡¥
> ''SELECT␣sales.id, name, fruit_id, quantity''
> ''␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
<
¼¡¤Î¤è¤¦¤Ê½ÐÎϤ¬ÆÀ¤é¤ì¤ë¤Ï¤º¤À¡¥
id name fruit_id quantity
---- ------------- ------------- -------------
1 tom 5 3
2 john 1 1
3 tom 3 2
4 tom 1 4
5 mike 4 10
&ref(/materials/warning.png); ¥Æ¡¼¥Ö¥ë¤ò¹çÂΤµ¤»¤ë¤È¡¢Æ±...
¤³¤ì¤òÛ£Ëæ¤Ëµ½Ò¤·¤ÆÌ¿Î᤹¤ë¤È¥¨¥é¡¼¤Ë¤Ê¤ë¤Î¤Ç¡¢¤½¤¦¤¤¤¦...
¾å¤ÎÎã¤Ç¤â SELECT ¤ÎÂÐ¾Ý¤Ç sales.id ¤È¤·¤Æ¶èÊ̤·¤Æ¤¤¤ë¤Î...
&br;
*** JOIN ¤Ï¤¤¤¯¤Ä¤Ç¤â¤¤¤±¤ë! [#c6a70b65]
JOIN ¤Ï¤¤¤¯¤Ä¤Ç¤â¥Æ¡¼¥Ö¥ë¤ò¹çÂΤµ¤»¤é¤ì¤ë¡¥
ñ¤Ë¸å¤í¤Ë³¤±¤Æµ½Ò¤¹¤ì¤Ð¤¤¤¤¤À¤±¤Ç¤¢¤ë¡¥
¼¡¤Î¼Â½¬¤Ç³Î¤«¤á¤è¤¦¡¥
&br;
&ref(/materials/notes.png); (¼Â½¬) sales ¥Æ¡¼¥Ö¥ë¤ÎÇä¾å¾ð...
¶ñÂÎŪ¤Ë¤ÏÀè¤ÎÎã¤Ë¤µ¤é¤Ë¤â¤¦°ì²ó join ¤ò¤¹¤ì¤ÐÎɤ¤¡¥
> ''SELECT␣*␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
> ''␣JOIN␣fruits␣ON␣sales.fruit_i...
<
¤¹¤ë¤È¡¢(²£¤ËŤ¤¤¬)¼¡¤Î¤è¤¦¤Ê½ÐÎϤòÆÀ¤ë¤Ï¤º¤À¡¥
id customer_id fruit_id quantity id ...
---- ------------- ------------- ------------- ----...
1 2 5 3 2 ...
2 1 1 1 1 ...
3 2 3 2 2 ...
4 2 1 4 2 ...
5 3 4 10 3 ...
&br;
¤ï¤«¤ê¤ä¤¹¤¯¤¹¤ë¤Ê¤é¤Ð¡¢¼¡¤Î¤è¤¦¤Ê´¶¤¸¤«¡¥
> ''SELECT␣sales.id, customers.name, fruits.name, p...
> ''␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
> ''␣JOIN␣fruits␣ON␣sales.fruit_i...
<
¤¹¤ë¤È¡¢¼¡¤Î¤è¤¦¤Êʬ¤«¤ê°×¤¤½ÐÎϤòÆÀ¤ë¤À¤í¤¦¡¥
id name name price quan
---- ------------- ------------- ------------- ----
1 tom orange 400 3
2 john banana 200 1
3 tom apple 300 2
4 tom banana 200 4
5 mike water melon 2000 10
¤³¤ì¤ò¤ß¤ì¤Ð¡¢Î㤨¤ÐÂè4²óÌܤμè°ú¤¤Ç¤Ï tom ¤¬200±ß¤Î¥Ð¥Ê...
&br;
&ref(/materials/warning.png); ¤³¤ó¤ÊÌÌÅݤʤ³¤È¤ò¤·¤Ê¤¤¤Ç...
¤·¤«¤·¤½¤ì¤ò¤ä¤ë¤È¡¢ÅÓÃæ¤Ç²¿¤«¤òÊѹ¹¤¹¤ë¤È²áµî¤Î¥Ç¡¼¥¿¤È...
¤¢¤ëÍó¤Ç¤Ï tom ¤È½ñ¤Â¾¤ÎÍó¤Ç¤Ï ton ¤ÈµºÜ¥ß¥¹¤¹¤ë¤ÈÊÌ¿Í...
¾¦ÉʾðÊó¤Ï¾¦Éʥơ¼¥Ö¥ëñÆȤǡ¢¸ÜµÒ¾ðÊó¤Ï¸ÜµÒ¥Æ¡¼¥Ö¥ëñÆÈ...
¾¤Î¥Æ¡¼¥Ö¥ë¤«¤é»²¾È¤Ç¤¤ë¡¢¤È¤¤¤¦¤Î¤¬ RDB ¤Î¥Ý¥¤¥ó¥È¤Ê¤Î...
¤³¤ì¤Ï¥Ç¡¼¥¿¤Î´ÉÍý¤Î¡Ö°ÂÁ´À¡×¤ò°ÕÌ£¤¹¤ë¡¥
¥Ç¡¼¥¿¤¬Â¿¤¯¡¢Ê£»¨¤Ë¤Ê¤ì¤Ð¤Ê¤ë¤Û¤É¤³¤Î¤³¤È¤Î½ÅÍ×À¤ÏÁý¤¹...
&br;
¤µ¤Æ¡¢¤µ¤é¤Ë¥Ç¡¼¥¿¤ò¸«¤ë¤À¤±¤Ç¤Ï¤Ê¤¯¤Æ¡¢¤¹¤³¤·²Ã¹©¤·¤Æ¤ß...
> ''SELECT␣sales.id, customers.name, fruits.name, p...
> ''␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
> ''␣JOIN␣fruits␣ON␣sales.fruit_i...
<
¤¹¤ë¤È¼¡¤Î¤è¤¦¤Ë¡¢Ã±²Áx¸Ä¿ô=¾®·× ¤â¥ê¥¹¥È¥¢¥Ã¥×¤Ç¤¤ë¡¥
id name name price quan...
---- ------------- ------------- ------------- ----...
1 tom orange 400 3 ...
2 john banana 200 1 ...
3 tom apple 300 2 ...
4 tom banana 200 4 ...
5 mike water melon 2000 10 ...
&br;
(±þÍÑ) ¤µ¤Æ¡¢¤µ¤é¤Ë¡¢Ã¯¤Ë¤¤¤¯¤éÀÁµá¤¹¤ë¤Ù¤¤«¤â¹ç·×¤ò¸«¤Æ...
¸ÜµÒ¾ðÊó¤ò¤â¤È¤Ë¤Þ¤È¤á¤ë¤ï¤±¤À¤¬¡¢¤³¤ì¤Ë¤Ï ''GROUP BY'' ...
¤Ê¤ª¡¢¹ç·×¤Ë¤Ïñ¤Ê¤ë ''SUM'' ¤È¤¤¤¦Ì¿Î᤬»È¤¨¤ë¡¥
> ''SELECT␣customers.name, &color(red){SUM(price*qu...
> ''␣FROM␣sales''
> ''␣JOIN␣customers␣ON␣sales.cust...
> ''␣JOIN␣fruits␣ON␣sales.fruit_i...
> ''␣&color(red){GROUP␣BY};␣customers.i...
<
¤¹¤ë¤È¡¢¼¡¤Î¤è¤¦¤Ê½ÐÎϤòÆÀ¤ë¤³¤È¤¬¤Ç¤¤ë¡¥
name sum(price*qua
---- -------------
john 200
tom 2600
mike 20000
¤³¤ì¤Ç¡¢¤À¤ì¤Ë¹ç·×¤Ç¤¤¤¯¤é»Ùʧ¤Ã¤Æ¤â¤é¤¨¤Ð¤è¤¤¤«¡¢°ìÌÜÎÆ...
&br;&br;
* ºÇ¸å¤Ë [#d2dd1cd3]
º£²ó¤Ï SQLite ¤ò¥³¥Þ¥ó¥É¥é¥¤¥ó¤«¤éľÀÜÁàºî¤·¤Æ RDBMS ¤ÎÆþ...
RDB ¤ò¼ÂÍѤ˶¡¤¹¤ë¾ì¹ç¤Ï¡¤¥é¥¤¥Ö¥é¥ê·Ðͳ¤«¥µ¡¼¥Ð·Ðͳ¤È¤Ê...
¤½¤¦¤¤¤Ã¤¿ºÝ¤Ë¤è¤¯¤ï¤«¤é¤Ê¤¯¤Ê¤Ã¤¿¤é¡¤º£²ó¤Î¤è¤¦¤ËľÀÜ¥³...
&br;&br;
* Report: ¥ì¥Ý¡¼¥È [#f50a4c0c]
°Ê²¼¤Î²ÝÂê¤Ë¤Ä¤¤¤Æǽ¤¦¸Â¤ê¸ÌÀ¤ÊÄ´ºº¤È¹Í»¡¤ò¹Ô¤¤¡¤
&br;
''AppliedMath7-Report-13''
&br;
¤È¤¤¤¦Âê̾¤ò¤Ä¤±¤Æ e-mail ¤Ë¤Æ¶µ´±°¸¤Ë¥ì¥Ý¡¼¥È¤È¤·¤ÆÄó½Ð...
** Exercises: ²ÝÂê [#of5ea7ec]
+ ¾å¤Î¼Â½¬¤ò³¤±¤Æ¡¢¤µ¤é¤Ë¡¢¤É¤Î¾¦Éʤ¬¹ç·×¤Ç¤¤¤¯¤ÄÇä¤ì¤¿...
&br;&br;
+ SQLite ¤Ç¡¢¥Õ¥¡¥¤¥ë¤«¤é¥Ç¡¼¥¿¤òÆɤ߹þ¤àÊýË¡¤òÄ´¤Ù¤è¡¥
&br;&br;
+ SQLite ¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò GUI ¤ÇÁàºî¤Ç¤¤ë¥¢¥×¥ê¥±¡¼¥·¥ç...
¤½¤¦¤¤¤Ã¤¿Êª¤òõ¤·¡¤¤½¤Î¤¦¤Á¤Î°ì¤Ä¤ÇÎɤ¤¤Î¤Ç¼ÂºÝ¤ËÁàºî¤·...
&br;&br;
+ ¼«Ê¬¤ÎÀ¸³è¤ÎÃæ¤Ç SQLite ¤òÍøÍѤ¹¤ë¤ÈÊØÍø¤Ë¤Ê¤ê¤½¤¦¤Ê¥·...
&br;&br;
* about Icons, ClipArts [#fc36f792]
For details, see [[&ref(/materials/JNorth_arrow-right-sm....
// ¨¬¨¨®¨¯¨°¨±¨²¨³¨´¨µ¨¶
// ¥³¥Þ¥ó¥É¥é¥¤¥óÆþÎϤϡֹÔƬ¤ò > ¤Ç»Ï¤á¤ë¡×.
// ¥³¥Þ¥ó¥É¥é¥¤¥ó½ÐÎϤϡֹÔƬ¤ò¥Ö¥é¥ó¥¯¤Ç»Ï¤á¤ë¡×.
// ¼Â½¬¥¢¥¤¥³¥ó
// &ref(/materials/notes.png);
// Ãí°Õ¥¢¥¤¥³¥ó
// &ref(/materials/warning.png);
// Link ¥¢¥¤¥³¥ó
// &ref(/materials/JNorth_arrow-right-sm.png);
// OK ¥¢¥¤¥³¥ó
// &ref(/materials/OK.png);
// NG ¥¢¥¤¥³¥ó
// &ref(/materials/NG.png);
// ¥µ¥ó¥×¥ë¥¢¥¤¥³¥ó
// &ref(/materials/Gnome-Preferences.png);
// Âçʸ»ú¤Ç¤Î¶¯Ä´
// CENTER:&size(24){''¤Û¤²¤Û¤²''};
// programu source ɽµ
// #highlighter(language=ruby,number=on,cache=on){{}}
// ¥Ñ¥¤¥×
// ¦
// ¶õÇòµ¹æ
// ␣
// ¥¿¥Öµ¹æ
// ␉
¥Ú¡¼¥¸Ì¾: