Linea21

something like : 0.35 --> 0.3510400045

See https://stackoverflow.com/questions/30024990/mysql-convert-float-to-double

See possible workaround proposed by djmartini :

To achieve this, I have done so:

1 variant: First converted into VARCHAR(255):

sql

ALTER TABLE `my_table`
CHANGE COLUMN `my_value` `my_value` 
VARCHAR(255) NULL DEFAULT NULL AFTER `id`;

Second converted into DOUBLE:

sql

ALTER TABLE `my_table`
CHANGE COLUMN `my_value` `my_value` 
DOUBLE NULL DEFAULT NULL AFTER `id`;

2 variant: First converted into DOUBLE(10,2):

sql

ALTER TABLE `my_table`
CHANGE COLUMN `my_value` `my_value` 
DOUBLE(10,2) NULL DEFAULT NULL AFTER `id`;

Second converted into DOUBLE:

sql

ALTER TABLE `my_table`
CHANGE COLUMN `my_value` `my_value` 
DOUBLE NULL DEFAULT NULL AFTER `id`;

• https://stackoverflow.com/questions/2160810/mysql-whats-the-difference-between-float-and-double
• https://www.geeksforgeeks.org/mysql/decimal-vs-double-vs-float-in-mysql/