Ok, I understand.
In this table page1-1
I need:
- In column
F_SUM
update with sum of colums values F1
, F2
and F3
- In column calculate
AVERAGE_12_MONTHS
the dynamic average of the column F_SUM
The average is dynamic because in the column AVERAGE_12_MONTHS
is a line feed, e.g.:
- In the record number 12 I’ve the average of records 1,2,3,4,5,6,7,8,9,10,11 and 12
- In the record number 13 I’ve the average of records 2,3,4,5,6,7,8,9,10,11,12 and 13
- In the record number 14 I’ve the average of records 3,4,5,6,7,8,9,10,11,12,13 and 14
- …
-- ----------------------------
-- Table structure for `page1-1`
-- ----------------------------
DROP TABLE IF EXISTS `page1-1`;
CREATE TABLE `page1-1` (
`YEARS` varchar(255) DEFAULT NULL,
`MONTHS` varchar(255) DEFAULT NULL,
`F1` varchar(255) DEFAULT NULL,
`F2` varchar(255) DEFAULT NULL,
`F3` varchar(255) DEFAULT NULL,
`F_SUM` varchar(255) DEFAULT NULL,
`AVERAGE_12_MONTHS` varchar(255) DEFAULT NULL,
`VAR` varchar(255) DEFAULT NULL,
`ID` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of page1-1
-- ----------------------------
INSERT INTO `page1-1` VALUES ('2009', '05', '92.626,4', '32.796,56', '59.924,640002', '', '', '', '1');
INSERT INTO `page1-1` VALUES ('2009', '06', '95.008,64', '31.933,6', '56.977,839993', '', '', '', '2');
INSERT INTO `page1-1` VALUES ('2009', '07', '111.853,12', '33.091,92', '53.262,400004', '', '', '', '3');
INSERT INTO `page1-1` VALUES ('2009', '08', '108.379,92', '32.500,48', '60.452,640005', '', '', '', '4');
INSERT INTO `page1-1` VALUES ('2009', '09', '102.605,44', '34.639,36', '58.108,399992', '', '', '', '5');
INSERT INTO `page1-1` VALUES ('2009', '10', '83.442,56', '31.952,400002', '52.181,6', '', '', '', '6');
INSERT INTO `page1-1` VALUES ('2009', '11', '55.527,84', '24.864', '47.962,800004', '', '', '', '7');
INSERT INTO `page1-1` VALUES ('2009', '12', '45.067,28', '21.627,28', '50.793,6', '', '', '', '8');
INSERT INTO `page1-1` VALUES ('2010', '01', '50.108,6386', '32.070,35916', '88.992,39535', '', '', '', '9');
INSERT INTO `page1-1` VALUES ('2010', '02', '45.229,00261', '32.119,99696', '57.848,00256', '', '', '', '10');
INSERT INTO `page1-1` VALUES ('2010', '03', '51.329,99474', '34.104,99888', '64.472,82168', '', '', '', '11');
INSERT INTO `page1-1` VALUES ('2010', '04', '47.097,99864', '38.268,00225', '77.124,0064', '', '', '', '12');
INSERT INTO `page1-1` VALUES ('2010', '05', '43.667,00318', '31.968,99992', '108.472,0064', '', '', '', '13');
INSERT INTO `page1-1` VALUES ('2010', '06', '55.458,99688', '32.521,00124', '103.608', '', '', '', '14');
INSERT INTO `page1-1` VALUES ('2010', '07', '99.716,0032', '33.510,99578', '74.126,99424', '', '', '', '15');
INSERT INTO `page1-1` VALUES ('2010', '08', '101.051,99552', '31.377,0024', '67.117,99712', '', '', '', '16');
INSERT INTO `page1-1` VALUES ('2010', '09', '72.834,00258', '35.291,00016', '81.023,00416', '', '', '', '17');
INSERT INTO `page1-1` VALUES ('2010', '10', '42.791,00364', '44.317,0016', '87.538,9998', '', '', '', '18');
INSERT INTO `page1-1` VALUES ('2010', '11', '41.505,99693', '32.237,00012', '66.770,9952', '', '', '', '19');
INSERT INTO `page1-1` VALUES ('2010', '12', '38.599,005', '27.211,99872', '61.212,99744', '', '', '', '20');
INSERT INTO `page1-1` VALUES ('2011', '01', '55.458,99761', '28.852,99888', '60.279,0048', '', '', '', '21');
INSERT INTO `page1-1` VALUES ('2011', '02', '46.786,00489', '29.952,00224', '58.459,00032', '', '', '', '22');
INSERT INTO `page1-1` VALUES ('2011', '03', '52.550,00568', '32.447,00064', '64.910,76056', '', '', '', '23');
INSERT INTO `page1-1` VALUES ('2011', '04', '39.288,9992', '41.818,0032', '81.383,00113', '', '', '', '24');
INSERT INTO `page1-1` VALUES ('2011', '05', '84.902,99957', '32.890,002', '66.315,99776', '', '', '', '25');
INSERT INTO `page1-1` VALUES ('2011', '06', '94.883,73246', '35.711,45084', '60.993,83012', '', '', '', '26');
INSERT INTO `page1-1` VALUES ('2011', '07', '113.265,999', '38.767,0016', '55.319,98993', '', '', '', '27');
INSERT INTO `page1-1` VALUES ('2011', '08', '122.653,8295', '28.179,25128', '48.713,92516', '', '', '', '28');
INSERT INTO `page1-1` VALUES ('2011', '09', '118.939,00216', '25.380,0064', '44.827,99808', '', '', '', '29');
INSERT INTO `page1-1` VALUES ('2011', '10', '72.671,00321', '35.154,0034', '66.821,9968', '', '', '', '30');
INSERT INTO `page1-1` VALUES ('2011', '11', '52.688,03987', '29.032,06384', '58.792,89148', '', '', '', '31');
INSERT INTO `page1-1` VALUES ('2011', '12', '50.778,1824', '24.184,41893', '52.061,39352', '', '', '', '32');
INSERT INTO `page1-1` VALUES ('2012', '01', '67.452', '27.755,99892', '49.381,99808', '', '', '', '33');
INSERT INTO `page1-1` VALUES ('2012', '02', '65.157,00029', '25.064,9984', '44.974,99776', '', '', '', '34');
INSERT INTO `page1-1` VALUES ('2012', '03', '51.895,99976', '35.507,99695', '62.303,66252', '', '', '', '35');
INSERT INTO `page1-1` VALUES ('2012', '04', '59.680,0026', '34.401,99684', '68.407,00416', '', '', '', '36');
INSERT INTO `page1-1` VALUES ('2012', '05', '76.293,00236', '36.553,00128', '71.262,99872', '', '', '', '37');
INSERT INTO `page1-1` VALUES ('2012', '06', '91.630,00308', '36.862,00284', '63.096,99387', '', '', '', '38');
INSERT INTO `page1-1` VALUES ('2012', '07', '121.355,00758', '35.470,99968', '50.525,99904', '', '', '', '39');
INSERT INTO `page1-1` VALUES ('2012', '08', '104.053,9946', '38.849,00088', '56.643,00224', '', '', '', '40');
INSERT INTO `page1-1` VALUES ('2012', '09', '87.243,99989', '38.957,9976', '62.945,9968', '', '', '', '41');
INSERT INTO `page1-1` VALUES ('2012', '10', '75.514,00438', '35.562,0016', '63.570,9984', '', '', '', '42');
INSERT INTO `page1-1` VALUES ('2012', '11', '47.608,00044', '30.661,00425', '62.245,0048', '', '', '', '43');
INSERT INTO `page1-1` VALUES ('2012', '12', '13.527,2', '10.924,04032', '26.763,04036', '', '', '', '44');
INSERT INTO `page1-1` VALUES ('2013', '01', '15.955,44', '9.888,8', '18.707,36', '', '', '', '45');
INSERT INTO `page1-1` VALUES ('2013', '02', '14.813,76', '9.452,24', '17.036,08', '', '', '', '46');
INSERT INTO `page1-1` VALUES ('2013', '03', '13.567,92', '9.950,64', '18.263,44', '', '', '', '47');
INSERT INTO `page1-1` VALUES ('2013', '04', '12.965,6', '8.086', '17.543,6', '', '', '', '48');
INSERT INTO `page1-1` VALUES ('2013', '05', '12.363,76', '8.034,64', '16.605,04', '', '', '', '49');
INSERT INTO `page1-1` VALUES ('2013', '06', '15.822,88', '8.388,88', '16.211,92', '', '', '', '50');
INSERT INTO `page1-1` VALUES ('2013', '07', '21.269,04', '9.082,4', '16.352,48', '', '', '', '51');
INSERT INTO `page1-1` VALUES ('2013', '08', '18.727,44', '10.274,16', '18.108,96', '', '', '', '52');
INSERT INTO `page1-1` VALUES ('2013', '09', '16.470,56', '8.159,76', '16.271,92', '', '', '', '53');