Create a table that take data from another table using mySql (phpMyAdmin)

Question

I am fairly new to MySQL and working on an nba database.

I have a table called gamestats, with a gameID (Game table) playerid (player table) and columns points, rebounds, steals, assist and blocks. This stores data for 1 player per game.

I will then have another table called PlayerStats that should added up all the data from gamestats based on the playerID and calculate the total points, total rebounds, total steals, total assist etc.

So any time I added data into the gamestats it should auto updates to the playerstats.

Hint: trigger.

Gordon Linoff
– Gordon Linoff

2017-04-28 23:55:20 +00:00
Commented Apr 28, 2017 at 23:55 — Gordon Linoff
– Gordon Linoff, Commented Apr 28, 2017 at 23:55

AYR · Accepted Answer · 2017-04-30 06:59:53Z

1

You can create a trigger on Gamestats which will automatically update the specific player's player statistics in the table PlayerStats.

Documentation on triggers: Trigger Syntax and Examples

Much like this:

CREATE TRIGGER trigger_example AFTER INSERT ON gamestats
FOR EACH ROW
  UPDATE BookingRequest
     SET rebounds = rebounds + NEW.rebounds 
   WHERE playerid= NEW.playerid;

answered Apr 30, 2017 at 6:59

AYR

1,1893 gold badges14 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create a table that take data from another table using mySql (phpMyAdmin)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related