用于存储连续变化值的数据库结构

Question

Language: php, Database: mysql

Im making a mock stock website, so i have to save the changing values of a specific company overtime. Now im using cron job to run a script every hour to get current value and save it to database.

My question how shud i make structure of database for storing these values.

Point of concern: if the site runs for a year one company will generate 8544 values (365*24).

is it okay to keep it in one text field seperated by comma (23,56,34,65.....)

my current structure is id | name | current_value | changes

Answer 1

id | name | current_value | changes

Should be a sutable structure. Make your id a primary index and auto incrementing, then you get the correct order by order by id desc.

An other solution would be to add a timestamp field as described above. That should have the same functionality with the added feature that you can see at a later time EXACTLY what time that value was generated!