You have to execute each command using the mysql command:
@echo off
mysql -u root -ppass --database test truncate table t1
mysql -u root -ppass --database test load data infile ....
On Saturday, August 8, 2009, DAREKAR, NAYAN (NAYAN)
<nayan.darekar@stripped> wrote:
> 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 not working the code is as follows:
> echo off
> mysql -uroot -pasd123!@# mysql
> truncate table cdma_dsr; ---- This line code is not working.
>
> can any one tell me why it is not working.
>
> Thanx and regards,
> nayan d.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
--
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped
