Execute Multiple SQL files

[Brian Fogarty]

Hi,

Somewhat new to MySQL, and haven't been able to figure out if there is a way using Workbench (or other) to execute a series of saved .sql files via another saved script or procedure or whatever.

Bottom line is I have around 100 saved .sql scripts that will need to be run regularly and would like to either call them all from another "master" script, or figure out the best way to execute them all. Sort of MS SQL Server equivalent of:

exec sp_File1;
exec sp_File2;
.
.
.
exec sp_FileN;

Hope that made sense, and I appreciate any help that can be given.