MySQL SQL Scripts -- 2
$30-250 USD
K zaplacení v momentě doručení
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 either Y (for Yes,), N (for No) 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 [login to view URL] 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.
Identifikační číslo projektu: #30775057
O projektu
Uděleno uživateli:
♦ PLSQL Expert ♦ Database Expert ♦ Immediate Start ♦ I’m a software Engineer with 8+ years experience in DB development. I’m expertise in multiple databases MYSQL, Oracle, MSSQL and postgresql. I think I would be right Další
12 Freelnceři na tento projekt zveřejňují nabídky v průměru $140
I can make this 24 hours Hey there, i am developer from the UK with over 9 years experience in web development. Upon reading your project description this seems like a task which i can start on right now and will not Další
Hello, kind regards, currently I have more than 15 years of experience in databases, expert / advanced level using MYSQL SERVER, MARIADB, SQL SERVER, POSTGRESQL. I understand what you need for your project.
Hello, Sir. I read your description carefully. I have 5+ years of experience with Software Development including Desktop App and Web Development. I used C++/Java/Python,React, Vue, Experss JS and PHP etc. I am perfectl Další
Sir, greetings! Thank you for your time and attention. We read through your entire job description and work as a team in our organization. We have a well-trained and experienced staff to complete your job successfully. Další
How are you! I am interested in your project and it's my top skill. I 've already decided to do this task, so you do better consult me. If you do good use of this chance, you will have perfect project and your own new Další
-------------Ready to start working now------------- Hello. Nice to meet you. I am a fullstack development and have 7 years of experiences about Laravel,React,Vue,Android and design. So I can help you. If you need my r Další
HI, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.I have more than 4+years marvellous experienced in Web Development and Web Design. I am fully dedicat Další