MySQL Forums
Forum List  »  Newbie

Re: Finding min é max values for each day
Posted by: Patrick EGLOFF
Date: November 28, 2017 03:56PM

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;

Options: ReplyQuote




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.