Compiling multiple mysql scripts

Question

Can I include other mysql scripts in a compound script? Ideally, I do not want to create a stored procedure for included scripts ... For large projects, I would like to support several smaller scripts hierarchically, and then compose them as needed ... But for now, I would be happy to just learn how to include other scripts .. .

Answer 1

source is a built-in command that you can use in the MySQL client tool (this is what you use to execute the SQL script):

mysql> source otherfile.sql

SQL API, , MySQL MySQL.

Answer 2

MySQL - , . SQL , . "" - , script.