List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:August 8 2009 1:55pm
Subject:Re: Mysql batch file help
View as plain text  
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.darekar@stripped> 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 -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.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped
Thread
Mysql batch file helpNAYAN)8 Aug
  • Re: Mysql batch file helpJohnny Withers8 Aug
    • Re: Mysql batch file helpMichael Dykman9 Aug