Splitting Big mysql queries in PHP
Copy this code and paste it in your HTML
while (1) {
mysql_query("DELETE FROM logs WHERE log_date <= '2009-10-01' LIMIT 10000");
if (mysql_affected_rows
() == 0) { // done deleting
break;
}
// you can even pause a
bit usleep(50000);
}
Report this snippet
Comments
Subscribe to comments