How can i insert timer in mysql database such as it update certain table after 1 hour?
AFAIK there is no sort of scheduling system built into MySQL. You'll have to use CRON jobs or an equivalent system. What server-side language are you using?
im using php as a server side language