MySQL Forums
Forum List  »  MySQL Administrator

schduling the source command
Posted by: mukesh kurkure
Date: July 08, 2009 11:45PM

Hi All,
when I run source sql.txt or \. sql.txt on dos prompt it will get executed but when I tryied the same on mysql query browser it will not getting executing .

also I want to schdule the queries written in th sql.txt file so i have written following code but it gives me following error .


mysql> create event my on schedule Every 2 minute do source sql.txt;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'a.bat
' at line 1


please provide the solution urgently ..

Thanks in Advance
Mukesh

Options: ReplyQuote


Subject
Written By
Posted
schduling the source command
July 08, 2009 11:45PM


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.