Call Sql Script From An Other Sql Script

[ftomi]

Hi,

Is it possibile to call an sql script within a query? 🙄

In mysql consol (mysql.exe) it's possibile:

source x.sql

or

. x.sql

calls x.sql. Such lines can be placed inside x.sql too so it can call other scripts too.

Thomas

[peterlaursen]

You are right:

http://dev.mysql.com/doc/mysql/en/batch-mode.html

MySQL command line client implements some functionality/commands that are not SQL commands themselves. Maybe the “source” command should be implemented in SQLyog editor? I am not sure.

If you are running MySQL 5 you can put the batch script in a stored procedure and CALL it(). That is the “standard” way to do it.

[Author]

Posts