You can pull the average of the numeric values in a column with SQL in MySQL.
avg()
Select avg(temp) from temp;
Select avg(temp) from temp where macAddress=‘60bbbaa4ae30’
Select avg(temp) from temp where macAddress=‘60bbbaa4ae30’ and timestamp > 1158013757
Select macAddress, avg(temp) from temp group by macAddress
This class shows you how to use Lists and Dictionaries in Python. basic-list.py list-sort.py add-remove-list.py split-list.py basic-dict.py add-remove-dict.py nested-list.py
Creating and Deleting databases on a MySQL server is very easy. Sometimes it can be too easy. show databases; – Shows databases create database databasename; – Creates a database drop database databsename; – Deletes a […]
You can use PHP to access records in a MySQL database and then print them out in HTML. phpSelect.php phpSelectTable.php
Be the first to comment