Martijn Tonies wrote:
I wonder how I'll get a div-function in SQL?
I dunno, maybe by looking in the manual? From [1]:
Division:
mysql> SELECT 3/5;
-> 0.60
[1] http://dev.mysql.com/doc/mysql/en/arithmetic-functions.html
Gustav is looking for the DIV-function.
But it is there
|DIV|
Integer division. Similar to |FLOOR()| but safe with |BIGINT| values.
He never said he wanted integer division... he just said "I want to
divide t[w]o columns and make a new column based on the result."
Maybe Gustav can say if this is what he wants, but it seems that it is.
Ehm, no. He specifically asked for a DIV function, not a "division". :-)
See above.
With regards,
Martijn Tonies
--
Nuno Pereira
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]