Rabu, 07 Agustus 2013

PHP Indonesia - Facebook: ada yang bisa memperjelas?? http://mrjoelkemp.com/...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
ada yang bisa memperjelas?? http://mrjoelkemp.com/...
Aug 7th 2013, 12:01, by Cres Thover

Cres Thover 12:01pm Aug 7
ada yang bisa memperjelas??
http://mrjoelkemp.com/2011/04/mysql-event-to-remove-expired-data/

Masdi 12:08pm Aug 7
Ane g buka link nya gan, tp kalo dari jdulny ya itu smacem schedul/jadwal di mysql bwt ngeksekusi query tertentu.

Cres Thover 12:10pm Aug 7
cara mengoperasikannya gimana ya??
SET global event_scheduler = 1;
DROP EVENT IF EXISTS Archive_Old_Posts;
USE teamof4;
CREATE EVENT Archive_Old_Posts
ON SCHEDULE EVERY 1 MINUTE
DO
UPDATE scrims SET scrims.isActive = 0 WHERE scrims.end <= NOW();
INSERT INTO archived_scrims SELECT * FROM scrims WHERE scrims.isActive = 0;
DELETE FROM scrims WHERE scrims.isActive = 0;

maaf newbie

Masdi 12:12pm Aug 7
Pake heidy sql ato sqlyog aja gan.Jadi enak.Kalo pake script lengkep gt mah ane angkt tangan.

Cres Thover 12:13pm Aug 7
:(

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar