Hi,
I need some mysql help
I like to update daily all the by month tags to a database i am not sure how to do it
thanks for any help
beau
Welcome to the Cumulus Support forum.
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
need some mysql help
Moderator: mcrossley
-
mcrossley
- Posts: 12763
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: need some mysql help
I have to ask why? That data can all be derived from the day data can it not? That's the beauty of having the data in a database, you can extract whatever you want.
-
n9mfk
- Posts: 845
- Joined: Sun 10 May 2009 8:52 pm
- Weather Station: davis vp2 Serial datalogger
- Operating System: Windows 7 64-bit
- Location: Springfield, IL
Re: need some mysql help
Hi Mark,
I like to do a page like http://n9mfk.info/cumulusmx/records.php using mysql
but have no idea how?
beau
I like to do a page like http://n9mfk.info/cumulusmx/records.php using mysql
but have no idea how?
beau
-
tobyspond
- Posts: 252
- Joined: Fri 24 Jun 2011 5:57 pm
- Weather Station: Davis Vantage Pro2
- Operating System: Windows 10
- Location: Lamoine, Maine, USA
Re: need some mysql help
Beau,
This should get you started:
SELECT maxtemp, monthname(logdate), day(logdate), year(logdate) from dayfile order by maxtemp desc limit 1
You will need a query for each variable. Mark may have a more elegant method.
Kerry
This should get you started:
SELECT maxtemp, monthname(logdate), day(logdate), year(logdate) from dayfile order by maxtemp desc limit 1
You will need a query for each variable. Mark may have a more elegant method.
Kerry