By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
19000+1000 | int(7) | NO | 0 | ||
020000 | int(6) | NO | 0 | ||
20000 | int(5) | NO | 0 | ||
2.222 | decimal(4,3) | NO | 0.000 |
19000+1000 | 020000 | 20000 | 2.222 |
---|---|---|---|
20000 | 20000 | 20000 | 2.222 |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
19000+1000 | decimal(9,3) | NO | 0.000 | ||
020000 | decimal(8,3) | NO | 0.000 | ||
20000 | decimal(7,3) | NO | 0.000 | ||
2 | decimal(4,3) | NO | 0.000 |
19000+1000 | 020000 | 20000 | 2 |
---|---|---|---|
20000.000 | 20000.000 | 9999.999 | 2.000 |
2.222 | 2.222 | 2.222 | 2.222 |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
a | decimal(9,3) | NO | 0.000 | ||
b | decimal(9,3) | NO | 0.000 | ||
c | decimal(8,3) | NO | 0.000 | ||
d | decimal(4,3) | NO | 0.000 |
a | b | c | d |
---|---|---|---|
2.222 | 2.222 | 2.222 | 2.222 |
20000.000 | 20000.000 | 20000.000 | 2.200 |