Thread: Batch Files Create

How to use Batch Files to Create MySQL Database?

I want to make a batch file that can make database of MySQL. I tried several but of no use. As the last option I am posting here. Please suggest me a way to use Batch Files to make MySQL Database? Hoping for a positive response.

1) Following things can be made in MySQL by using the batch files:

• You can make the tables.

• You can make a new database.

• Stored procedures and functions can also be formed.

• You can show the tables with data.

• You can execute queries also.

The promote of a batch file for assembly a MySQL database is:

1. You can understand what have been done by using the batch files.

2. A batch file means that database are reproducible - either at a special time or in a different place

2) There are lots of things that can be done in a minute by using the batch files. You familiar with the thing that database developer has to perform:

1. All of the SQL commands are saved in a text file.

2. Use the mysql command to execute the SQL commands in the file.
The batch file for making the Mosul record on Windows would be like:

c:\sql\create_database.sql