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 file:
source query.sql
# or \. query.sql
[/EXAMPLE]
Then you can envoke your source.sql script the same way as you do others
Paul DuBois wrote:
PD: > > database,sql,query,table
PD: >
PD: >
PD: >I notice that "source" is only accepted at the *command line*. This
PD: >means that I can't source a script that sources another file.
PD: >
PD: >I guess "source" is implemented in some special way that prevents it
PD: >from being recursively used?
PD: >
PD: >Is there a way to do what I want (have scripts call other scripts)?
PD: >
PD: >Thx,
PD: >--
PD: >Shankar.
PD:
PD: SOURCE is a command understood by the mysql client program. It's not
PD: part of the version of SQL understood by the client. If you want to use
PD: SOURCE in your scripts, you'll have to parse them yourself and implement
PD: it on the client side.
PD:
PD: ---------------------------------------------------------------------
PD: Before posting, please check:
PD: http://www.mysql.com/manual.php (the manual)
PD: http://lists.mysql.com/ (the list archive)
PD:
PD: To request this thread, e-mail <[EMAIL PROTECTED]>
PD: To unsubscribe, e-mail
<[EMAIL PROTECTED]>
PD: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PD:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
---------------------------------------------------------------------
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
