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

Reply via email to