Jim,
Friday, August 09, 2002, 7:21:48 AM, you wrote:
JB> At the prompt mysql> I type a command : SOURCE SCRIPTS\MT_INV_TBL.TXT.
JB> The command returns the following error message:
JB> Failed to open file [FileName] Error 2.
JB> So what is this error 2. What does it mean?
$ perror 2
Error code
At 10:33 AM -0800 11/29/01, Shankar Unni wrote:
>sherzodR wrote:
>
>>Well, Paul, i think he means using source in an .sql script.
>>Yes you can, Shankar. I used it several times for several reasons :)
>>
>>And u can envoke your sql script the same as you use your other
>>scripts.
>>
>>[EXAMPLE]
>>
sherzodR wrote:
> Well, Paul, i think he means using source in an .sql script.
> Yes you can, Shankar. I used it several times for several reasons :)
>
> And u can envoke your sql script the same as you use your other
> scripts.
>
> [EXAMPLE]
> [...]
> -- in source.sql file:
>
> source query.s
Well, Paul, i think he means using source in an .sql script.
Yes you can, Shankar. I used it several times for several reasons :)
And u can envoke your sql script the same as you use your other
scripts.
[EXAMPLE]
-- in query.sql file:
CREATE TABLE ( id INT, value CHAR(30) )
-- in source.sql
> > database,sql,query,table
>
>
>I notice that "source" is only accepted at the *command line*. This
>means that I can't source a script that sources another file.
>
>I guess "source" is implemented in some special way that prevents it
>from being recursively used?
>
>Is there a way to do what
> > Is there really a SOURCE command?
>
> An explanation why you did not simply try it, would be nice. Maybe
> that would have helped to get an early answer.
>
> > Where is it in the official manual?
>
> This is part of the command line client, the belonging manual section
> is http://www.mysql.co
Hi.
On Tue, Nov 20, 2001 at 09:07:58AM +0800, [EMAIL PROTECTED] wrote:
> The bitbybit.dk MySQL FAQ says:
>
>
> How do I use a batch file with MySQL?
>
> >From within the MySQL client (v. 3.23.9 and above):
>
> mysql> SOURCE filename
>
>
> Is t
