I've got a directory structure that contains many different files named foo.sql. I want to be able to cd into this directory & issue a command like the following:

```
find . -name "foo.sql" -exec mysql -uUserName -pUserPasswd < {} \;

```

where {} is the relative path to each foo.sql file. Basically, I want:

```
mysql -uUserName -pUserPasswd < path/to/foo.sql

```

to be run once for each foo.sql file under my subdirectory. I've tried Google & it's been not much help. Ideally this would be part of a UNIX shell script.

Thanks in advance, & sorry if it's been asked before.