With windows, you can use "type filename.sql | mysql ..."
> Maybe he's running in some windows version??
> It seems to me that your example using std-in is the easiest. I would
> suggest also writing a perl program but in this case I thing your
> example is
> right on. Then again if he's using
al Message-
From: DEVOS BASTIEN [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 7:39 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Run Mysql command from a file.
I'll maybe say something stupid, but if you have your files with your SQL
commands, couldn't you use this
Hello,
On Tue, 15 May 2001, Aires Lima Trindade wrote:
> How to run SQL commands from a text file" but they wasn't clear for me.
> Does anybody can share with me old experience or a real example
> about this case?
C:\mysql\bin>copy con upd.sql
USE akw;
INSERT INTO tmp (id,c1) VALUES(NUL
Sent: Tuesday, May 15, 2001 3:54 PM
> To: Myql List
> Subject: Run Mysql command from a file.
>
> Hi all.
> I'm new in this list, so may be this questions has already done
> here.
> I need to update my database daily at midnight. I want some file
>
the cron job is running with the proper permissions it should
work just fine.
Cal
http://www.calevans.com
-Original Message-
From: Aires Lima Trindade <[EMAIL PROTECTED]>
To: Myql List <[EMAIL PROTECTED]>
Date: Tuesday, May 15, 2001 9:20 AM
Subject: Run Mysql command from a file.
Hi all.
I'm new in this list, so may be this questions has already done
here.
I need to update my database daily at midnight. I want some file
from which I can connect to mysql, switch to some database and work into
tables (basically with delete and load commands).
How can
