Bob's weight MySQL

Table:
CREATE TABLE IF NOT EXISTS `bobs_weight` (
`weight` varchar(5) NOT NULL DEFAULT '',
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Find average weight:
SELECT avg( weight ) FROM `bobs_weight`

Leave a Reply

Your email address will not be published. Required fields are marked *