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

mysql:1921

From: "Y. Tsutsui" <"Y. Tsutsui" <tutui@xxxxxxxxxx>>
Date: Thu, 20 Apr 2000 20:50:16 +0900
Subject: [mysql 01921] Re: select ʣʸ

Äé°æ¤Ç¤¹¡£
At 2000/04/20 20:47:04 ¤È¤ß¤¿¤Þ¤µ¤Ò¤í wrote:

> SQL °Ê³°¤Î¸À¸ì¤ò²ðºß¤µ¤»¤¿¤¯¤Ê¤¤¤Î¤Ê¤é¡¢3.23.x ¤Î¿·¤·¤¤¤Î¤·¤«¥À¥á¤Ç¤¹¤¬¡¢
> ¥æ¡¼¥¶ÊÑ¿ô¤ò»È¤Ã¤Æ¡¢¼¡¤Î¤è¤¦¤Ê´¶¤¸¤Ç¤É¤¦¤Ç¤·¤ç¤¦¡© Ì¿Îá¤ò2²óȯ¹Ô¤·¤Æ¤·¤Þ
> ¤¤¤Þ¤¹¤¬¡Ä¡£
> 	select @c:=max(column) from table;
> 	delete from table where column <= @c - 10;

sub-select¤Î¼ÂÁõ¤À¤±¤Þ¤À¤«¤Þ¤À¤«¤ÈÂԤäƤ¤¤¿¤ó¤Ç¤¹¤¬¡¢
¤¤¤Ä¤Î¤Þ¤Ë¤«¤³¤ó¤ÊÁÇŨ¤Ê¤â¤Î¤âÆþ¤Ã¤¿¤ó¤Ç¤¹¤Í¡£»È¤¨¤½¤¦¤Ç¤¹¡£

¥×¥ì¥Ã¥¯¸¦µæ½ê¥·¥¹¥Æ¥à³«È¯¼¼¡¡Äé°æÂÙ»Ö
tutui@xxxxxxxxxx

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

      1918 2000-04-20 19:21 [Hirotaka Kondo ¶áÆ£¿] select ʣʸ                             
      1920 2000-04-20 20:47 ¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm]                                       
->    1921 2000-04-20 20:50 ¡¡¨²["Y. Tsutsui" <tutui@]                                     
      1925 2000-04-21 21:13 ¡¡¨­¨±[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm]                                   
      1923 2000-04-21 10:43 ¡¡¨±[Hirotaka Kondo ¶áÆ£¿]