This may be a bad structure. Let me know if it is, it's been a long time since I did any database design.
I have a tblGame
in a mySQL database, which has two fields:
ID_Table
ID_Player
In the actual game, multiple players will sit on the one table. So I have both fields set as a combined primary key. And ID_Table
is set to auto-increment. ID_Player
is an auto-increment in another table (tblPlayers
). What I'd like to do is to get the ID_Table
value before any players are added to the table. The actual game analogy is to an open table (with ID_Table
already assigned) sitting there waiting for players to join. As they join, they get added to tblGame
.
Is it possible to do this?
tblTable
with the columnsID (autoincrement
anddescription
? You then linktblTable
andtblPlayers
totblGame
. No need to block thetblGame
with irrelevant data.