MYSQL command to execute multiple .sql files

Question

I want to write and execute one mysql.sql file that will execute several other .sql files. I am looking for something that is equivalent to Oracle:

@script1.sql
@script2.sql
@script3.sql

Does MYSQL have a command?

Answer 1

From bash or any shell you can work as follows

cat script*.sql | mysql -u root -pYOURPASSWORD  dbname

This will do everything for your sql files for 'dbname'

Hooray!!

Answer 2

source script1.sql;
source script2.sql;
...