MySQL SQL Scripts
$10-30 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).
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), Y-d (if yes and has a default), N-d (if no and has a default)
IS_ID is if the column is an identity
IS_vPK and IS_vFK are always blank ''.
IS_PK and IS_FK and contain the name of the [login to view URL] that is referenced as the primary/foreign key
COLUMN_COMPUTED is the computed column formula
If you have any questions, please let me know.
Identifikační číslo projektu: #28763349
O projektu
15 Freelnceři na tento projekt zveřejňují nabídky v průměru $42
-- 20 years SQL expert -- I checked your attached image and understand requirements , i can solve it easily, can start now
I m a database administrator with 9 years of experience in this industry. I read your project details and I understood your needs ,I can do what you want in the deadline just contact me and we can discuss more about th Další
I can develop required queries in a most efficient way because I am highly qualified database developer with more than 10 years length of time professionally worked and with advanced skills in database development.
I have gone through the attachments. Please let me know the scripts that you require to be coded. thanks
I can do it perfectly. Hi i am an Senior SQL , MYSQL Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best qual Další
♦ 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ší
Hey, I have gone through you skills requirement and I can understand your given point just share your details with me and I will start working on it. Thanks, Sajjad.
I have experience building a lot of databases in MySql using PhpMyAdmin and also mysql workbench.I just need the data of what you want and I can make it real.
Hello , At first glance of your allotted task, which is possible from my side. Because I am expert in handling such data base in SQL and Pandas. My area of expertise is in Data Science. would defiantly like to associ Další
I have extensive experience working with DB for about 7+ years now and can get this job done with aptness and as per the desired outcomes.