¤³¤ó¤Ë¤Á¤Ï¡£¤Û¤ª¤¯¤È¤¤¤¤¤Þ¤¹¡£

º£
¥ì¥³¡¼¥É¿ô¤ò¼«Æ°Åª¤ËÄ´À°¤¹¤ë¤¿¤á¤Ë¡¢¤³¤ÎÎã¤Ç¤Ï¡¢10°Ê¾å¤Î¥ì¥³¡¼¥É¤¬¤¢¤ë¤È¡¢
¸Å¤¤Êý¤«¤é¥ì¥³¡¼¥É¤ò¾Ã¤·¡¢10¤Ä¤Î¥ì¥³¡¼¥É¤Ë¤Ê¤ë¤è¤¦¤ËÄ´À°¤¹¤ë¤è¤¦¤Êʸ¤òºî¤Ã
¤Æ¤¤¤Þ¤¹¡£

delete from table where column <= (select max(column) from table) -10

¤È¸À¤¦¤è¤¦¤Ê´¶¤¸¤Î¤ò¤ä¤Ã¤Æ¤ß¤¿¤Î¤Ç¤¹¤¬¡¢¤¦¤Þ¤¯¤¤¤­¤Þ¤»¤ó¡£(¼ÂºÝ¥Æ¥¹¥È¤Ï
select¤Ç¤ä¤Ã¤Æ¤¤¤Þ¤¹)
mySQL¤Ç¤Ï¡¢Ê¡¼¡Ì䤤¹ç¤ï¤»¤È¸À¤¦¤è¤¦¤Ê¤³¤È¤Ï½ÐÍè¤Ê¤¤¤Î¤Ç¤·¤ç¤¦¤«¡©

½ÐÍè¤Ê¤±¤ì¤Ð¡¢¤³¤ì¤ÈƱ¤¸Æ°ºî¤¹¤ëʸ¤Ï¤¢¤ê¤Þ¤»¤ó¤Ç¤·¤ç¤¦¤«¡£

ÃΤäƤ¤¤ëÊý¤¤¤Þ¤·¤¿¤é¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹£í¡Ê¡²¡¡¡²¡Ë£í

---------------------------------------
Hirotaka Kondo ¶áÆ£¿Òδ  IRC:#!Silver-Forest
hiro@xxxxxxxxxx UIN:10034131
http://www.silver-forest.com/