I recently learned how to use MySQL to generate MySQL statements
for several admin-type Data Definition Language (DDL)
SQL queries I needed to execute on the server. For many DBA’s
this is likely nothing new and in fact, is a well-used tool in
their kit. However, I mostly focus on developer-related tasks, so
it is a fresh-in-my-mind learning experience. Continue
reading for more information…
Some backstory for context
I’ve recently been porting over an existing vanilla PHP
application to CodeIgniter 4. One of the new features is
bootstrapping all of the necessary MySQL CREATE
TABLE statements dynamically based on information parsed
from a .fxl file (which is close kin to a .xml file
structure-wise).
Each CREATE TABLE statement is complete with
FOREIGN KEY constraint clauses to ensure data
integrity between linking …
[Read more]