information for MYSQL

SHOW CURRENLY DATABASE
mysql> select database();

SHOW COMMAND FOR CREATE DATABASE
mysql> show create database db_name

SHOW COMMAND FOR CREATE TABLE
mysql> show create table table_name

SHOW TABLE INDEX
mysql> show index from table_name

RUN BATCH

shell> mysql -u user_name -p < batch_name
OR
mysql> source batch_name;
OR
mysql> \. batch_name;