reseting mysql max value

[Anon]

Hi!

Does anybody knows how can I check whether the max value in some field has been reached?
For example, I have MEDIUMINT column and I want to reset its value once it reaches its maximum, that is 8388607.
(Actually, looking for the most simplest way.)

Bye!

[[deleted]]

How about

SELECT MAX(field) FROM table;

and checking the returned value?

Note: you say you want to reset it, I hope you are not talking about an auto_increment column?

[Anon]

Hmm...

Here's the thing: I have a table that is being updated by the users. So, eventually, the field that counts will get filled. When that happens, I need to reset highest ten entries to a starting values and delete all the rest. Here's the current solution, but I'm not pleased with it, I'm looking for something better:

$max = mysql_query("SELECT rid FROM hit_count WHERE hitCount ='$mediumint_max'");
@$has_max = mysql_num_rows($max);
if ($has_max > 0) {
	 $first_10 = mysql_query("SELECT rid,nazivRecepta FROM hit_count ORDER BY hitCount DESC LIMIT 0,10");
	 mysql_query("DELETE FROM hit_count");
	 while (list($rid2,$rec2) = mysql_fetch_row($first_10)) {
	 	  mysql_query("INSERT INTO hit_count (rid, nazivRecepta, hitCount) VALUES ( '$rid2', '$rec2', '1')");
	 }
}

Sorry, long letter...
Bye

[[deleted]]

So you do have an auto_increment column?

Why do you want to to delete the rows, and why do you feel you must reset the counter value?

[Anon]

No, it's not an auto_increment column (sorry, forgot to mention in the last message, e.g. @!#$ happens).

It is for "top ten". The firt displayed database entry is the one with the highest value. So, the problem is that "top ten" algorithm wouldn't work once the hitCount field reached max value, that is 8688607 (for MEDIUMINT).

Is there a better way to solve this metter except in the way I did in last message?

Huh... long letter again...
Bye!

[[deleted]]

Why can't you just reset all the hitcounters to zero witheout deleting the records?