MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table so (
 n1 float,
 n2 decimal(10,7), -- 10 digits total, 7 after the point
 n3 decimal(6,4) -- 6 digits total, 4 after the point
);
insert into so values (0.0015, 0.0015, 0.0015);
insert into so values (0.0000015, 0.0000015, 0.0000015);
-- won't work because 999 is out of range of n3s scale
insert into so values (999.0015, 999.0015, 999.0015); 

Out of range value for column 'n3' at row 1


select * from so;


n1
n2
n3


0.0015
0.0015000
0.0015

0.0000015
0.0000015
0.0000