From: NAYAN (NAYAN) DAREKAR Date: August 8 2009 6:06am Subject: Mysql batch file help List-Archive: http://lists.mysql.com/mysql/218372 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 gener= ated 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.