how to disable to execute MySQL event at creation of it

Asked Apr 13 '15 at 11:38

Active Apr 14 '15 at 05:56

Viewed 241 times

At the execution of MySQL event by default it will executes query which is inside MySQL event.

I want to disable it to execute query at creation.

$this->db->insert("invoice", $data);
$last = $this->db->insert_id();
$str = $this->db->last_query();
$this->db->query("SET GLOBAL event_scheduler =  'OFF'");
$schedule = $this->db->query("CREATE EVENT Recurrence".$last." ON SCHEDULE EVERY 1 MONTH ON COMPLETION PRESERVE ENABLE DO $str");
        $this->db->query("SET GLOBAL event_scheduler =  'ON'");

edited Apr 13 '15 at 11:45

Eqbal Sohrabi

asked Apr 13 '15 at 11:38

Sagar Naliyapara

3,971
5
41
61

YOUR QUESTION IS NOT CLEAR AT ALL? – Alive to die - Anant Apr 13 '15 at 11:49
when MySQL event is created at that time two entries are inserted in invoice table that i want to stop – Sagar Naliyapara Apr 13 '15 at 11:51
either comment your top third lines or move them after event creation code. – Alive to die - Anant Apr 13 '15 at 11:53
still two entries in the table – Sagar Naliyapara Apr 13 '15 at 11:55

how to disable to execute MySQL event at creation of it

0 Answers0