Hi David,
Why not use a FOR loop in a batch file?
This post seems to be doing the same thing, using MS SQL Server:
http://bytes.com/topic/windows/answers/647680-xp-batch-file-loop-help
Andy
David Scott wrote:
Thanks for responding Gary
I get:
-----------------------------------
Volume in drive D has no label.
Volume Serial Number is C45F-3341
Directory of D:\data\03\09
03/19/2009 05:45 PM 389,305 sessions-20090309-00.sql
03/19/2009 05:45 PM 402,264 sessions-20090309-01. sql
03/19/2009 05:45 PM 417,579 sessions-20090309-02. sql
03/19/2009 05:45 PM 402,084 sessions-20090309-03. sql
<etc>
220 File(s) 50,149,425 bytes
0 Dir(s) 116,891,242,496 bytes free
-----------------------------------
How should I edit this?
--
Dave
2009/3/19 Gary Smith <g...@primeexalia.com>
Dir *.sql > my.bat
Edit batch file for each line to append "| mysql"
Call batch file
Sent via BlackBerry by AT&T
-----Original Message-----
From: David Scott <critt...@desktopcreatures.com>
Date: Thu, 19 Mar 2009 11:08:28
To: <mysql@lists.mysql.com>
Subject: Multiple batch files
HeyaI have folders of sql files which, when there were a few, I executed
using "source d:\folder\file.sql"I now I have 100's, so is there a way to
do
"source d:\folder\*.sql" (which sadly does not work) ?
How would you go about automating this?
The DB is running on a windows box.
Thanks for any suggestions you may have.
--
David Scott
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
