resetting stats

[ldoozer]

I have a database with lots of tables and many tables have a field called requests which hold how many times a page for instance has been requested.

 

Here the thing - now that the website has been tested, i want to reset all the stats to 0.

Can i do this in one sql statement?

[cooldude832]

why would you have so many tables with respect to a single data type (number of page request?)

 

 

Should be a single table and then you could easily just write.

 

 

<?php
$q = "Update `Reqest_Count_table` Set Hit_Count = '0'";
$r = mysql_query($q) or die(mysql_error()."<br /><br />".$q);
?>

 

That would update all counts to 0 in that table

[ldoozer]

Thanks for the reply. not sure why that is the case - i did not create the db, I'm just a project manager trying to get by

Is it not possible to update all at once?

[cooldude832]

if the field name is consitent across the database say

<?php
$tables = array("table1", "Table2");
$update_field = "Hit_Cont";
foreach($tables as $value){
$q = "Update `".$value."` Set ".$update_field."='0'";
$r = mysql_query($q) or die(mysql_error()."<br /><br />".$q);
}
?>

 

 

Should work.

[ldoozer]

thinking about it - the tables that have this field are separated in to blogs, forum topics, news, pages, products. So might be in different tables for different areas of the site?

[cooldude832]

it would be smarter to categorize the pages in a single page with another field.

[ldoozer]

Thank you will try that php script now, and will backup the db first

[tgavin]

If the columns have a default value of 0, couldn't you just use

$sql = mysql_query("TRUNCATE TABLE table_name");

[ldoozer]

just realised that I dont have the class that connects to the db. need to do this:

$update_field = "Hit_Cont";
foreach($tables as $value){
$q = "Update `".$value."` Set ".$update_field."='0'";
$r = mysql_query($q) or die(mysql_error()."<br /><br />".$q);
}
?>

but in sql?

[cooldude832]

If the columns have a default value of 0, couldn't you just use

$sql = mysql_query("TRUNCATE TABLE table_name");

 

 

 

No!

 

Truncate will empty all records out of a table

[tgavin]

If the columns have a default value of 0, couldn't you just use

$sql = mysql_query("TRUNCATE TABLE table_name");

 

 

 

No!

 

Truncate will empty all records out of a table

 

Right. he said he wanted to reset all to zero. I take that as meaning 'starting from scratch'. If each column has a default value of 0, then he will achieve his goal. Otherwise, why reset to zero?