Dimitar Vassilev asks:
Hello,
Can anyone point me to a section of manual or link how to reduce digits
after
a decimal sign?
I have a table
mysqldesc part;
| Field | Type | Null | Key | Default | Extra |
| kod | varchar(255) | YES | | NULL | |
| bulstat | double(15,5) | YES | MUL | NULL | |
| Land | varchar(3) | YES | MUL | NULL | |
| ID | varchar(15) | YES | MUL | NULL | |
| IME | varchar(100) | YES | MUL | NULL | |
| VALUE | double(15,5) | YES | | NULL | |
| CNT | smallint(5) | YES | | NULL | |
| Date | datetime | YES | | NULL | |
and in bulstat column i have digits like 831690750.00000
which i would like round to the last whole digit.
Also could someone give a hint how to recode digits in order to anonymize
data.
mysql\select round(12.3456789, 3);
mysql\12.345
Can you say more about this:
"Also could someone give a hint how to recode digits in order to anonymize
data."
David