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`