MySQL Forums
Forum List  »  Newbie

save data
Posted by: src src
Date: December 02, 2018 12:04PM

I want to save some tabular data into MySQL db for every day and every 15 minutes.what is the best data model for this ?

e.g date = 02-12-2018 ..... time 9.15 AM , 9.30,...9. 45 ...till 3.30 PM ....I'll save data in mysql


should I create 3 tables .. one to hold date, one to hold time and one to hold table data ? and they will connected by FK ?

Is there any better solution ?

Options: ReplyQuote


Subject
Written By
Posted
save data
December 02, 2018 12:04PM
December 02, 2018 01:43PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.