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