From: Michael Dykman
Date: August 9 2009 1:56am
Subject: Re: Mysql batch file help
List-Archive: http://lists.mysql.com/mysql/218376
Message-Id: <814b9a820908081856w49d6eb7bi1711281ad73a732c@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

Aternatively, you can put all your MySQL commands into a single script
and excute that at the command like


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
-- contents of command file
truncate table cdma_dsr;
load data from infile ...
--end of command file
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

mysql -u user -p mydatabase < commandfile.sql


On Sat, Aug 8, 2009 at 9:55 AM, Johnny Withers<johnny@stripped> wrote:
> 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 th=
at can truncate table and Load (LOAD DATA INFILE) one .csv file which is ge=
nerated =A0every 2min into that table.
>> I have created one batch file where i can only able to login into databs=
e, further my commands are not working the code is as follows:
>> echo off
>> mysql -uroot -pasd123!@# mysql
>> truncate table cdma_dsr; =A0 =A0 =A0 ---- 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: =A0 =A0http://lists.mysql.com/mysql?unsub=3Djohnny@pixel=
ated.net
>>
>>
>
> --
> -----------------------------
> Johnny Withers
> 601.209.4985
> johnny@stripped
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
.com
>
>



--=20
 - michael dykman
 - mdykman@stripped

Don=92t worry about people stealing your ideas. If they=92re any good,
you=92ll have to ram them down their throats!

   Howard Aiken