Re: Mysql batch file help

2009-08-08 Thread Michael Dykman
Aternatively, you can put all your MySQL commands into a single script and excute that at the command like === -- contents of command file truncate table cdma_dsr; load data from infile ... --end of command file == mysql -u user -p mydatabase < com

Re: Mysql batch file help

2009-08-08 Thread Johnny Withers
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) wrote: > Hi Guys, > > I need a help, as i am new to mysql and