stored procedure syntax error

2010-07-01 Thread DAREKAR, NAYAN (NAYAN)
Hi all ! I m getting an error while writing stored procedure, the code is as below and error CODE -- DELIMITER $$ DROP PROCEDURE IF EXISTS `aaa` $$ CREATE definer=`ro...@`%mailto:definer=`ro...@`%`

Mysql batch file help

2009-08-08 Thread DAREKAR, NAYAN (NAYAN)
Hi Guys, I need a help, as i am new to mysql and i want to create a batch file that can truncate table and Load (LOAD DATA INFILE) one .csv file which is generated every 2min into that table. I have created one batch file where i can only able to login into databse, further my commands are