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.dare...@alcatel-lucent.com> 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 -pasd1...@# 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=joh...@pixelated.net > > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org