MYSQL command to execute multiple .sql files

Question

I am wanting to write and execute a single mysql .sql file that will execute multiple other .sql files. I am looking for something equivalent to Oracle's:

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

Does MYSQL have a command?

Answer 1

From bash or any shell, you can run as follows

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

This would execute all for your sql files for 'dbname'

Cheers!!