How to use Batch Files to Create MySQL Database?

[DANIEL 602]

Hello Friends,
I am trying to make the batch file that can create database of MySQL. I ahve tried a lot but of no use.!! So lastly I thought that some guys will help me over her, so I posted my query over here. Can anyone tell me how to use Batch Files to Create MySQL Database? Please help me as soon as possible.!!

[Allan.d]

You can do anything by using the Batch file. Te following things can be done in MySQL by using the batch files :

• You can create the tables.
• You can create a new database.
• Stored procedures and functions can also be created.
• You can populate the tables with data.
• You can run queries also.

The advantage of a batch file for creating a MySQL database is :

1. You can come to know what have been done by using the batch files.
2. A batch file means that databases are reproducible - either at another time or in another place

[Praetor]

There are many things that can be done shortly by using the batch files. You should be knowing that the common things that database developer has to do is :

1. All of the SQL commands are stored in a text file.
2. Use the mysql command to run the SQL commands in the file.

The batch file for creating the MySQL Database on Windows would be like

c:\sql\create_database.sql

[Viensterrr]

You can have a look at the following coding which is useful for making SQL code for Creating a MySQL Database :
The first lines of the batch file will need to contain the commands for creating the database itself:

drop database if exists suite11_data;
create database suite11_data;
use suite11_data;

The above mentioned codes does :

• deletes the database if it already exists
• it then creates the database
• and then it moves the user into the newly created (but empty) database.

[Modifier]

The following is a SQL Code for Creating a Stored Procedure in a MySQL Database :

delimiter //
create procedure new_user (in fname varchar(25), in add varchar(25), in place varchar(25), in office_name varchar(25))
begin
declare o_id int;
select id into o_id from office
where name = office_name;
insert into user (firstname, address, place, office_id)
values
(fname, add , place , o_id);
end
//
delimiter ;