Advanced Search

Return to Snippet

Revision: 24235
at February 24, 2010 06:10 by level09
Initial Code 
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);
}
Initial URL 









Initial Description














Initial Title





Splitting Big mysql queries in PHP









Initial Tags














Initial Language





MySQL