By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `test1` (
`a_number` decimal(5,2) UNSIgNED NOT NULL,
CONSTRAINT `CC1` CHECK (`a_number` > 0.00)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
CREATE TABLE `test2` (
`a_number` decimal(5,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
INSERT INTO test2 VALUES (1.1)
INSERT INTO test1 (a_number)
SELECT a_number FROM test2
SELECT * FROM test1
| a_number |
|---|
| 1.10 |