if you want to do sql scripting
then i suggest you use a bash script with the settings i provided to you
oh If you are able to, please don't use HTML mail thanks
cheers
--
Kind regards,
Remko Lodder
Elvandar.org/DSINet.org
www.mostly-harmless.nl Dutch community for helping newcomers on the
hi, to run a sql script from mysql shell just use command source
your_sql_script.sql
if you want to run it directly from prompt use this
mysql --force -uusername -ppassword -esource your_sql_script.sql
- Original Message -
From: Seena Blace [EMAIL PROTECTED]
To: Remko Lodder [EMAIL
Giuseppe Maxia wrote:
12/11/2001 05:32:28, PI Xu [EMAIL PROTECTED] wrote:
Hi, Buddies:
I used perl to run sql commands from a Text file, it always can't finish
totally and report error in unstable lines .
The error report that sql syntax error, but the syntax is same, just same,
and
I used perl to run sql commands from a Text file, it always can't finish
totally and report error in unstable lines .
The error report that sql syntax error, but the syntax is same, just same,
and many sql lines;
Would you please tell me what this happen and how to resolve it?
What you ought to
12/11/2001 05:32:28, PI Xu [EMAIL PROTECTED] wrote:
Hi, Buddies:
I used perl to run sql commands from a Text file, it always can't finish
totally and report error in unstable lines .
The error report that sql syntax error, but the syntax is same, just same,
and many sql lines;
Would you please
Hi,
Try typing:
mysql Temp.sql
while at the DOS prompt.
Andrew
-Original Message-
From: Barbara Ferrell [mailto:[EMAIL PROTECTED]]
Sent: 26 October 2001 2:15 pm
To: [EMAIL PROTECTED]
Cc: barbara
Subject: how to run sql script in NT
i am extremely new at this:
i am on NT4.0
i
You don't need to be at the mysql prompt to run it, just run this from the
DOS prompt:
mysql temp.sql
and that will run mysql.exe and read everything from your temp.sql file.
- Original Message -
From: Barbara Ferrell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: barbara [EMAIL
I'm confused.
You say you are at a dos prompt, but you show a mysql prompt.
At the dos prompt do:
mysql temp.sql
At the mysql prompt:
source temp.sql
Barbara Ferrell wrote:
i am extremely new at this:
i am on NT4.0
i am in a DOS screen at the mysql prompt (mysql)
the path that