Find Jobs
Hire Freelancers

Create TRIGGER or PROCEDURE in mysql

$2-8 USD / hour

Completed
Posted almost 3 years ago

$2-8 USD / hour

I have the following 3 mysql tables table_availables_dates id date 1 2021-07-27 2 2021-07-28 3 2021-07-29 4 2021-07-30 5 2021-07-31 .... table_requirement_appointments id_requirement first_appointment_date quantity_appointments days_between_appointment 1 2021-07-29 6 3 table_appointments id_appointment date 1 2021-07-29 2 2021-08-02 3 2021-08-05 4 2021-08-08 5 2021-08-11 6 2021-08-14 i need a trigger in table "tablel_requirement_appointments" to insert into table "table_appointments" records according to "quantity_appointments" and "days_between_appointment". if some (or all) dates are not available in table_availables_dates insert record with id and empty date thank you
Project ID: 30978284

About the project

9 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I have just seen your job post that you need to create the TRIGGER or PROCEDURE in MySQL. I assure you that I can do something best for you, let me know if you need a good result with the top quality. So I am here 24/7 to help you out, as I never compromise with the quality of the work and always give the first priority to my clients. Many Thanks!
$5 USD in 20 days
4.6 (9 reviews)
3.4
3.4
9 freelancers are bidding on average $7 USD/hour for this job
User Avatar
hi there, i am a solution architect from Turkey. i am expert on MySQL. i read your description and all is clear. i can do it quickly for fixed price ($50). please contact me. thanks!
$5 USD in 10 days
4.9 (35 reviews)
5.1
5.1
User Avatar
Hello! I hope you are doing well. I am an experienced database administrator using TSQL in long time (sql server, mysql, oracle, postgres, mariadb). You can refer my profile in link https://www.freelancer.com/u/hoaxuyentri I already read your project description and I am very interested in your project. I can help you to write the trigger 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,
$15 USD in 40 days
5.0 (14 reviews)
3.8
3.8
User Avatar
Hello good day, I have deep knowledge of relational databases and SQL. I can create a trigger for you that will automatically fill the second table based on the content of the first table. If you award me the project, I can start working on it right away. Thanks
$5 USD in 40 days
5.0 (4 reviews)
2.3
2.3
User Avatar
Hello Sir. I hope you are fine. Expert available for your task. Highly proficient in SQL and Designing ER Diagram and writing Queries. If you need help regarding project i am here to help you as well . I have gone through the provided image and i assure you that i can do it with perfection. I have done more than 20 projects like this . Feel free to contact me . If you want swift work then count me in. Thanks . Feeling excited to work with you . Regards: Saad Abdullah
$8 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, I am good at Mysql and I know how to fix these kind of problems and I can help you if you send me a detailed message about what you want.
$5 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, niced to meed you, my name is Alen Acosta, CEO from solucionesDTP at Panama. Please clarify to me one question: 1. table table_appointments, field id_appointment has an AutoIncrement field attribute?, or is only a integer field type? Supposing in your example: beforeUpdate Trigger: table_requirement_appointments doesn't has '3 2021-07-29', Trigger set into table_appointments xx --- 2 2021-08-02 3 2021-08-05 4 2021-08-08 5 2021-08-11 6 2021-08-14 In this case xx I suppose Database insert an autoincrement value, it's right? (-- value is '' empty or null depending on file data type or attribute), if this is the case, for all the job (make this trigger), we can bill 60usd and it will be done in a day. Thank you in advance. Best Regards, Alen Acosta. C.E.O. solucionesDTP Panama. Panama.
$6 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, hope you doing well, thanks for posting project, I have saw your projects, I am working on oracle database SQL, PLSQL, Forms & Reports, Database Design using SQL Developer Data Modeler to show clear table relation & generate table script, optimize database since last six years, and on oracle apex, MySQL, Microsoft SQL Server since last 2 years, I will work on your project with great effort, contact me for this project. if you will be done your 1 project with me so in future you will definitely contact me again cause working behavior, effort & response in shaa ALLAH. Regards, Muhammad Shoaib
$8 USD in 15 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PAKISTAN
Hyderabad, Pakistan
5.0
6
Payment method verified
Member since Dec 29, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.