At 18:27 +0200 5/9/04, Thomas Nyman wrote:
Hi All

I'm a bit perplexed..perhaps its a language thing,,but

the MYSQL reference manual says that

MOD
..Returns the remainder of N divided by M...
and gives an example SELECT MOD(234,10)
                     --> 4

This I do not understand. remainder of N divided by M - isn't that simply division?

It does integer division, and gives you the remainder -- not the quotient.




I mean 234 divided by 10 does not equal 4


On my own machine..if I do SELECT MOD(23,6) I would expect 3,8333 as the result and not 5.

SInce MOD is returning something other than I expect there must be something I am missing....in other words...what is MOD returning??


--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to