mysql:13652
From: akio_takahashi <akio_takahashi <aaakiotakahasi@xxxxxxxxxx>>
Date: Fri, 29 Dec 2006 18:19:03 +0900 (JST)
Subject: [mysql 13652] 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]