MySQL Forums
Forum List  »  Events (Job Scheduler)

Re: scheduled batch command
Posted by: Anthony Thomas
Date: July 10, 2012 11:24AM

Apparently the solution is to put everything into the sql file. So in my case the content of test.sql should look like this:

delimiter |
create event e_test on schedule every 1 day do
begin
{sql statement 1};
..
{sql statement N};
end |
delimiter ;

Then execute
mysql> source /var/www/home/test.sql;

Options: ReplyQuote


Subject
Views
Written By
Posted
3838
July 10, 2012 06:44AM
Re: scheduled batch command
2026
July 10, 2012 11:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.