huberton huberton - 1 month ago 7
Java Question

How to insert range of cards in database cell

How can I insert a range of cards like AA-QQ (AA, KK, QQ) in a cell of a database?

I will use Java.

I can't use 2 columns like in this answer because cards aren't numbers.

EDIT:

Maybe I found. I can do a join.

Second table:

ID CARD1 CARD2 CARD3
-- ----- ----- -----
1 AA KK QQ


But if I have four pair of card in next row?

Answer

The best practice would be to use two tables for this purpose.

MainTable:
Id    rest of the approoriate fields
1        ...........
2        ............

Card Event Table:
id main_table_id           order   card
1     1                      1       kk
2     1                      2       qq
3     1                      3       JJ
4     1                      4       AA

Here you can use foreign key to point to MainTable id. That way you dont have to bother about number of cards