微信支付超时 mysql.event

$wtime 使用具体timestamp


         //rand 防推测

            $wev = 'ev_gbuy_create_' . trim($winsert_id) . rand(100, 999);

            $sql = 'CREATE EVENT ' . $wev;

            $wdefault_interval = ' 24  hour ';

            $wdefault_interval = ' 360  SECOND ';

            $wtime = ' CURRENT_TIMESTAMP ';

            $sql .= ' ON SCHEDULE AT ' . $wtime . ' + INTERVAL ' . $wdefault_interval;

            $sql .= ' DO  UPDATE gbuy_create SET is_due=1 WHERE id=' . $winsert_id;

            $this->db->simple_query($sql);

mysql> truncate table mysql.event; Query OK, 0 rows affected (0.00 sec)

mysql> select * from mysql.event; Empty set (0.00 sec)

mysql>

巴特西

微信支付超时 mysql.event

最新文章

热门文章

巴特西

微信支付 超时 mysql.event

最新文章

热门文章

微信支付超时 mysql.event