composing multiple mysql scripts

Question

Is it possible to INCLUDE other mysql scripts in a composite script? Ideally I do not want to create a stored procedure for the included scripts... For larger projects I would like to maintain several smaller scripts hierarchically and then compose them as required... But for now, I'd be happy to just learn how to include other scripts...

cat script1.sql script2.sql script2.sql | mysql

nos
– nos

2009-07-03 20:18:52 +00:00
Commented Jul 3, 2009 at 20:18 — nos
– nos, Commented Jul 3, 2009 at 20:18

Community · Accepted Answer · 2017-05-23 12:26:44Z

2

source is a builtin command you can use in the MySQL client tool (which is what you're using to execute the SQL script):

mysql> source otherfile.sql

If you're executing SQL in a stored procedure or with an API, you should know that MySQL client builtins work only in the MySQL client.

edited May 23, 2017 at 12:26

CommunityBot

11 silver badge

answered Jul 5, 2009 at 2:14

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

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

Comments

Eric · Accepted Answer · 2009-07-03 19:19:51Z

0

MySQL scripts are just a list of commands, to be run in order against the database server. SQL is not a scripting language by any means, so it doesn't behave like one. The only way to "include" other scripts is to concatenate them together when you kick off the script load command.

answered Jul 3, 2009 at 19:19

Eric

95.7k13 gold badges117 silver badges116 bronze badges

Collectives™ on Stack Overflow

composing multiple mysql scripts

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related