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
mysql> desc 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
