MySQL Query Expert Needed
$2-8 USD / hour
I want to write an SQL script. I have a table named "cash_requests" and another pivot table named "salary_deduction_file_requests". cash_request_id is a column in salary_deduction_file_requests table. by that column, those two tables are linked.
At a certain point in my system, I change the following fields of those two tables as follows:
cash_requests table
------------
status: "pending_salary_deduction" -> "partialy_salary_deducted"
due_amount: null -> 500
number_of_installments: null -> 2
installment_amount: null -> 500
Pivot table (salary_deduction_file_requests)
----------
action: 'salary_deduction_generated' -> 'processing',
I want to reverse the above changes of the results of the following query:
select * from salary_deduction_file_requests where salary_deduction_file_id=8 and action='processing';
This query returns data of the salary_deduction_file_requests table. I want to reverse the above changes in cash_requests table also. You can use the cash_request_id column of the resulted data for that purpose.
I need you to write a SQL statement to do the above reversal.
Project ID: #38858950
About the project
Awarded to:
With a robust background in MySQL, PHP, Software Architecture, and SQL, I possess the exact skillset required to complete your project. I have a strong track record of designing complex SQL scripts and my proficiency i More
31 freelancers are bidding on average $8/hour for this job
Hi. As an experienced Developer with a focus on Database Administration and MySQL, I have spent many years perfecting my skills in writing efficient, sophisticated SQL queries. Your project requires reverse engineerin More
Hello dinushae5, I carefully reviewed your project description, and it seems like a perfect match for my skills and experience. I am an experienced developer with a strong background in PHP, SQL, Software Architectur More
Hello, We are excited to assist with your SQL scripting needs. Our experienced team specializes in crafting precise and efficient database scripts tailored to complex relationships like the one between cash_requests a More
Hi, Hope you are doing well, Having worked extensively with database management and SQL scripting, I can craft a reliable and efficient script for this task. Additionally, I can implement error handling in the script t More
Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply
Hi, I will fix your deprecated warning issue in wordpress website. I have great experience in wordpress. Let us connect for further discusion. Thanks & Regards kajal gupta
As an experienced backend developer specializing in Laravel and MySQL queries, I bring a wealth of expertise to the table. I have a proven track record of creating and implementing complex SQL scripts to solve intricat More
Hello dinushae5, Our company, Codenia Technologies LLP, with 10+ years of experience in PHP, SQL, and MySQL, has carefully reviewed your project requirement. To reverse the changes in the "cash_requests" table based o More
Hello dinushae5 , We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Job Skills. Lets connect in chat so that More
Hello, client! MySQL expert is here. I can meet SQL response speed and other factors. So dont worry about result and dont hesitate contacting me. Plz contact me I`ll wait for u Thanks, in advance
Dear Client, I have carefully reviewed your project requirements regarding the SQL script to reverse specific changes in the "cash_requests" and "salary_deduction_file_requests" tables. With my expertise in MySQL quer More
Hello, I understand that you need an SQL script to reverse specific changes made to the "cash_requests" and "salary_deduction_file_requests" tables based on the results of a query. I have expertise in MySQL and can ef More
Could you please provide the details about the affected records or if there are any specific conditions for the reversal? To revert the specified changes in both the `cash_requests` and `salary_deduction_file_requests More
