CODEWITHSUNDEEP
phpmysqltime
micker
micker

Reputation: 145

is there a way to have mysql update records at certain times automatically within phpmyadmin

I am not sure how to word this but here is my question:

is there a way to have mysql update records at certain times automatically within phpmyadmin?

Upvotes: 1

Views: 2772

Answers (2)

sectus
sectus

Reputation: 15464

PHPMyAdmin just client for MySQL. But you could use many solutions of it.

Example for cron

0 */2 * * *  mysql -h localhost -u user -ppassword -P 3306 < UPDATE `table` SET `field`='value' WHERE `id`=100500 ;

Example

SET GLOBAL event_scheduler = 1;
CREATE EVENT newEvent
ON SCHEDULE EVERY 2 HOUR
DO
UPDATE `table` SET `field`='value' WHERE `id`=100500 ;

Upvotes: 3

developerCK
developerCK

Reputation: 4506

Mysql Event Scheduler is very good option, if you want to do all in mysql using sql.

there is a good tutorial on site point for this. http://www.sitepoint.com/how-to-create-mysql-events/

if you want to insert some data or update some data or delete some data and on other case also on particular time stamp on a schedule basis.you can easily use this.

Upvotes: 4

Related Questions