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.sql
>
> # or \. query.sql
> [/EXAMPLE]
Thanks - that last one (using \.) worked. Using "source" doesn't. In the
above example, if you had the line
source query.sql
in source.sql, then you can't do
% mysql
mysql> source source.sql
ERROR 1064: You have an error in your SQL syntax near 'source query.sql' on
line 1.
But using
\. query.sql
works. So that lets me get on with the scripts.. Thanks again.
--
Shankar.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
