MySQL Publish and Sql script that includes other scripts to run

I have a file structure to keep things in order such that every file has it's own "Create table" script, and then I have some "data insert scripts" that insert data into the tables.

I wanted to know:

  1. if there's any "Publish" feature, such that if I run it, it will run all the scripts in my project files.
  2. If there's any syntax for creating a file that includes all the other files that need to be run.

See sample:

Project

   \Schema

        People.sql

        Animals.sql

        PeoplePets.sql

   \Data << INSERT Scripts

       People.sql

       Animals.sql

      PeoplePets.sql

   Publish.sql

 

In this case publish.sql would include all the above scripts in the order they need to be run in a specific database, in order to create such database structure and populate the database

 

Thanks and regards,

 

Rick

1

Please sign in to leave a comment.