Mysql batch file help

[NAYAN (NAYAN) DAREKAR]

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.