※ 引述《roga (凝視)》之銘言：
解出來了，結果還是得用 PHP 來幫忙一下..
$sql = "SELECT `url_id`, count( url_id ) FROM `url_detail_history` GROUP BY `url_id` HAVING count(id) > 1499;";
$result = mysql_query($sql);
$i = 0;
while (list($url_id, $count) = mysql_fetch_row($result) )
{
echo "id = $url_id and, count =$count <br />";
/* 掃描資料表，先反向排序，再用 LIMIT 來取得第 1500 筆資料，這筆資料的 ID 就是臨界值 - 重點 - */
$sql2 = "SELECT `id` FROM `url_detail_history` WHERE `url_id` = $url_id ORDER BY `id` DESC LIMIT 1499,1500";
$result2 = mysql_query($sql2);
$row = mysql_fetch_Array($result2);
$critical = $row['id'];
echo "critical: $critical";
/* 比臨界值小的都刪掉 */
$sql3 = "DELETE FROM `url_detail_history` WHERE `url_id` = $url_id and `id` < $critical";
mysql_query($sql3);
echo "<br />";
$i++;
}
echo "<hr /> total = $i;"
@see: http://blog.roga.tw/2009/06/09/2220
謝謝樓上的 bobju 和另一位 java 朋友 ^^
--
凝視著，卻看不見光景。
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.130.223.205
※ 編輯: roga 來自: 220.130.223.205 (06/09 15:45)
※ 編輯: roga 來自: 220.130.223.205 (06/09 15:46)