Mysql: How to call sql script file from other sql script file?

Maddy.Shik picture Maddy.Shik · Oct 27, 2010 · Viewed 25.1k times · Source

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

Answer

Pablo Santa Cruz picture Pablo Santa Cruz · Oct 27, 2010

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