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 < 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 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
>> 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
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
- michael dykman
Don’t worry about people stealing your ideas. If they’re any good,
you’ll have to ram them down their throats!