On 12/14/17, Tony Papadimitriou <[email protected]> wrote: > > MySQL example: > mysql> select 1/2; > +--------+ > | 1/2 | > +--------+ > | 0.5000 | > +--------+ > 1 row in set (0.13 sec)
MySQL is the only database engine that behaves this way. All others do integer arithmetic on integer values. This is probably the reason that MySQL has the separate "DIV" operator for integer division, whereas everybody else makes due with the standard "/" operator. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
