$sql = "select id from store_massage where to_days(now())-to_days(date)>1"
$result = Mysql_query( $sql );
while ($rows = @Mysql_fetch_array ( $result ) ) {
$delete1 = Mysql_query ("Delete From store_massage Where id = '$rows[id]'");
$delete2 = Mysql_query ("Delete From restore Where id = '$rows[id]'");}
$result = Mysql_query( $sql );
while ($rows = @Mysql_fetch_array ( $result ) ) {
$delete1 = Mysql_query ("Delete From store_massage Where id = '$rows[id]'");
$delete2 = Mysql_query ("Delete From restore Where id = '$rows[id]'");}
$sql = "select id from store_massage where to_days(now())-to_days(date)>1"
$result = Mysql_query( $sql );
$Str="";
while ($rows = @Mysql_fetch_array ( $result ) )
$Str .="id = '$rows[id]' or ";
$delete1 = Mysql_query ("Delete From store_massage Where ".$Str." 0;");
$delete1 = Mysql_query ("Delete From restore Where ".$Str." 0;");
1,5,9,8,12,66
然后拼成这样一句sql语句
if($delids!='')
{
$sql='delete from restore where id in ('.$delids.')';
mysql_query($sql);
}
这样做的结果就是节省了几乎二分之一的向mysql提交命令的时间。
事实上,在删除主表记录时最好也采用这种方式,先把满足条件的id累积起来,一次性用in操作符执行删除,而不是检索到一条删一条,这样毫无效率而言的