MySQL SQL Scripts -- 2
Budget: $30 – $250 USD
I need 2 separate SQL scripts that I can run against a database that produces specific output results.
This must be run against a MySQL database.
This must use standard objects/sql, not user defined sprocs, functions, views, etc. It cannot create objects, it must just run read-only and generate the results.
Please see attached sample (based on Northwind DB). Basically I need a query to output the same as these do.
Max $40
1-Relations:
Output format represents the list of relations constraints between tables.
2-Columns:
Output format is hierarchy where PARENT_ID IS NULL for the table/view, the columns of the table will have that table's ID.
ID is a rownumber.
IS_NULLABLE is either Y (for Yes,), N (for No).
COLUMN_DEFAULT is the default value for the column.
IS_ID is if the column is an identity.
IS_vPK is always blank ''.
IS_vFK is always blank ''.
IS_PK contains comma separated string of the foreign keys that or associated with if this column is primary key.
IS_FK contains the name of the primary key schema.table.column that is referenced by the column if it is a foreign key.
COLUMN_COMPUTED is the computed column formula
If you have any questions, please let me know.
This must be run against a MySQL database.
This must use standard objects/sql, not user defined sprocs, functions, views, etc. It cannot create objects, it must just run read-only and generate the results.
Please see attached sample (based on Northwind DB). Basically I need a query to output the same as these do.
Max $40
1-Relations:
Output format represents the list of relations constraints between tables.
2-Columns:
Output format is hierarchy where PARENT_ID IS NULL for the table/view, the columns of the table will have that table's ID.
ID is a rownumber.
IS_NULLABLE is either Y (for Yes,), N (for No).
COLUMN_DEFAULT is the default value for the column.
IS_ID is if the column is an identity.
IS_vPK is always blank ''.
IS_vFK is always blank ''.
IS_PK contains comma separated string of the foreign keys that or associated with if this column is primary key.
IS_FK contains the name of the primary key schema.table.column that is referenced by the column if it is a foreign key.
COLUMN_COMPUTED is the computed column formula
If you have any questions, please let me know.