[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:13651

From: akio_takahashi <akio_takahashi <aaakiotakahasi@xxxxxxxxxx>>
Date: Fri, 29 Dec 2006 18:19:03 +0900 (JST)
Subject: [mysql 13651] Re: ¥Æ¡¼¥Ö¥ë¤Î auto_increment ¤òÊÌ¥Õ¥£¡¼¥ë¥É¤Ë primarykey ¤ò»ÈÍѤ»¤º¤Ë #delete ¤ÎÃͤòɽ¼¨¤·¤Ê¤¤ÊýË¡

ÊÖ¿®¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£

³Î¤«¤Ë¤³¤ì¤À¤±¤Ç¤Ï¼ÂºÝ¤Ë¤ß¤Ê¤¤¤Èʬ¤«¤é¤Ê¤¤¤Ç¤¹¤è¤Í¡£
¤¹¤¤¤Þ¤»¤ó¡¢¡¢¡¢

²ò·è¡Ê̵Íý¤ä¤ê·èÃå¤Ä¤±¤Þ¤·¤¿¡Ë¡©¤·¤¿¤Î¤Ç¤´Ï¢Íí¤·¤Þ¤¹¡£


¤½¤ÎÁ°¤ËÆó¤Ä¤¤¤¤¤â¤ì¤Æ¤¿¤Î¤Ç¤¹¤¬¡©¡¢
­¡auto_increment¤ò¤Ä¤±¤¿¥Õ¥£¡¼¥ë¥É¤ÏACCESS¤Ç¥ê¥ó¥¯¤·¤¿¾ì¹ç¡¢¼±ÊÌ¥­¡¼¤ò
¡¡ÀßÄꤹ¤ë¤è¤¦¤Ë¥á¥Ã¥»¡¼¥¸¤¬¤Ç¤Þ¤·¤¿¡£¤Ê¤Î¤Ç¡¢Index Key¤À¤±¤òÀßÄꤷ¤¿
¡¡auto_increment¤Î¥Õ¥£¡¼¥ë¥É¤Ë¼±ÊÌ¥­¡¼¤ò¤Ä¤±¤Þ¤·¤¿¡£
­¢#deleted#¤¬¤Ä¤¤¤¿¤Î¤Ï¥ì¥³¡¼¥Éñ°Ì¤Ç¤¢¤¯¤Þ¤Ç¥¢¥¯¥»¥¹¤«¤é¤Îɽ¼¨¤Ç¡¢
¡¡¼ÂºÝ¤Ë¤Ï¤­¤Á¤ó¤È¥ì¥³¡¼¥É¤ËÊݸ¤µ¤ì¤Þ¤¹¡£¥¢¥¯¥»¥¹¤Ç¤â°ìÅÙ¡¢#deleted#
¡¡¤Èɽ¼¨¤µ¤ì¤Þ¤¹¤¬¡¢³«¤­¤Ê¤ª¤¹¤È¤­¤Á¤ó¤ÈÊݸ¤µ¤ì¤Þ¤¹¡£
¡¡
¹­ÄŤµ¤ó¤Ø¤Î¤´²óÅú¤Ç¤¹¤¬¡¢Primary Key ¤òÀßÄê¤À¤±¤òauto_increment¤Î
¤Ä¤¤¤¿¥Õ¥£¡¼¥ë¥É¤Ë¤Ä¤±¤Þ¤·¤¿¤¬¤ä¤Ï¤ê¡¢Æ±¤¸¸½¾Ý¤Ë¤Ê¤ê¤Þ¤·¤¿¡£

¤½¤³¤Ç¤â¤Ã¤ÈÄ´ºº¤¹¤ì¤Ð¡¢²ò·è¤Ç¤­¤ë¤«¤È»×¤¤¤Þ¤·¤¿¤¬»Å»ö¼ý¤á¤Ç»þ´Ö¤¬
¤Ê¤«¤Ã¤¿¤Î¤Ç¾¡¼ê¤Ë¾å»Ê¤Ë²¾Äê¤ÎÀâÌÀ¤ò¤·¤Þ¤·¤¿¡Ê±³¤Î²ÄǽÀ­¤¬¤â¤Ã¤È¤â
¹â¤¤¤Ç¤¹¡¢¡¢¡¢¡Ë

¥¢¥¯¥»¥¹¤ÇMysql¤ò¥ê¥ó¥¯¤·¤¿»þ¤Ë¤Ê¤¼¡¢auto_increment¤ò¤Ä¤±¤¿¥Õ¥£¡¼¥ë¥É
¤òÆþÎϤ»¤º¤Ë¥ì¥³¡¼¥ÉÆþÎϤ·¡¢ENTER¥­¡¼¤ò²¡¤·¤Æ¡¢¼¡¥ì¥³¡¼¥É¤Ø¿Ê¤â¤¦¤È
¤·¤¿¾ì¹ç¡¢¥ì¥³¡¼¥Éñ°Ì¤Ç#delete#¤¬É½¼¨¤µ¤ì¤ë¤Î¤«¡©
ñ½ã¤Ëauto_increment¤Î¥Õ¥£¡¼¥ë¥É¤¬NOT¡¡NULL¤Î¥Á¥§¥Ã¥¯¤¬Àè¤Ë¤«¤«¤ê¡¢
#deleted#¤¬É½¼¨¤µ¤ì¡¢¤Ç¤¹¤¬¼«Æ°ºÎÈÖ¤µ¤ì¤¿»ö¤Ë¤è¤Ã¤Æ¡¢#delete#¤Î
ÆâÍƤÏÆâÉô¤ÇÊݸ¤µ¤ì¤Æ¤·¤Þ¤Ã¤¿¤ÈÀâÌÀ¤·¤Þ¤·¤¿¡£

·ëÏÀ¤Ç¤¹¤¬¡¢#delete#¤¬É½¼¨¤µ¤ì¤ë¸½¾Ý¤Ï¡¢ÅÐÏ¿¤Î¤ßȯÀ¸¤¹¤ë¤Î¤Ç
´û¤Ë¥Ç¡¼¥¿¤¬ºîÀ®¤µ¤ì¤¿¥Þ¥¹¥¿¡¼¤Ë»È¤¦¤Î¤Ç»Ù¾ã¤¬¤Ê¤¤¤È¤¤¤¦»ö¤Ç
·èÃå¤Ä¤­¤Þ¤·¤¿¡£

Ĺ¡¹½ñ¤­¤Þ¤·¤¿¤¬¡¢¤³¤ó¤Ê´¶¤¸¤Ç¤¹¡¢¡¢¡¢


--- "T.Hirotsu" <hirotsu@xxxxxxxxxx> wrote:

> ¤³¤ó¤Ë¤Á¤Ï¡¢¹­ÄŤǤ¹¡£
> 
> Access ¤«¤é¥ê¥ó¥¯¤Ç»²¾È¤¹¤ë¤È¡¢Index Key ¤À¤±¤Ç¡¢Primary Key ¤òÀßÄꤷ¤Æ¤¤¤Ê¤¤
> ¥Æ¡¼¥Ö¥ë¤Î¾ì¹ç¡¢Access ¾å¤Ç¤Î¥Õ¥£¡¼¥ë¥ÉÃͤÎɽ¼¨¤¬ #deleted# ¤Ë¤Ê¤ë¤³¤È¤¬¤¢¤ê¤Þ¤¹¡£
> 
> > ¡ÊÍýÁۤȤ·¤Æ¤Ï¡¢auto_increment¤Ë
> > primarykey¤ò¤Ä¤±¤ë¤À¤±¤Ç¤¤¤¤¤Ç¤¹¡£¡Ë
> 
> ¶Ä¤Ã¤Æ¤¤¤ë¤³¤È¤¬Îɤ¯Íý²ò¤Ç¤­¤Þ¤»¤ó¤¬¡¢¤Ç¤·¤¿¤éÁÇľ¤Ë auto_increment ¤Î
> ¥«¥é¥à¤ò Primary Key ¤Ë¤¹¤ì¤Ðµ¹¤·¤¤¤Î¤Ç¤Ï¡©¡©¡©
> 
> 
> 


--------------------------------------
Yahoo! JAPAN Search Word Ranking 2006
http://pr.mail.yahoo.co.jp/search/

[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

     13633 2006-12-28 12:47 [akio_takahashi <aaak] ¥Æ¡¼¥Ö¥ë¤Î auto_increment ¤òÊÌ¥Õ¥£¡¼¥ë¥É¤Ë primarykey ¤ò»ÈÍѤ»¤º¤Ë #delete ¤ÎÃͤòɽ¼¨¤·¤Ê¤¤ÊýË¡
     13635 2006-12-28 14:14 ¨±["T.Hirotsu" <hirotsu]                                       
->   13651 2006-12-29 18:19 ¡¡¨²[akio_takahashi <aaak]                                     
     13652 2006-12-29 18:19 ¡¡¨±[akio_takahashi <aaak]                                     
     13653 2006-12-29 19:36 ¡¡¡¡¨²[akio_takahashi <aaak]                                   
     13654 2006-12-29 19:47 ¡¡¡¡¨±["T.Hirotsu" <hirotsu]                                   
     13655 2006-12-29 21:08 ¡¡¡¡¡¡¨±[akio_takahashi <aaak]