$B3yBl$G$9!#(B
(B
$B%F!<%V%kL>$NJQ99$H$+!"%U%#!<%k%IL>$NJQ99$J$I$O!";~$K$7$F%G!<%?$N>C<:$H(B
$B$$$&;v8N$K$D$J$,$k62$l$,$"$j$^$9!#$G$-$l$P!"%F!<%V%k$O%3%T!<$7$F$+$i!"(B
$BF0:n$r3NG'$N>e%*%j%8%J%k$r:o=|$7!"$5$i$K%*%j%8%J%kL>$GJ]B8$9$k$N$,!"%Y(B
$B%?!<$G$9!#$b$A$m$s!"$3$l$,M}M3$G$O$"$j$^$;$s$M!#(B:-p
(B
(BAt Mon, 13 Jun 2005 12:02:38 +0900,
(BTakamichi Akiyama wrote:
(B>
(B> $BB3$-$^$7$F!"(B
(B> $B3yBl$5$s!"%G!<%?%Y!<%9$r$4B8CN$NJ}!"!"!"(B
(B>
(B> $B$3$l$O4{CN$NIT6q9g$G$9$h$M!#$?$V$s!"!"!"(B
(B> $B$=$7$F@)8B;v9`$J$N$G$7$g$&$+!)(B
(B
$B$?$V$sFbItE*$K;H$o$l$F$$$k%3%^%s%I$,!V([EMAIL PROTECTED]&!#O@ $B%G!<%?%Y!<%9(B
(B> $B$N!V?75,%G!<%?%Y!<%9$N:[EMAIL PROTECTED](B)$B$K$*$$$F!"(B
(B>
(B> 1. $B%F!<%V%k(B $B$rA*Br$7$F!"I=<($5$l$?%F!<%V%kL>$r1&%/%j%C%/$7$F!"(B
(B> $B!!(B
(B> $B!VL>A0$rJQ99!W$r;H$C$F!"%F!<%V%kL>$rJQ99$7$h$&$H;n$_$k$H!"%(%i!e5-$NM}M3$K$h$j%j%M!<%`$G$-$^$7$?!#(B
(B
(B> 2. $B%D!<%k(B > SQL $B$G(B
(B> rename table "$B=;=j(B" to "$B=;=j%F!<%V%k(B" $B$H%?%$%W$7!"(B
(B> $BJT=8(B > $B%/%(%j!<$Ne5-$rN"IU$1$F$^$9!#(B
(B
(B> 3. $BBe$o$j$K!"(B
(B> ALTER TABLE "$B=;=j(B" RENAME TO "$B=;=j%F!<%W%k(B"
(B> $B$H$9$k$H!"@.8y!#(B
(B>
(B> 4. $B$A$J$_$K!"(BAddresses $B$H$$$&L>>N$N%F!<%V%k$,$"$k$H$9$k$H!"(B
(B> ALTER TABLE "Addresses" RENAME TO "AddressTable" $B$H$9$k$H!"%(%i!$r(B TABLE1 $B$H$$$&$U$&$JH>3QBgJ8;z$G:[EMAIL
(B> PROTECTED]"(B
(B> ALTER TABLE TABLE1 RENAME TO TABLE2 $B$H$9$k$H!"@.8y!#(B
(B> Command successfully executed.
(B>
(B> 6. $B$7$+$7!"0lC6JD$8$F!":FEY%U%!%$%k$r3+$+$J$$$H!"%F!<%V%kL>$NJQ99$O(B
(B> $BH?1G$5$l$J$$$h$&$G$9!#(B
(B
(BMySQL$B$N>l9g$O!"%j%M!<%`8eI=<($5$l$^$7$?!#%3%^%s%I$,0c$&$;$$$+$b$7$l$^$;$s!#(B
(B
(B> 7. $B$G!"3+$-D>$7$F!"F1MM$K$7$F!"(BSQL$B%3%^%s%I$GD>@\!"(B
(B> ALTER TABLE TABLE2 RENAME TO table3 $B$H$9$k$H!"@.8y!#(B
(B>
(B> 8. $B$$$C$?$sJD$8$F!":FEY3+$/$H!"%F!<%V%kL>$O(B TABLE3
(B> $B$H$$$&BgJ8;z$K$J$C$F$$$k!#(B
(B>
(B>
(B>
(B> $B$I$&$7$?$b$N$G$7$g$&$+!#(B
(B
$B$H$j$"$($:$O!"%j%M!<%`$N
