Page 1 of 1
How to use trigger to record every moment in database
Posted: Tue Jul 05, 2011 2:34 am
by kalaithamil
hai.
I want to store every min in data base using trigger concept ,any one can help me to solve this problem.
Re: How to use trigger to record every moment in database
Posted: Tue Jul 05, 2011 10:49 am
by Jonah Bron
You want to set up a script to regularly call your (assumingly) PHP code at the interval you wish (in this case 1 minute) with either a Cron job or Windows Task Scheduler, depending on your server platform (Linux and Windows respectively). Do you already have your PHP code working?
Re: How to use trigger to record every moment in database
Posted: Tue Jul 05, 2011 12:04 pm
by alex.barylski
Google MySQL trigger's - there are enough basic introductory articles to guide you through the process - it's not rocket science.
Cheers,
Alex
Re: How to use events to record every moment in database
Posted: Wed Jul 06, 2011 12:10 am
by kalaithamil
hai.......
create event eventname
on schedule every 5 second
do
insert into tablename (time) values(now());
this concept is not working for me
show events display originator :1 how to rectifiy this problem
Re: How to use trigger to record every moment in database
Posted: Wed Jul 06, 2011 8:35 am
by mikosiko
this concept is not working for me
WHY?.... error message?... events are activated?
you need to provide much more and precise information to get help.... magic crystal ball doesn't work for us