是这个意思吗?用php控制。$result=mysql_query("select * from t1"); //t1为测试表,下同。 $num=mysql_num_rows($result); $result1=mysql_query("select MIN(id) as min from t1"); $row=mysql_fetch_assoc($result1); while($num>100){ mysql_query("delete from t1 where id='$row[min]'"); $num--; $result1=mysql_query("select MIN(id) as min from t1"); $row=mysql_fetch_assoc($result1); }
$num=mysql_num_rows($result);
$result1=mysql_query("select MIN(id) as min from t1");
$row=mysql_fetch_assoc($result1);
while($num>100){
mysql_query("delete from t1 where id='$row[min]'");
$num--;
$result1=mysql_query("select MIN(id) as min from t1");
$row=mysql_fetch_assoc($result1);
}