Hi I'm having a simple but annoying problem:
i want to round() the value of a column, but the number of digits is depending on the value of another column. i found out, that this doesn't work: create table testme -> (number double (5,4),digits tinyint(3)); Query OK, 0 rows affected (0.08 sec) mysql> explain testme; +--------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ | number | double(6,4) | YES | | NULL | | | digits | tinyint(3) | YES | | NULL | | +--------+-------------+------+-----+---------+-------+ 2 rows in set (0.08 sec) mysql> insert into testme values (100.4235,3),(85.4,1); Query OK, 2 rows affected (0.08 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> select * from testme; +----------+--------+ | number | digits | +----------+--------+ | 100.4235 | 3 | | 85.4000 | 1 | +----------+--------+ 2 rows in set (0.08 sec) mysql> select round(number,digits) from testme; +----------------------+ | round(number,digits) | +----------------------+ | 100.4240 | | 85.4000 | +----------------------+ 2 rows in set (0.08 sec) is there any way i could do this with *one* query? the only solution i see is to read the digits-column with a script and then create a new query, but thats not possible in my case... thanks for any help Richard -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php