SAK }‘ŠÙ

SAK Streets ƒƒCƒ“ƒXƒgƒŠ[ƒg }‘ŠÙEƒJƒtƒF ˆê—— SAK Streets ŒŸõ
| VB | SQL | Perl | PHP | ASP | JSP | C | PC | HP | FAQ | ƒtƒŠ[ƒ\ƒtƒg |

SQL Šî‘b•Ò - y•â‘«z•¡‡ƒL[ alter tableAprimary key

’Pˆê‚ÌŽåƒL[‚́A

  y—ázcreate table sak.•i”Ôm (
          •i”Ô             varchar2(018)     primary key,
          “üŒÉ”           number  (009, 0),
          oŒÉ”           number  (009, 0),
          Žó’”           number  (009, 0),
          XV’S“–ŽÒ       char    (005),
          XV“ú•t         char    (008),
          XVŽžŠÔ         char    (006)
        )

‚Ì primary key ’è‹`ì‚ç‚êAƒVƒXƒeƒ€‚ªŽåƒL[AˆêˆÓƒL[‚ɑ΂µ‚čõˆø‚ðŽ©“®
‚Å‘n¬‚µ‚Ü‚·B

•¡‡ŽåƒL[‚ɂ‚¢‚ẮA

  y—ázalter table sak.‚È‚ñ‚¿‚á‚çm add primary key (
          ŽåƒL[€–Ú1,
          ŽåƒL[€–Ú2,
          ŽåƒL[€–Ú3
        )

‚Ì—l‚ɁAalter table ƒRƒ}ƒ“ƒh‚ŁAÅ‘å 16 €–Ú‚Ì•¡‡Žw’è‚ð‚·‚éB

** Oracle ‚́AŠî–{“I‚É create index ƒRƒ}ƒ“ƒh‚ɂāAõˆø‚ð“ÆŽ©‚ɍì‚é•K—v‚Í
   ‚È‚¢Bprimary key ‚Æ“¯“™‚̍õˆø‚ðì‚Á‚½ê‡AƒVƒXƒeƒ€‚ÌŽ©“®‘n¬•ª‚Æ“ñ
   d‚É‚È‚é‚Ì‚Å’ˆÓ‚·‚éB

¡SQL Šî‘b•ÒŽ‘—¿
¡SQL Šî‘bŽÀ’n•ÒŽ‘—¿
¡SQL ƒ`ƒ…[ƒjƒ“ƒO•ÒŽ‘—¿
¡Oracle PL/SQL •ÒŽ‘—¿
¡PostgreSQL •ÒAJAVA ServletAJSP •ÒŽ‘—¿
¡MySQL •ÒŽ‘—¿
| VB | SQL | Perl | PHP | ASP | JSP | C | PC | HP | FAQ | ƒtƒŠ[ƒ\ƒtƒg |

SAK Streets ƒƒCƒ“ƒXƒgƒŠ[ƒg }‘ŠÙEƒJƒtƒF ˆê—— SAK Streets ŒŸõ



Copyright (C) 1999-2017 Y.SAK