On 12/14/17, Tony Papadimitriou <to...@acm.org> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users