Hi! Sorry Frank, I don't have an example of this. . . however you might try http://phpmyadmin.sourceforge.net/documentation/ and click on "developers" where there are email addresses for the developers. You may find someone who will have nice suggestions that will advance your project!
Cheers! -warren filter: queries, mysql, bigint ----- Original Message ----- From: "Frank Peavy" <[EMAIL PROTECTED]> To: "wcb" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Sunday, January 05, 2003 12:00 PM Subject: Re: Multiple SQL files > Warren, > 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