hai.
I want to store every min in data base using trigger concept ,any one can help me to solve this problem.
How to use trigger to record every moment in database
Moderator: General Moderators
-
kalaithamil
- Forum Newbie
- Posts: 3
- Joined: Fri Jul 01, 2011 4:04 am
- Jonah Bron
- DevNet Master
- Posts: 2764
- Joined: Thu Mar 15, 2007 6:28 pm
- Location: Redding, California
Re: How to use trigger to record every moment in database
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?
-
alex.barylski
- DevNet Evangelist
- Posts: 6267
- Joined: Tue Dec 21, 2004 5:00 pm
- Location: Winnipeg
Re: How to use trigger to record every moment in database
Google MySQL trigger's - there are enough basic introductory articles to guide you through the process - it's not rocket science.
Cheers,
Alex
Cheers,
Alex
-
kalaithamil
- Forum Newbie
- Posts: 3
- Joined: Fri Jul 01, 2011 4:04 am
Re: How to use events to record every moment in database
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
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
WHY?.... error message?... events are activated?this concept is not working for me
you need to provide much more and precise information to get help.... magic crystal ball doesn't work for us