July 27th, 2013, 07:38 PM
Join Date: Jan 2013
Time spent in forums: 1 h 35 m 19 sec
Reputation Power: 0
Multiple INT's in one row?
I am trying to figure out the best way to store some data in my database. I plan on joining 3 different tables.
In the fighters table I have a row for 'moveset' in which I am trying to figure out a way that move_id's from the moveset table can then be associated within the fighters table under the moveset row so each fighter can list a bunch of moves that belongs to them.
fighters table has
moveset (preferably listing multiple move_id's separated by commas)
moveset table has
Multiple move_id's need to get put in the moveset row in the fighters table or something equivalent.
I've thought about compound primary keys but again if a fighter has anywhere from 100 to 200 moves mixed in that there are over 1,000 fighters, the queries and the size of the db alone could get pretty problematic, no?
Any help on how to set this up properly in mysql?