SQL Trigger to update a second table

Peruttu Julkaistu 6 vuotta sitten Maksettu toimituksen yhteydessä
Peruttu Maksettu toimituksen yhteydessä

I have a form that submits records into multiple tables. As of right now, there is one value that is being written into 2 separate tables. Due to bad coding, there is an issue with one of the values being overwritten. As a quick fix, I am looking for what I assume is 2 triggers, one for insert and one for update, that will take the values from table "A" and update it to table "B".

The structure is as follows:

Table A Fields

username

gameid

value

this matches up to Table B

user

gameid

points

So every time AFTER a user INSERTS or UPDATES Table A, I want all of their records in Table B to be updated so that value and points always match up between the 2 tables. Table A always has the correct value, table B is where the issue is happening.

MySQL

Projektin tunnus: #15152703

Tietoa projektista

24 ehdotusta Etäprojekti Aktiivinen 6 vuotta sitten

24 freelanceria on tarjonnut keskimäärin $58 tähän työhön

amrshawky35

Hi there, What language being used to handle form submission? PHP?

$25 USD 1 päivässä
(64 arvostelua)
7.0
celalaybar

Hello. I can help you with creating sql trigger that updates one table based on other. Relevant Skills and Experience I am good at MySQL. Proposed Milestones $30 USD - Done.

$30 USD 1 päivässä
(41 arvostelua)
5.8
shaoying

hello, I am excellent app and web developer. I can fix your bug within short time. if you are possible,feel free call me at any time.

$50 USD 1 päivässä
(11 arvostelua)
5.4
paulprabhakarand

I have developed 100's of applications using Java, PHP and MYSQL. For many years I working on these technologies, Since I am in expert level will be delivering quality output. Relevant Skills and Experience I have eve Lisää

$50 USD 1 päivässä
(21 arvostelua)
5.1
jcrbahia

Expert experience in Triggers, procedure, and database structure, consult me, do not let someone with no experience perform procedures that damage your base, I can prove my experience and work ASAP. Habilidades y expe Lisää

$40 USD 1 päivässä
(10 arvostelua)
5.2
arityinfoway

I have more than 7+ years of experience in .NET, c#.net, vb.net, asp.net, MVC, VBA, Odoo, sql, mysql, Oracle, Azure, Entity Framework, Linq, Umbraco, Telerik, Devexpress, JQuery, Angularjs, CSS, HTML Relevant Skills a Lisää

$34 USD 1 päivässä
(22 arvostelua)
5.2
ByteSols

Hi, I am Albert Smith from ByteSols located at San Pedro, CA. We have a team of 20+ creative designers and developers. Relevant Skills and Experience MySQL, SQL, NoSQL, MongoDB, DynamoDB, Postgre SQL, and functions li Lisää

$277 USD 1 päivässä
(8 arvostelua)
4.9
vinaysinghh

A proposal has not yet been provided

$20 USD 1 päivässä
(42 arvostelua)
5.0
poojamishra13

Hello sir, i am expert Mysql developer, i would like to make this trigger. Thanks Relevant Skills and Experience MySQL Proposed Milestones $35 USD - Default

$35 USD 1 päivässä
(8 arvostelua)
3.8
L1Ntu

Hello I will make a trigger for your MySQL database Will do this job quickly Regards, Igor Chaban Profession PHP developer, Linux system admin Relevant Skills and Experience linux / mysql Proposed Milestones $40 USD Lisää

$40 USD 1 päivässä
(4 arvostelua)
2.6
ilmarsparols

A proposal has not yet been provided

$25 USD 1 päivässä
(4 arvostelua)
2.3
Elswerkey

The solution seems to be easy, but i need to fully understand the process (like what the site of the database is meant to do) Relevant Skills and Experience I did some sites that have a kinda complicated database. Pr Lisää

$27 USD 1 päivässä
(3 arvostelua)
2.4
KeyboardSolution

***Available to Start work now and able to complete this job. Looking forward for your response. Regards Relevant Skills and Experience mysql Proposed Milestones $100 USD - can discuss on it can discuss in chat r Lisää

$100 USD 1 päivässä
(1 arvostelu)
1.7
Ankushk1990

I provide services on our work and all your requirement will be fulfilled and work according to you with our innovative ideas. Relevant Skills and Experience PHP, Mysql, Postgresql, oracle Proposed Milestones $30 USD Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.0
silverman42

This project will make use of mysql transactions or JOINS. If the back-end of your project is PHP, i am sure to use my experience with php to complete this task Relevant Skills and Experience Php, Mysql, Sqlite, Javas Lisää

$55 USD 1 päivässä
(0 arvostelua)
0.0
mehermadhurs

Here my query is this piece of code for inserting and updating in table A and B will still be present ? If yes then do we know which order A and B is updated i.e. is sequence of table update is fixed or not.

$35 USD 2 päivässä
(0 arvostelua)
0.0