php - Database structure for storing continuous changing value -

php - Database structure for storing continuous changing value -

language: php, database: mysql

im making mock stock website, have save changing values of specific company overtime. im using cron job run script every hr current value , save database.

my question how shud create construction of database storing these values.

point of concern: if site runs year 1 company generate 8544 values (365*24).

is okay maintain in 1 text field seperated comma (23,56,34,65.....)

my current construction id | name | current_value | changes

id | name | current_value | changes

should sutable structure. create id primary index , auto incrementing, right order order id desc.

an other solution add together timestamp field described above. should have same functionality added feature can see @ later time time value generated!

php mysql sql database