Find Jobs
Hire Freelancers

MySQL Workbench - Trigger and Stored procedures

€8-30 EUR

Avslutat
Publicerad över fem år sedan

€8-30 EUR

Betalning vid leverans
We got 3 tables: Project, ProjectWork, Employee Project: Project INT PK, Projectname VARCHAR ProjectWork: Project FK, Emp INT FK, Hours INT, SumHours INT Employee: Emp INT, PersonalId INT, Lastname VARCHAR, Firstname VARCHAR. I need somebody with experience with triggers to give me 3 triggers: - If I insert new project into projectwork table ---> increase sumhours by the hour value i add. - If I delete a project with its primary key (pk), the trigger shall reduce it by the same hours removed in the sumhours column. - if i update the projectwork row, like from 4 to 5 hours, sumhour should go up too. The whole meaning is too have different sumhours for the different project foreign keys in the projectwork tabell. All in all easy task, just not so experienced with triggers.
Project ID: 17899759

Om projektet

22 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
22 frilansar lägger i genomsnitt anbud på €22 EUR för detta uppdrag
Använd avatar
Hello, As an expert in SQL, i am very much interested to create the required triggers in your database. Just i need a clarification. You told "increase sumhours by the hour value i add." for the first trigger, as you are adding new record, where to increase 'sumhours' ? Better let's discuss more. Thanks
€30 EUR Om 1 dag
5,0 (282 omdömen)
7,5
7,5
Använd avatar
Hello, I am ready to discuss project with you. Being experienced in working on MYSQL projects extensively, I can help you out with triggers you need as per given description quickly and efficiently. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
€15 EUR Om 1 dag
4,8 (120 omdömen)
6,1
6,1
Använd avatar
Hi, I'm interested in your task and would like to do it. I'm available so contact me anytime to get it done......... Thanks.
€30 EUR Om 1 dag
5,0 (28 omdömen)
4,9
4,9
Använd avatar
Hi I have already worked with mysql triggers you can take a look on my profile as I have previous projects with mysql triggers, I am ready to do the trigger you want in no time with minimum cost. Thank You :)
€8 EUR Om 0 dag
5,0 (16 omdömen)
3,7
3,7
Använd avatar
The three triggers can be developed for MySQL. Please let me know and I shall develop it and show it in my local MySQL. I have worked in triggers and SQL stored procedures. Thanks
€16 EUR Om 1 dag
5,0 (17 omdömen)
3,7
3,7
Använd avatar
Hello. I am a Canadian IT Expert and just checked your project, glad to say i have done similar project before. I am 20 years experienced full-stack developer specializing in C#, ASP.NET MVC, SQL Server, TSQL, SQL Service Brokers, Entity Framwork, LINQ,.. Have great understanding of Object Oriented Programming & Database Design. 6 year experience working with Microsoft © I am very interested in your project. Can help you in SQL for Trigger actions over data changes (ADD,UPDATE,DROP) Look no further, and feel free to contact me. Ready to start your work immediately and can do this within your budget :) Thank you for reading this proposal https://www.freelancer.com/u/xenoivan
€27 EUR Om 1 dag
5,0 (11 omdömen)
3,8
3,8
Använd avatar
Hi I am Suraj. I have a lot of experience working with mysql workbench I can create this triggers for you. I can start working on your project Immediately. Lets have a chat to discuss this in more details. Thanks
€15 EUR Om 1 dag
5,0 (7 omdömen)
2,6
2,6
Använd avatar
Hi I can create, procedure and function in MySQL, Oracle, mssql server..... please inbox me for further discussion. Thanks
€29 EUR Om 3 dagar
4,6 (6 omdömen)
2,5
2,5
Använd avatar
Hi! I'd like to do the job. I am linux expert and have a plenty of experience in sql databases. Thank You!
€14 EUR Om 1 dag
5,0 (3 omdömen)
1,8
1,8
Använd avatar
Dear Sir, I will Complete your requirement regarding 3 triggers. Data Base is fun for me.. Thanks and Regards Anubhav P.
€23 EUR Om 1 dag
5,0 (3 omdömen)
0,8
0,8
Använd avatar
Hi there If you choose my bid and send over your MYSQL schema I can write you these triggers same day. Look forward to hearing from you soon.
€19 EUR Om 1 dag
5,0 (2 omdömen)
0,3
0,3
Använd avatar
I have 3 years of experience working on complex MySQL queries, triggers and functions. This job would be easy. :)
€24 EUR Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I can do
€23 EUR Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hey, Trigger have limitation. Due to this Limitation your requirement cannot be solved using triggers. I have a alternative to meet you requirement. Message me and we can discuss further. Regards, Aldrin M
€29 EUR Om 1 dag
0,0 (0 omdömen)
0,5
0,5
Använd avatar
Bringing an experience of 7 years in IT software development, I carry the potential to deliver projects on schedule and ensure the quality of work. My core skills relate to the project very well - SQL database creation and management and writing optimised SQL queries for performing SQL tasks. Also expertised in back end development.
€20 EUR Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
having good experience in database, so no not a tough task for me, I can do it in few hours.. Feel free to contact me.
€8 EUR Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hello, We are a group of two freelancers student engineers. Based on our experience we would be interested in your project of making triggers. This association allows us to have expertise in: - Database conception including triggers. (Advanced database study in UQAC) After analysis of your offer, we estimate the following processes: - Write the SQL code for the desired triggers. Cordially, Charly Moreau.
€24 EUR Om 2 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för NORWAY
Rolvsøy, Norway
5,0
1
Verifierad betalningsmetod
Medlem sedan mars 10, 2017

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.