domysql.sh

#!/bin/bash
#mysql -h localhost -u root -p --execute "create database teknis"
mysql -h localhost -u root -p <doquery.sql

doquery.sql

drop database if exists test123;
create database test123;
use test123;
create table tbl1(id int primary key auto_increment,name varchar(200),createdate timestamp default current_timestamp);
create table tbl2(id int primary key auto_increment,name varchar(200),createdate timestamp default current_timestamp);