two text files in one script

[mhalloran]

I have a script that runs a test file:
mysql -uuser -p database < script1.sql

That works but how do append two scripts (script1.sql & script2.sql) into one command?
mysql -uuser -p database < [script1.sql & script2.sql]

Any ideas?

Thanks

[tomhath]

If you're on a unix like os you can use the "cat" command. if you're on Windows you can get a program that does the same thing (look for cat.exe). Or you can change operating systems :evilgrin:

http://david.tribble.com/programs.html

[mhalloran]

Thanks but I can't get it to work. I am on a linux system. I just did it on two lines but I know there's a way to get it to work on one.

mysql -u[user] -p[password] database < script1.sql
mysql -u[user] -p[password] database < script2.sq

that works but this doesn't
mysql -u[user] -p[password] database < cat script1.sql script2.sql

When i just type out cat script1.sql script2.sql the output is correct of course but when I feed it into the mysql command, I get this error:
cat: No such file or directory

I appreciate the post though.