I am trying to utilize MySQL's batch execution functionality by using build scripts to
create tables in my database (ref:
http://dev.mysql.com/doc/mysql/en/Batch_Commands.html )
Is it possible to execute additional source files from within a source file from the
MySQL command line?
Ex:
mysql> \. c:\file1.sql ## execute the first sql batch file
<file1.sql>
create table employees{...};
\. c:\file2.sql; ## execute the second sql batch file
<eof>
<file2.sql>
create table customers{...};
<eof>
I 've tried this and get an error: "failed to open file 'c:\file2.sql;', error 2