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 -e"source your_sql_script.sql"
- Original Message -
From: "Seena Blace" <[EMAIL PROTECTED]>
To: "Remko Lodder" <
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
>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
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
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 y
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
You don't need to be at the mysql> prompt to run it, just run this from the
DOS prompt:
mysql
To: <[EMAIL PROTECTED]>
Cc: "barbara" <[EMAIL PROTECTED]>
Sent: Friday, October 26, 2001 2:15 PM
Subject: how to run sql script in NT
> i am extremely new at this:
>
> i am on NT4.0
>
> i am in a DOS
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
