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