SQL Trigger to update a second table
$10-30 USD
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.
Projektin tunnus: #15152703
Tietoa projektista
24 freelanceria on tarjonnut keskimäärin $58 tähän työhön
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.
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.
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ää
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ää
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
***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ää
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ää
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ää
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.