How to use trigger to record every moment in database

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
kalaithamil
Forum Newbie
Posts: 3
Joined: Fri Jul 01, 2011 4:04 am

How to use trigger to record every moment in database

Post by kalaithamil »

hai.
I want to store every min in data base using trigger concept ,any one can help me to solve this problem.
User avatar
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

Post 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?
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

Post 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
kalaithamil
Forum Newbie
Posts: 3
Joined: Fri Jul 01, 2011 4:04 am

Re: How to use events to record every moment in database

Post 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
mikosiko
Forum Regular
Posts: 757
Joined: Wed Jan 13, 2010 7:22 pm

Re: How to use trigger to record every moment in database

Post 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
Post Reply