Priyanka, see if this helps:

http://dev.mysql.com/doc/refman/4.1/en/batch-commands.html

Priyanka Mishra said:
> I am facing problem in getting the reports.As I was not able to get the
> reports from the package ,I had plans of taking it out through
> queries.cananyone please tell me how do I make a batch file for the
> queries so that the
> librarian need not give individual commands to run queries ,but can
> execute
> a batch file which contains a menu for all the desired kind of reports.
> My work is stuck due to this .I wud really appreciate ur help
>
> --
> Regards
> Priyanka

--
Stephen Hedges
Skemotah Solutions, USA
www.skemotah.com  --  shedges@skemotah.com