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:
- if there's any "Publish" feature, such that if I run it, it will run all the scripts in my project files.
- 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
Please sign in to leave a comment.