Re: This thing called MOD

2004-05-10 Thread Anders Karlsson
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 ma

Re: This thing called MOD

2004-05-09 Thread Robert A. Rosenberg
At 18:27 +0200 on 05/09/2004, Thomas Nyman wrote about This thing called MOD: 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)

Re: This thing called MOD

2004-05-09 Thread Paul DuBois
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

Re: This thing called MOD

2004-05-09 Thread Giulio
Hi, I use mod a lot simply for fast checking if a number is a multiple of another number if mod(number1,number2) = 0 then number1 is a multiple of number2 Il giorno 09/mag/04, alle 18:44, Robert Reed ha scritto: Thomas MOD is a way to get the remainder from a division problem. It does not ta

Re: This thing called MOD

2004-05-09 Thread Robert Reed
Thomas MOD is a way to get the remainder from a division problem. It does not take into account fractions like we do in real math. It's more basic and elementary. Mod of 5 by 2 would be 1. The answer is 2 remainder 1, thus the MOD is 1. I myself have never used this fuction but I'm sure lots

This thing called MOD

2004-05-09 Thread Thomas Nyman
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 divisi