Array storage in sqlite

Question

Hi, I am new in iPhone development.I need to store a set of scores in integer (array of scores) for a player.How can i store an array in a single column.I am using sqlite database.

Thanks in advance

Answer 1

Please don't store multiple values in a single column, it makes for much harder queries. You're best to put in another table with a foreign key back to your first table.

   Table 1
    playerID
    playerName

   Table 2
    scoreID
    playerID
    score

Add multiple rows into table 2 and have the playerID in the second table reference playerID in the first table.