php - Save textFile dates into MySQL

355

I have afile.txt with this dates:

  • "u901_radglobal ""2019-02-01 00:00"" -7.8047 38.56 5.8193586538461"
  • "u901_radglobal ""2019-02-01 00:01"" -22.641 45.36 14.880951785714"
  • "u901_radglobal ""2019-02-01 00:02"" -8.4229 32.996 8.4629222222222"
  • ...

Imagine that is for a only day and from 00:00 to 23:59 soo its abour 1440 columns. I need to put it into a data base.

My idea is :

  • Table sensor : u901_radglobal
  • Table day : 2019-02-01
  • Table dates: 00:00 -7.8047 38.56 5.8193586538461

Soo sensor has a lot of day and avery day has a lot of dates, but i dont know if this is gonna be correct. Can u help me?

People are also looking for solutions to the problem: html - PHP Move_uploaded_file function not working

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.