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

Question

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

I assume there is some reason why you can't just put all your SQL files into one and run that? — Jason McCreary
– Jason McCreary, Commented Oct 27, 2010 at 1:12
I am creating one script for each table better structuring and better management. — Maddy.Shik
– Maddy.Shik, Commented Oct 27, 2010 at 1:15

Pablo Santa Cruz · Accepted Answer · 2010-10-27 01:14:58Z

26

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

answered Oct 27, 2010 at 1:14

Pablo Santa Cruz

182k33 gold badges250 silver badges300 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Maddy.Shik Over a year ago

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 Over a year ago

is it possible to give relative path of script files with respect to file that is contain these commands.

Pawan Over a year ago

The mysql workbench displays error "SOURCE (source) is not valid input at this position".

Ezequiel González Macho Over a year ago

This is the same error as in this question stackoverflow.com/questions/45227599/…

Collectives™ on Stack Overflow

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

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related