SELECT
date(`capturedata`.`CaptureTime`),
sum(`capturedata`.`Data1`),
sum(`capturedata`.`Data2`),
sum(`capturedata`.`Data3`),
sum(`capturedata`.`Data4`),
sum(`capturedata`.`Data5`)
FROM `capture`.`capturedata` group by DATE_FORMAT(`capturedata`.`CaptureTime`, '%Y-%M-%D')