DB/SQL/¥¢¡¼¥¥Æ¥¯¥Á¥ã
¥Ç¡¼¥¿¥Ç¥£¥¯¥·¥ç¥Ê¥ê†
ɽ¤ÎÄêµÁÆâÍƤ¬³ÊǼ¤µ¤ì¤ë¡£create table ʸ¤ÎÁàºîÂоݡ£
create table ¤Ï¥Ç¡¼¥¿¥Ç¥£¥¯¥·¥ç¥Ê¥ê¤ËÄêµÁÆâÍƤò³ÊǼ¤·¤¿¤Î¤Á¡¢¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ËºîÀ®¤·¤¿É½¤Î¤¿¤á¤ÎÎΰè¤ò³ÎÊݤ¹¤ë¡£
drop table ʸ¤Ë¤è¤Ã¤Æ¡¢¥Ç¡¼¥¿¥Ç¥£¥¯¥·¥ç¥Ê¥ê¤ÎÅö³ºÎΰè¤È¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ÎÅö³ºÎΰ褬¥¯¥ê¥¢¤µ¤ì¤ë¡£
¥¡¼¥ï¡¼¥É†
- ¥Ç¡¼¥¿¥»¥°¥á¥ó¥È
- ¥¨¥¯¥¹¥Æ¥ó¥È
- Îΰè¤ò³ä¤êÅö¤Æ¤ëñ°Ì
- ¥Ç¡¼¥¿¥Ö¥í¥Ã¥¯
¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë†
ɽ¤Î¼ÂºÝ¤Î¥ì¥³¡¼¥É¤¬³ÊǼ¤µ¤ì¤ë¡£¥Ç¡¼¥¿¥Õ¥¡¥¤¥ëÆâ¤Ë create table ¤Ë¤è¤Ã¤ÆÎΰ褬³ÎÊݤµ¤ì¡¢insert ʸ¤Ë¤è¤Ã¤Æ¹¹¿·¤µ¤ì¤ë¡£
delete ʸ¤Ë¤è¤Ã¤Æ¥ì¥³¡¼¥É¤Ïºï½ü¤µ¤ì¤ë¤¬¡¢É½¤Î¤¿¤á¤ÎÎΰ褽¤Î¤â¤Î¤Ïºï½ü¤µ¤ì¤Ê¤¤¡£truncate ʸ¤Ï¡¢¥ì¥³¡¼¥É¤Îºï½ü¤À¤±¤Ç¤Ê¤¯Îΰ褽¤Î¤â¤Î¤Î²òÊü¤ò¹Ô¤¦¤³¤È¤â¤¢¤ë¡£
Æɤ߼è¤ê°ì´ÓÀ†
¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤¬Æó¤Ä¡¢¤Û¤ÜƱ»þ¤ËÁö¤Ã¤¿¤È¤¹¤ë¡£
Àè¤ËÁö¤Ã¤¿¥È¥é¥ó¥¶¥¯¥·¥ç¥ó A ¤¬¡¢¤¢¤ë¥ì¥³¡¼¥É¤ÎÃͤò 0 ¤«¤é 1 ¤ËÊѹ¹¤·¤¿¡£¥È¥é¥ó¥¶¥¯¥·¥ç¥ó A ¤Î¥³¥ß¥Ã¥ÈÁ°¤Ë¡¢¸å¤«¤éÁö¤Ã¤¿¥È¥é¥ó¥¶¥¯¥·¥ç¥ó B ¤¬Åö³º¥ì¥³¡¼¥É¤òÆɤ߹þ¤ó¤À¤È¤¡¢¥È¥é¥ó¥¶¥¯¥·¥ç¥ó B ¤Ï¡¢Êѹ¹Á°¤ÎÃÍ 0 ¤òÆÀ¤ë¡£
¥È¥é¥ó¥¶¥¯¥·¥ç¥ó³«»Ï»þÅÀ¤Ç¥³¥ß¥Ã¥È¤µ¤ì¤Æ¤¤¤Ê¤¤¹¹¿·¤Ï¡¢¤½¤Î¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤«¤é¤Ï¸«¤¨¤Ê¤¤¡£¤³¤ì¤òÆɤ߼è¤ê°ì´ÓÀ¤È¤¤¤¦¡£
¤³¤Î¤È¤¡¢¾å¤ÎÎã¤Ç¤¤¤¦ÃÍ 0 ¤òÊÝ»ý¤·¤Æ¤¤¤ë¾ì½ê¤¬¡¢¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ÎÃæ¤Î UNDO ¥»¥°¥á¥ó¥È¡£¥È¥é¥ó¥¶¥¯¥·¥ç¥ó B ¤Î³«»Ï»þ¤Ë UNDO ¥»¥°¥á¥ó¥È¤¬¥á¥â¥ê¤ËÆɤ߹þ¤Þ¤ì¡¢¥È¥é¥ó¥¶¥¯¥·¥ç¥ó B ¤Ï¤½¤³¤ò¿¨¤ë¡£
¥¡¼¥ï¡¼¥É†
- UNDO ¥»¥°¥á¥ó¥È
SQL ʸ¤Î½èÍý¤Î½ç½ø†
SQL ʸ¤òȯ¹Ô¤·¤¿¤È¤¡¢ÆâÉô½èÍý¤È¤·¤Æ¤É¤Î¤è¤¦¤Ê½ç½ø¤Ç½èÍý¤¬¹Ô¤ï¤ì¤Æ¤¤¤ë¤Î¤«¡¢¤È¤¤¤¦Ïá£
¤¶¤Ã¤¯¤ê¤È¤·¤¿½ç½ø†
- from ¶ç¤Ë¤è¤ëɽ¤ÎÁªÂò
- where ¶ç¤Ë¤è¤ë¹Ô¤ÎÀÚ¤ê½Ð¤·
- ÀÚ¤ê½Ð¤·¤·¤¿É½¤Ï¥á¥â¥ê¤ËŸ³«¤µ¤ì¤ë¡£¥á¥â¥ê¤ÎÀáÌó¤Ê¤É¤Ï where ¶ç¤«¤é¹Í¤¨¤ë
- group by ¶ç¤Ë¤è¤ë¥°¥ë¡¼¥×²½
- having ¶ç¤Ë¤è¤ë¹Ô¤ÎÀÚ¤ê½Ð¤·
- order by ¶ç¤Î¥½¡¼¥È
¥ª¡¼¥È¥È¥ì¡¼¥¹†
ÆâÉô¤Ç¤Î SQL ʸ¤Î²ò¼á¡¢¼Â¹Ô·×²è¡¢Åý·×¾ðÊó¤ò»²¾È¤Ç¤¤ë¡£
- ÊýË¡
-- ¥È¥ì¡¼¥¹¤Î³«»Ï set autotrace traceonly -- ¥È¥ì¡¼¥¹¤Î½ªÎ» set autotrace off
- ÆâÍÆ¡ÊÎã¡Ë
- index unique scan | hoge_pk
- ¥×¥é¥¤¥Þ¥ê¥¥£¡Êunique¡Ë¤Îº÷°ú¡Êindex¡Ë¤Î¥¹¥¥ã¥ó¡£¥×¥é¥¤¥Þ¥ê¥¥£¤ÎÀ©Ìó̾¤âÎóµó¤µ¤ì¤ë¡£
- consistents gets
- ¥á¥â¥ê¤«¤éÆɤ߹þ¤ó¤À¥Ð¥Ã¥Õ¥¡¡Ê8KB/buffer¡Ë¤Î¿ô¡£Æ±¤¸·ë²Ì¤¬ÆÀ¤é¤ì¤ë¤Î¤Ç¤¢¤ì¤Ð¤³¤ì¤¬¾¯¤Ê¤¤¡Ê¡á¥ê¥½¡¼¥¹»ÈÍÑÎ̤¬¾¯¤Ê¤¤¡Ë¤Û¤¦¤¬Îɤ¤¡£º÷°ú¤ÎÉÕ¤±Êý¤Ê¤É¤Î¹©ÉפâɬÍ×
- index unique scan | hoge_pk
Last-modified: 2011-10-17 (·î) 12:33:25