views:

31

answers:

1

Suppose I have wrote script Table_ABC.sql which creates table ABC. I have created many such scripts for each of required tables. Now i want to write a script that call all of these script files in a sequence so basically I want another script file createTables.sql. Mysql provides option to execute a script file from "mysql" shell application but could find some command like exec c:/myscripts/mytable.sql. Please tell me if there is any command that can be written in sql script itself to call other one in latest mysql versions or alternative for same.

Thanks

+1  A: 

You can use source command. So your script will be something like:

use your_db;
source script/s1.sql;
source script/s2.sql;
-- so on, so forth
Pablo Santa Cruz
I had already gone through this page. source command run on mysql application but i want to run it on mysql workbench's query analyzer tool. Thanks
Maddy.Shik
is it possible to give relative path of script files with respect to file that is contain these commands.
Maddy.Shik