Find Jobs
Hire Freelancers

MySql developer for some small tasks

₹600-1500 INR

Lezárt
Kiadva ekkor: 23 nappal ezelőtt

₹600-1500 INR

Teljesítéskor fizetve
I need a developer who is well versed with MySQL. I have a database server that has thousands of databases. I need a query that will print the name of all the databases where a specific table has a specific row. For example, consider attached sql script. It creates 5 small dbs, I need a query that will print the names of DB where in sales_target table, there is a row where key=Q1 and value=100
Projektazonosító: 38023592

A projektről

22 ajánlat
Távolról teljesíthető projekt
Aktiválva: 23 nappal ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
22 szabadúszó adott átlagosan ₹1 111 INR összegű árajánlatot erre a munkára
Felhasználó avatár
SQL expert , yes i did similar jobs already , so i can solve it easily, i have understand well what you have describe and asking for the output , can you text me over chat so that we can start
₹1 500 INR 1 napon belül
5,0 (52 értékelés)
6,1
6,1
Felhasználó avatár
Hello, I hope you are doing well. I am an experienced data engineer/ database administrator/ data analyst using ETL Tools (SSIS, Azure Data Factory)/ SQL Server/ Reporting Tools (SSRS, Jasper Report, Power BI) for more than 10 years. I have read your project description and I am very interested in your project. I can help you to create SQL query to return data as your requirement. I can start right now and will provide you the top quality work for sure. Please contact me to discuss more about the detail. Regards,
₹2 000 INR 2 napon belül
4,9 (33 értékelés)
4,4
4,4
Felhasználó avatár
Hello there, I'm an experienced MySQL developer and I can definitely assist you with your query. I understand your requirement for printing the names of databases where a specific table has a specific row. I'm available to start working on this task right away. Let's connect to discuss further details and get started on solving your problem. Best regards, Aliza S.
₹1 050 INR 7 napon belül
5,0 (4 értékelés)
2,6
2,6
Felhasználó avatár
Hi there, I'm a data scientist with some years of experience in SQL and database management. I have understood your requirement and I'm excited about the opportunity to contribute to your team and deliver results efficiently. Looking forward to hearing from you soon. Best regards, Ainy Rehman
₹1 150 INR 7 napon belül
5,0 (1 értékelés)
1,6
1,6
Felhasználó avatár
☀️☀️I have already made the query to get the names of DB where in sales_target table, there is a row where key=Q1 and value=100 using text.sql. Please check this and take from me. Looking forward tp hearing from you. Thank you.
₹1 050 INR 7 napon belül
5,0 (1 értékelés)
0,4
0,4
Felhasználó avatár
I would be an excellent fit for your MySql development needs as I've been deeply involved in web and app development for over seven years. My experience in designing and managing complex databases such as MySQL, PostgreSQL, and MongoDB, aligns directly with the tasks you need to be completed. I have a robust understanding of SQL and the capability to write intricate queries to efficiently fetch the precise data required. Moreover, I possess a strong background in backend technologies such as Node.js, Python (Django/Flask), and Ruby on Rails, which compliments my expertise with MySQL. This synergy allows me to not only solve the initial problem you presented, but also anticipates any probable challenges or complications beforehand. To summarize, my refined skills in database management, fluency in various backend technologies, combined with my extensive practice of SQL make me ready for this challenge. With me onboard, you can trust that your task will be accomplished accurately, timely and with diligence it deserves...
₹1 050 INR 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hello, I have more than 3 year experience as Data analyst. I took training in Data Analytics. and I have work on many project in data analysis , making report and data entry I have work on Excel. My technical skills are Advance Excel, Macros/VBA, Python, MySQL, Power BI and Tableau. so all these skills and experience makes be best for this project . Kindly drop me a message in the chat to initiate a discussion regarding the project's budget and deadline Thank You
₹1 050 INR 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi i have more than 6 year experience on my sql. Let's connect to discuss about your query. Reply within a few hours.
₹1 050 INR 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I am writing to propose my services as a MySQL developer to assist you with your database query requirement. I have extensive experience with MySQL and database querying, which makes me well-suited for this task. I will carefully analyze your database structure and execute a custom SQL query to extract the information you need. The query will efficiently traverse through your thousands of databases and pinpoint the relevant ones, providing you with a concise list of database names meeting your criteria. My approach will ensure accuracy, speed, and reliability in identifying the target databases, streamlining your data management process. I am committed to delivering high-quality results within the specified timeframe and budget.
₹1 000 INR 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I'm well-versed in MySQL and can assist you with your database query requirements. Here's how I plan to approach your request: Understanding the Scope: I'll carefully analyze your database structure and the provided SQL script to ensure a clear understanding of your requirements. Crafting the Query: I'll write a MySQL query that scans all databases on your server and checks if the specified table (sales_target) contains a row where key equals 'Q1' and value equals 100. Testing and Validation: Before finalizing the query, I'll thoroughly test it to ensure accuracy and efficiency in retrieving the desired information from your database server. Once the query is ready, I'll provide you with clear instructions on how to execute it on your server to obtain the names of the databases meeting your criteria. I'm confident in my ability to deliver a solution that meets your needs effectively and look forward to assisting you with your MySQL database query.
₹1 050 INR 5 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I'm Sachin, a SQL executive with 2 years of experience. I'm excited about your project. I took responsibility and I like to work with you. With knowledge skills. Let's discuss how I can assist.
₹600 INR 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi there, As a senior DBA, I can help you to do this project, if you really need someone help you to solve this problem immediately, Please select me.
₹1 500 INR 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hii, I'm pavan kumar currently working as a data engineer in syren cloud. Actually I did same approach in my project also.I hope I will help you With great approach ASAP.
₹1 050 INR 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I am the best fit for this project because I have been working over SQL , Postgresql and databases from over a year.
₹1 050 INR 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I'm an experienced SQL developer proficient in MySQL and Power BI, offering to create a custom query to identify databases containing a specific table row. I'll deliver a well-documented query and provide integration assistance if needed. Task completion will be within hours upon accessing your database server, all at a competitive rate aligned with your budget. With one year of SQL development experience, I assure tailored, high-quality solutions. Let's discuss details and access to proceed promptly. Looking forward to collaborating!
₹1 050 INR 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi I have 20 years of full time experience in database design, development and query optimizations in MySQL, Oracle, SQL Server. I can work in designing databases, writing efficient queries, stored procedures, triggers and optimize queries when required. I have also worked several times on performance monitoring and identifying bottlenecks of databases in MySQL, Oracle and SQL server, using database monitoring scripts and tools. I am Individual freelancer and can work full time or part time as required, provided I get the requirements though meetings or documents. Looking forward to hear from you soon and work together.
₹850 INR 7 napon belül
5,0 (1 értékelés)
0,2
0,2
Felhasználó avatár
Based on my extensive knowledge and experience in database management and SQL, I can confidently say that I am well-versed with MySQL and proficient in writing complex queries. I have a strong understanding of database structures, indexing, and optimization techniques, which allows me to efficiently retrieve the required information even from large databases.
₹600 INR 2 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
As a computer science graduated, with proven experience in development and administration, experience in database development and administration so I will be a good helper to you in your case. it will be my first project in my freelancing career.
₹1 050 INR 2 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
As an experienced MySQL developer, I understand the task at hand involves querying a database server with thousands of databases to identify those containing a specific table with a specified row in a key-value format. To achieve this, I propose to utilize dynamic SQL combined with a cursor to iterate through each database, checking for the presence of the target table and the desired row. Within each database, a SELECT query will be constructed dynamically to check for the existence of the specified row in the target table. This proposal ensures efficiency by minimizing the number of database connections and optimizing the query execution process. Additionally, error handling mechanisms will be implemented to handle any potential issues encountered during the execution of the script. With my expertise in MySQL development and proficiency in handling large-scale database environments, I am confident in delivering a robust and efficient solution to meet your requirements.
₹700 INR 7 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

INDIA zászlója
Delhi, India
0,0
0
Tagság kezdete: ápr. 22, 2024

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.