Re: Timing in mysql using php

[Kai Voigt]

Hello.

MySQL cannot do the resetting of table data periodicly. Maybe, we'll get advanced triggers in the future, but for now, you need some external program to perform this task.

Write some PHP/Perl/etc script that sets the column to zero and have this script run periodically by your operating system. Use cron on UNIX or some time scheduling on Windows.

MySQL is not filling gaps when it comes to auto_increment fields. This is actually a feature as you are ensured to have unique values, even if old values are deleted.

You can of course truncate the entire table. This will remove all the table's content and the auto_increment will start at 1 again.

Kai