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

mysql:13653

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

£²ÅÙ¤¦¤Á¤¹¤¤¤Þ¤»¤ó¡¢¡¢¡¢

²èÌ̤«¤¿¤Þ¤Ã¤Æ¤·¤Þ¤Ã¤¿¤Î¤ÇÁ÷¿®¥Ü¥¿¥óÏ¢ÂǤ·¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡¢¡¢¡¢¡¢
¤¹¤¤¤Þ¤»¤ó¡¢¡¢

--- akio_takahashi <aaakiotakahasi@xxxxxxxxxx> wrote:

> ÊÖ¿®¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
> 
> ³Î¤«¤Ë¤³¤ì¤À¤±¤Ç¤Ï¼ÂºÝ¤Ë¤ß¤Ê¤¤¤Èʬ¤«¤é¤Ê¤¤¤Ç¤¹¤è¤Í¡£
> ¤¹¤¤¤Þ¤»¤ó¡¢¡¢¡¢
> 
> ²ò·è¡Ê̵Íý¤ä¤ê·èÃå¤Ä¤±¤Þ¤·¤¿¡Ë¡©¤·¤¿¤Î¤Ç¤´Ï¢Íí¤·¤Þ¤¹¡£
> 
> 
> ¤½¤ÎÁ°¤ËÆó¤Ä¤¤¤¤¤â¤ì¤Æ¤¿¤Î¤Ç¤¹¤¬¡©¡¢
> ­¡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/
> 
> 


--------------------------------------
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]