MOD returns the remainder of the division, assuming we use integer
arithmetic. I.e.:
234 / 10 = 23
Then 4 remains (234 - (10 * 23))
Or:
23 / 6: (23 - (6 * 3))  = 5

Best ragards
Anders Karlsson
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?

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??

Thomas



-- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm <___/ www.mysql.com Cellphone: +46 708 608121


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



Reply via email to