Re: Finding min é max values for each day
Sorry, but i haven't access to the MySQL server. I'm using a shared hosted site.. I onyl have access to phpMyAdmin.
I've made an export of table and create view, i hope this helps ?
CREATE TABLE `releves` (
`id` int(11) NOT NULL,
`date` datetime NOT NULL,
`apaguard` tinyint(3) UNSIGNED NOT NULL,
`poids1` decimal(5,2) NOT NULL,
`poids2` decimal(5,2) NOT NULL,
`poids3` decimal(5,2) NOT NULL,
`poids4` decimal(5,2) NOT NULL,
`temp1` decimal(5,2) NOT NULL,
`temp2` decimal(5,2) NOT NULL,
`temp3` decimal(5,2) NOT NULL,
`temp4` decimal(5,2) NOT NULL,
`temp_ext` decimal(5,2) NOT NULL,
`pression` decimal(6,2) NOT NULL,
`humidite` tinyint(3) UNSIGNED NOT NULL,
`tension` decimal(5,2) NOT NULL,
`csq` tinyint(3) UNSIGNED NOT NULL,
`temp_DS3231` decimal(5,2) NOT NULL,
`infos` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Subject
Written By
Posted
November 26, 2017 01:07PM
November 26, 2017 07:15PM
November 28, 2017 06:56AM
November 28, 2017 09:55AM
November 28, 2017 11:15AM
November 28, 2017 02:12PM
November 28, 2017 02:39PM
November 28, 2017 03:46PM
Re: Finding min é max values for each day
November 28, 2017 03:56PM
November 28, 2017 04:31PM
November 30, 2017 12:17AM
November 30, 2017 11:11AM
November 30, 2017 12:21PM
November 30, 2017 12:44PM
November 30, 2017 01:12PM