Re: HOW TO RUN SQL

2004-02-09 Thread KKoTY
AIL PROTECTED]> To: "Remko Lodder" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, February 09, 2004 11:10 PM Subject: HOW TO RUN SQL > how to run sql script like > if i have mysql prompt > mysql > > at above prompt I want to run sql script. how to do

RE: HOW TO RUN SQL

2004-02-09 Thread Remko Lodder
n the hackerscene mrtg.grunn.org Dutch mirror of MRTG -Oorspronkelijk bericht- Van: Seena Blace [mailto:[EMAIL PROTECTED] Verzonden: maandag 9 februari 2004 23:11 Aan: Remko Lodder; [EMAIL PROTECTED] Onderwerp: HOW TO RUN SQL how to run sql script like if i have mysql prompt mysql >

HOW TO RUN SQL

2004-02-09 Thread Seena Blace
how to run sql script like if i have mysql prompt mysql > at above prompt I want to run sql script. how to do this? what will be extenstion of file? Remko Lodder <[EMAIL PROTECTED]> wrote: mysql -p -u -e that can be runned from any shell script. use enum to check Y/N TRUE/

RE: [Mysql-discussions] HOW TO RUN SQL and default value ?

2004-02-09 Thread Remko Lodder
ndag 9 februari 2004 22:14 Aan: [EMAIL PROTECTED] Onderwerp: [Mysql-discussions] HOW TO RUN SQL and default value ? Hi, How to run script at mysql prompt? Like if i want to create a table or select some query and I want to put those sql statement into one file ,how to run that and what would be the e

HOW TO RUN SQL and default value ?

2004-02-09 Thread Seena Blace
Hi, How to run script at mysql prompt? Like if i want to create a table or select some query and I want to put those sql statement into one file ,how to run that and what would be the extention of that query? I want to create on column which contains only default value TRUE or False.how to do tha

RE: How to Run SQL Commands from a Text File stably?

2001-11-12 Thread Daniel J McDonald
>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

Re: How to Run SQL Commands from a Text File stably?

2001-11-12 Thread Denis Hammond
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

Re: How to Run SQL Commands from a Text File stably?

2001-11-11 Thread Giuseppe Maxia
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

How to Run SQL Commands from a Text File stably?

2001-11-11 Thread PI Xu
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 tell me what this happen and how to resolve it? Thank

FW: how to run sql script in NT

2001-10-26 Thread Woolsey, Fred
Forgot to change the "To" address to the list... FCW -Original Message- From: Woolsey, Fred Sent: Friday, October 26, 2001 10:12 AM To: 'Barbara Ferrell' Subject: RE: how to run sql script in NT Barbara, You can "redirect" the script to mysql as input

Re: how to run sql script in NT

2001-10-26 Thread Gerald Clark
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

Re: how to run sql script in NT

2001-10-26 Thread Philip White
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:

RE: how to run sql script in NT

2001-10-26 Thread Andrew Murphy
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

how to run sql script in NT

2001-10-26 Thread Barbara Ferrell
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 is described in the top of the window is: =3D c:\apache\mysql\bin\mysql.exe i wrote a script to create and load a database exactly as it said in the = =3D book.. i saved the file as ..Te