Array storage in SQLite

I need to store a set of scores in inte开发者_JAVA百科ger (array of scores) for a player. How can I store an array in a single column? I'm using the SQLite database.

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.