linux foreach import several sql files in folder with mysql terminal

importsqlindir.sh

#query: mysql-u[username] -p[password] -e [query]

for SQL in *.sql; do DB=${SQL/\.sql/}; echo importing $DB; mysql -uroot -p -e  "create database $DB"; done
# first create filenames database

for SQL in *.sql; do DB=${SQL/\.sql/}; echo importing $DB; mysql -uroot -p $DB < $SQL; done
#import file to filename database