Hi! Could we please enable some services and cookies to improve your experience and our website?
CREATE TABLE excel (
Volume varchar(255)
);
INSERT INTO excel VALUES ('36,6'), ('37,1');
SELECT * FROM excel;
UPDATE excel SET Volume = REPLACE(Volume, ',', '.');
ALTER TABLE excel
MODIFY COLUMN Volume decimal(9,2);
SELECT * FROM excel;
SELECT SUM(Volume) FROM excel;