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
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