Thank you for your prompt reply.
Actually, I have various ??.sql files that I can execute thru phpMyAdmin and they all work, but on occasion, there is a need to run all the files at once. So, I was wondering if I could create a file the would call these other files and execute them in sequence, i.e.
Aggregate_file.sql
call first.sql
call second.sql
call third.sql
etc.....
If you have an example of something like this, it would be nice to see.
Thanks.
At 11:48 AM 1/5/03 -0800, wcb wrote:
Hi! I have php files and perl files that create multiple databases and move data around as needed. . . is this what you mean? You could have many such files if you wanted (as you mention below) but it would seem easier to set up some sort of program flow so that under different conditions different databases could be created or dropped or whatever automatically. . . If this is what you mean, then yes, it is being done even as we speak! I could send you one of my inept examples if you want.I believe that phpMyAdmin will allow you to enter SQL commands (say, by copying them from a file and pasting into the SQL code window). Unless you modified phpMyAdmin (which ought to be pretty easy) I think that you'd have to set up an "external" file to create multiple databases and do your bidding with the data. . . Cheers! -warren Filter: mysql, query, queries, bigint ----- Original Message ----- From: "Frank Peavy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, January 05, 2003 11:39 AM Subject: Multiple SQL files > I have multiple SQL files that create different tables. > Is there a way for me to create a single SQL file that will call these > other files? > > Since I am using phpMyAdmin, I am assuming that call this file from > phpMyAdmin?! > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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